The Grain of a Fact Table: One Row per Order Line & the Duplicate Check
All lessons
- The Grain of a Fact Table: One Row per Order Line & the Duplicate CheckFree
- Surrogate vs Natural Keys: Key Mapping and the Unknown Member Pro
- Joining Facts to Dimensions: Enriching Sales with XLOOKUP and INDEX/MATCH Pro
- Aggregating by Dimension Attributes: SUMIFS by Category and Region Pro
- The Date Dimension: Date Keys, Quarters, Months and Weekdays from a Date Pro
- Slowly Changing Dimensions Type 2: Valid-From/To and the Right Version by Date Pro
- Many-to-Many & Bridge Tables: Spotting Double Counting and Allocating with Weights Pro
- Model QA: Orphan Keys, Inner-Join Losses and Reconciling Totals Pro
You are not signed in — the lab works, but your progress is not saved. Start free
Loading the spreadsheet…