Do You Need a Date Dimension? (Data Modeling 101)

Download the PDF in this video: https://www.skool.com/moderndata/about Consulting Services: https://go.kahandatasolutions.com/adv... -----  In the world of data modeling, date and time are incredibly important concepts. They play a role in pretty much everything we're trying to analyze. For example: When certain transactions or events happened Financial trends over time Comparing volume totals over different periods etc. etc. But when it comes to actually handling this in a data model, it can get a bit tricky. This is where the idea of a "Date Dimension" comes into play. So in this video we're going to talk about why this specific Dimension table is something you may want to consider. And talk through examples of common data points to include. Enjoy! Timestamps: 00:00 Intro 00:22 A Big Topic 00:49 More Attributes 02:56 Business Calendar 04:24 Set & Forget (sort of) 05:54 Considerations 06:59 Putting It Together