Download Start Excel file: https://ift.tt/2MwVY1F
Download Finished Excel file: https://ift.tt/2MCjWZv
Pdf files with notes: https://ift.tt/2IOoqtJ
This is an alternative method for what we did last video, where we need a report to show all Teams and All Employees regardless of whether or not they had sales. This shows how to deal with a Slowly Changing Dimension where the employees on Teams change over time. See Power Query M Code from Bill Szysz.
Topics:
1. (00:09) Introduction to Data Setup and Goal of Power Query Data Modeling
2. (01:46) Power Query Transformation for Dimension Table into a Fact Table. Including List Syntax to create a list of dates that we can use to expand and repeat the record for each date in the period.
3. (06:06) Build Standard PivotTable Report, including Loading Power Query Output directly to a Standard PivotTable.
4. (06:35) Summary
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Excelisfun, Highline College, Data Analysis, Business Intelligence, BI 348, Mike Girvin, Microsoft Power Tools for Data Analysis 32, MSPTDA 32, MSPTDA 33, MSPTDA 34, MSPTDA 35, Slowly Changing Dimensions, Data modeling Slowly Changing Dimension, Power Query Data Modeling, Power Query M Code, Standard PivotTable, List Syntax, Dates as Whole Numbers, List Syntax Trick for List of Dates, Bill Szysz, Power Query Transformation