PQB14: Power Query Basics - Excel.CurrentWorkbook() to extract data & Group by to Summarize data
Excel Data Analysis Series: PQB “Power Query Basics”
PQB14: Excel.CurrentWorkbook() to extract data & Group by to Summarize
In the example:
3 tables containing sales data for the first 3 weeks from January
Required:
Collect data in one table using Power Query (Append)
Select the data required for the report and exclude the unwanted
Auto detect data type
Summarize data using “Group By”
Prepare a dashboard to present daily sales (Slicer + 2 Charts)
Update dashboard automatically when week 4 & 5 added
To download the working files:
Start file:
https://drive.google.com/file/d/1gdq2...
Finish File:
https://drive.google.com/file/d/1YGCa...
Additional data (Week 4&5):
https://drive.google.com/file/d/1mV3f...
To watch video PQB8:
• PQB08: Power Query Basics: Data Trans...
To watch the full playlist
• PQB :Power Query Basics
To subscribe to the channel:
/ @aaaexcel
To follow on Facebook:
/ excelispower
To follow on LinkedIn:
/ amratef