Slowly Changing Dimensions Type 2: Valid-From/To and the Right Version by Date
This lesson is part of the course
In this lesson
You close the old versions of Larkfield Home's re-zoned stores with a valid_to date, look up the version that was valid on each sale date and report revenue by the region at the time of sale.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Grain of a Fact Table: One Row per Order Line & the Duplicate Check Locked
- Surrogate vs Natural Keys: Key Mapping and the Unknown Member Locked
- Joining Facts to Dimensions: Enriching Sales with XLOOKUP and INDEX/MATCH Locked
- Aggregating by Dimension Attributes: SUMIFS by Category and Region Locked
- The Date Dimension: Date Keys, Quarters, Months and Weekdays from a Date Locked
- Slowly Changing Dimensions Type 2: Valid-From/To and the Right Version by Date Locked
- Many-to-Many & Bridge Tables: Spotting Double Counting and Allocating with Weights Locked
- Model QA: Orphan Keys, Inner-Join Losses and Reconciling Totals Locked