Sonra: Date Dimension with Global Holiday Calendar – Direct Pay
Date Dimension with Global Holiday Calendar for 86 countries
A date dimension is an essential table in a data model that allows to analyze performance more effectively across different time periods. It should be included in every dimensional model that contains a date or requires date intelligence as part of the analysis.
A key problem when working with dates is the impact of holidays and weekends. To manage this complexity, a holiday calendar is used. A holiday calendar implementation keeps track of which dates are holidays and which are weekends.
Another key problem when working with dates is calculating one date relative to another taking into account holidays, weekends and other conventions.
This holiday calendar contains the data for 86 countries.
The data model includes the following list of tables
The date dim table contains the date range from January 01, 1900 to December 31, 2100.
Country code has all the available countries and its ISO 3166 country code. The code is a two letter code which defines the country name. The other field has the actual country name.
Subdivisions belong to countries. Hence each subdivision has a mapping country as shown in the above data model.
This calendar table contains all the holidays of the particular country. This table has 40 years (20 years previous data and 20 years future data) holiday data for the countries.
This calendar table contains all the holidays of the particular subdivision. This table has 40 years (20 years previous data and 20 years future data) holiday data for the subdivisions.
We have put together a comprehensive documentation which includes a description of all of the tables and columns in the data set and sample queries.
About the Provider:
Sonra offers products and services in data management and data analytics.
Flexter is our flagship product. It automates the conversion of industry data standards, XML, JSON to a relational model on Snowflake, relational databases, and big data formats
Sonra provides Snowflake various professional services, e.g. migration services, quickstarts.
Sonra provides data advisory services, e.g. data architecture and strategy.