Excel Data Model & Star Schema Relationships
Load million-row tables via Power Query into Power Pivot and link Dimension tables cleanly to Fact tables (1-to-Many).
Key takeaways while you watch
- Star Schema separates narrow Fact transaction tables from unique Lookup/Dimension tables.
- Draw 1-to-Many relationships instead of copying dimension columns with VLOOKUP/XLOOKUP.
- Hide foreign-key ID columns from client tools so PivotTable users only pick clean fields.
Check: Identify Valid Star Schema Cardinality
In a relationship linking DimProduct[ProductKey] (unique SKU list) to FactSales[ProductKey] (millions of orders), what cardinality does Power Pivot enforce?
| Table | Role | Key Uniqueness |
|---|---|---|
| DimProduct | Lookup / Dimension | Unique ProductKey (1 row per SKU) |
| FactSales | Transactions / Fact | Repeating ProductKey (many orders) |
Module 01 Knowledge Check
Answer all 3 questions and check your score to unlock credit toward completion.