Completed
) Introduction including why we need Star Schema
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Power Query Power BI - Transform 2 Fact Tables to Star Schema Data Model - Invoice Data
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction including why we need Star Schema
- 2 ) Import Two Fact Table Data Model in Power BI Desktop using Power Query
- 3 ) Multiply Columns using Multiply feature to calculate “Line Sales”
- 4 ) Merge to lookup Product Weight
- 5 ) Multiply Columns using Multiply feature to calculate “Line Weight”
- 6 ) Group By to aggregate Line Sales and Line Weight in order to get Invoice / Header Level Amounts, but we also Group By Rows to save the Line Item Level data so we can use it later in the query
- 7 ) Merge to lookup Invoice Level Shipping and Discount Amounts
- 8 ) Divide Columns using Divide feature to calculate “Invoice % Discount”
- 9 ) Expand Group By Rows step from earlier in query to get line item detail
- 10 ) Add Data Formatting to Expanded Columns
- 11 ) Multiply Columns using Multiply feature to calculate “Line Discount”
- 12 ) Create Custom Column to calculate “Line Shipping Costs”
- 13 ) Edit the previous two columns by editing the Table.AddColumn function and add the Power Query Function Number.Round
- 14 ) Remove Columns that are not part of the final single Fact Table.
- 15 ) Hide Fact Table we do not need so it is not imported into Data Model, but instead only used in the Power Query Transformation using the “Enable Load” check box option in the list of queries on the …
- 16 ) Close and Apply to Load Star Schema Data Model into the Power BI Desktop Data Model.
- 17 ) Create Relationships between Single Line Item Fact table and the three Dimension Tables.
- 18 ) Create five Measures: Total Sales, Total Shipping, Total Discount, Shipping as % of Sales, Discount as % of Sales.
- 19 ) Hide Columns we don’t need in Report View (Hide in Report View)
- 20 ) Create Visualization that contains the Measures and a Slicer from Each Dimension Table
- 21 ) Summary
