The Date Dimension: Date Keys, Quarters, Months and Weekdays from a Date
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- 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