Date Table
Date table is a table that is full of each date and various data information like month, day of the week, week number, year and other date related information.
- often implement a date table when the data only represents the date in which an event or transaction occurred, and not all the dates within a specified period
- may contain more than just the dates, including variations of the date
- e.g., Imagine that we want to see which business day in the year holds the most sales
- need to have access to data that has every day of the year over multiple years, the day of the week
- can then combine that date data with the transactions, leveraging a join on the date fields
- this combined data will let us know on which days, like Tuesday, the company sees the most of any given transaction
