Skip to content

Source code for the Kimball-style date dimension generator dimdates.com.

Notifications You must be signed in to change notification settings

dennis-barrett/dimdates-dot-com

Repository files navigation

dimdates.com

Netlify Status

Roadmap

Options to add for data generation:

  • "Unknown date" option
  • Validate column names to prevent weird stuff
  • Loading icon when download is processing
  • SQL code that will generate the dimdates table?

Roadmap items:

  • Pop-up or hover explanations of all options.
  • Allow customising the column prefix for Calendar and Fiscal period columns. (E.g., Fiscal -> Financial.)
  • Have a description of the difference between calendar periods and fiscal periods.
  • Show summary of data that will be exported above "DOWNLOAD DATA" button: number of columns, number of rows, file size (?), etc.
  • Add options for number of records in preview.
  • Allow customising column name case (e.g., camel case, lowercase + underscores, etc.)
  • Add months and days in other languages.
  • Add ability to re-order columns (maybe in the preview?).
  • Add support for public holidays.
  • Export as SQL script that can generate the data.
  • Add article on dimensional modelling and the uses for a date dimension.
  • Dark mode.