PQB14: Power Query Basics - Excel.CurrentWorkbook() to extract data & Group by to Summarize data
Channel: AAA Excel’s Power
Date: 2020-05-30

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/1gdq2J3rlUCMQglfd-ACjonO0rnzzmnYj/view?usp=sharing

Finish File:
https://drive.google.com/file/d/1YGCa7VMYzEVN9cCT2s5jLdLv6YVGKTjt/view?usp=sharing

Additional data (Week 4&5):
https://drive.google.com/file/d/1mV3fo5SCTA6IWCq8eu_VaI8UVGdrZak-/view?usp=sharing

To watch video PQB8: 
https://youtu.be/a-C-sccF-TA

To watch the full playlist 
https://www.youtube.com/playlist?list=PL5NlUYOM2iOhZOJL_GM6zNd2k9-IEqmaV

To subscribe to the channel:
https://www.youtube.com/channel/UCqwLHNFtrOjrOC3CnvviS1g?sub_confirmation=1

To follow on Facebook:
https://www.facebook.com/excelispower

To follow on LinkedIn:
https://www.linkedin.com/in/amratef