PQB05: Power Query Basics Extract data from Access Database and load to excel data model
Channel: AAA Excel’s Power
Date: 2019-12-13

Chapters
----------------
0:00 Intro
1:55 Extract sales transactions data from an access database 
7:02 Expand columns to retrieve data from related tables in the access data base
8:25 Add custom column to calculate the sales revenue
10:37 Load query to the data model to speedup your reporting process
11:34 Check your 3m + table inside the power pivot editor
13:14 Add measures to calculate total sales and total quantity (DAX formula)
17:22 Create pivot table based on data model and generate your sales report
==========================
To download the working files:
Access: https://drive.google.com/open?id=1jC-fbi6OvSzD8yVVPqIkrmMG4uZamLjM
Excel:https://drive.google.com/open?id=1tGp54EmFHb-os7LprLnBa9ngpn74NJxj
==========================
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