The Date Dimension: Date Keys, Quarters, Months and Weekdays from a Date
This lesson is part of the course
In this lesson
You build the columns of a date dimension (integer date key, quarter label, weekday name) from plain dates with YEAR, MONTH, ROUNDUP and TEXT, and use the quarter attribute to summarise revenue.
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