Download Start Excel file: https:\/\/ift.tt\/2qg0tF1
\nDownload Finished Excel file: https:\/\/ift.tt\/2W0DmKJ
\nPdf files with notes: https:\/\/ift.tt\/2IOoqtJ<\/p>\n
In this video learn about how to deal with a \u201cSlowly Changing Dimensions\u201d, which is the Dimension = Employee and the changing Attribute = Team. Learn how to use Power Query to transform the Dimension Table and Fact Table so that we can show Total Sales by Team and Employee using a Standard PivotTable. Learn how to create automatic steps in Power Query and Custom M Code.
\nTopics:
\n1. (00:08) Introduction to Data Setup and Goal of Power Query Data Modeling
\n2. (01:44) Power Query Transformation for Dimension Table, including UnPivot Other Columns.
\n3. (03:30) Power Query M Code Formula to pull Team Key into Fact Table based on three conditions \/ criteria. See the functions Table.AddColumn and Table.SelectRows, and how to Define a Variable for a Custom Function. The Formula does a Three Way Lookup in Power Query.
\n4. (11:09) Build Standard PivotTable Report, including Loading Power Query Output directly to a Standard PivotTable.
\n5. (11:57) Summary<\/p>\n
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.<\/p>\n