Relative Date Dimension Table (DATE_DIM_VIEW):

One of the many problems analytics professionals need to accommodate on a daily basis is time. Effectively managing time in the field of analytics doesn’t require a new wristwatch, but having the ability to easily slice and dice data on a daily basis. Without a sophisticated date calendar to filter sales by year-to-date versus last-year, analytics professionals waste countless hours every day re-enabling logic that could be provided within a database table.

Mondo Analytics believes so strongly in modern database efficiencies, we’ve developed and shared a standard yearly calendar using the Snowflake Data Exchange. The following documentation is a layout for a standard date dimension to save you time, energy a vastly expand the tools needed for today’s modern database professional.

This calendar has both backward and forward looking dates ranging from the year 2000 thru to the end of the year 2029. For weekly conscious organizations, weeks start on Sundays and end on Saturdays with ‘Y’ flags to differentiate between weekdays and weekends. This calendar also includes statutory holidays to easily enable analytics across long weekends where retail users may want to highlight outliers or plan for additional labor requirements.

It doesn’t matter if you need an easy method to differentiate by day of the week or if you didn’t have a good model to track quarterly sales. The following DATE_DIM_VW contains almost every imaginable feature you could expect in a time calendar.

Viva Analytics!