Data Training Courses

Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data

Dates Table

A dates (Calendar) table is used for many exercises and is an essential aspect of any dimensional data model. One is available in an Excel spreadsheet here. This contains an Excel table named Dates. This has a row for every date from 1995 to 2027 inclusive. Each row contains:

• the date column
• columns for the calendar year, quarter, month, day of the month, day of the week, week of the year
• some combination columns such as year-quarter and year-month
• columns for the financial year and quarter. (This assumes that the financial year starts in April.)

For each text column, there is a corresponding numeric key column, with the numbers arranged in chronological order. These are used to sort the text column.