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-... Excel:https://drive.google.com/open?id=1tGp... -------------------------------------------------------------------- To view the full play list    • PQB | Power Query Basics   -------------------------------------------------------------------- To subscribe:    / @aaaexcelenglish   --------------------------------------------------------------------- To follow on Facebook:   / excelispower   --------------------------------------------------------------------- To follow on LinkedIn:   / amratef