Скачать или смотреть 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