PQB05 | Extract data from Access Database | Load to excel data model | Power Query Basics

#excel #powerquery
--------------------------------------------------------------------
Visit the website for more content: www.aaa-power.net
--------------------------------------------------------------------
0:00 Intro
1:55 access data base preview
3:56 Extract data from an access database
6:43 Expand columns to retrieve data from related tables
8:05 Add custom column to calculate sales revenue
11:34 Preview data model & add DAX measures
16:52 Pivot table based on data model to generate sales report
20:35 Close
---------------------------------------------------------------------
To download the working files:
Access: https://drive.google.com/open?id=1jC-fbi6OvSzD8yVVPqIkrmMG4uZamLjM
Excel:https://drive.google.com/open?id=1tGp54EmFHb-os7LprLnBa9ngpn74NJxj
--------------------------------------------------------------------
To view the full play list
https://www.youtube.com/playlist?list=PLX4tbThHdEDeZtxaFwIBbxHCtvrC14SXu
--------------------------------------------------------------------
To subscribe:
https://www.youtube.com/channel/UCAxOgfPN8XqlB-lGmORVB5g?sub_confirmation=1
---------------------------------------------------------------------
To follow on Facebook:
https://www.facebook.com/excelispower
---------------------------------------------------------------------
To follow on LinkedIn:
https://www.linkedin.com/in/amratef

Видео PQB05 | Extract data from Access Database | Load to excel data model | Power Query Basics канала ِAAA Excel English