Date Dimension Data from the Contonso Dataset

This dataset contains date-related information used for time-based analysis in the Contonso dataset. It includes various representations of date-related attributes, such as year, quarter, month, and day, along with indicators for working days. It is useful for time-series analysis and aggregating data by different time periods.

Usage

date

Format

A data frame with 17 columns:

date

Date The actual date for the record.

date_key

double Unique identifier for the date (often in YYYYMMDD format).

year

double The year part of the date.

year_quarter

character The year and quarter (e.g., "2025 Q1").

year_quarter_number

double The numerical representation of the quarter (e.g., 1, 2, 3, 4).

quarter

character The quarter of the year (e.g., "Q1", "Q2").

year_month

character The year and month (e.g., "2025-03").

year_month_short

character A shortened version of year and month (e.g., "2025 Mar").

year_month_number

double The numerical representation of the year-month (e.g., 202503 for March 2025).

month

character The month name (e.g., "March").

month_short

character The abbreviated month name (e.g., "Mar").

month_number

double The numerical representation of the month (e.g., 3 for March).

dayof_week

character The full name of the day of the week (e.g., "Monday").

dayof_week_short

character The abbreviated day of the week (e.g., "Mon").

dayof_week_number

double The numerical representation of the day of the week (e.g., 1 for Monday).

working_day

double Indicator of whether the date is a working day (1 for working day, 0 for non-working day).

working_day_number

double A numerical indicator for working day (e.g., 1 for working day, 0 for non-working day).

Source

https://github.com/sql-bi/Contoso-Data-Generator-V2-Data/releases/tag/ready-to-use-data