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