Modeling the AdventureWorks Data Set
The lesson uses the AdventureWorks data set to illustrate real-world data modeling challenges, explaining the split between sales order header and detail fact tables, the duplicate-amount problem when merging them, and strategies to produce a single correct fact table.
Previous Module
Prepare Data in Power BI Desktop
This Module
Clean, Transform and Load Data
Data Transformation and Star/Snowflake Models
Demo: Power Query Editor Walkthrough
Common Data Transformations
Shaping Data and Column Data Types
Combining and Reshaping Tables
Query Folding
Dynamic Reports with Parameters
Modeling the AdventureWorks Data Set
Star Schema and Table Types