Download Start Excel file: https://ift.tt/2NdZexR
Download Finished Excel file: https://ift.tt/2MKIXl9
Pdf files with notes: https://ift.tt/2IOoqtJ
In this video learn about how to deal with a “Slowly Changing Dimensions”, and how to create a sales report with Employees (Dimension) with a slowly changing Attribute (Team). See how to create the correct grain for the Fact Table and Dimension Table using Power Query, and then see how to load it to the Excel Power Pivot Data Model and create Relationships, DAX Formula and a Data Model PivotTable Report that shows Teams and Employee and how their sales changing over time.
Topics:
1. (00:09) Introduction and Explanation of Problem with Slowly Changing Dimensions when creating Reports.
2. (02:00) Transform Two Dimension Tables into a Lookup Table that can be used in a Merge to bring Employee-Team Unique Identifier into Fact Table
3. (08:27) Build Employee Team Dimension Table
4. (08:45) Load to Data Model
5. (09:18) Build Relationships
6. (09:29) Build DAX Formula
7. (10:03)Build Data Model PivotTable Report
8. (11:06) Summary
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.