0:00 Intro
1:30 Demo begin
2:45 Power Query – Text Between Delimiters to pull out SKU number
6:12 XLOOKUP to fetch SKU number related product name
9:00 Summarize with PivotTable
11:28 Analyze with PivotTable Charts
11:55 Insert Timeline to filter dashboard sales graph by dates
Leave A Comment