Date Dimension Data from the Contonso Dataset

Description

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