Date Dimension with Global Holiday Calendar

Uli Bethke March 21, 2022

Overview 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. The date dimension plays an important role in the data warehouse ...

Read More

 Canada Postal Code on Snowflake Marketplace

Uli Bethke January 25, 2022

Overview Canada’s postal codes are alphanumeric, like Dutch, Irish, and British postcodes. Canadian postal codes are in the format A1A 1A1, where A is a letter and 1 is a digit, with a space separating the third and fourth characters. Although postal codes are usually assigned to geographical areas, special codes are sometimes assigned to ...

Read More

Administrative Boundaries USA

Uli Bethke December 20, 2021

Overview The dataset Administrative Boundaries USA contains border information as polygons about the following divisions of the fifty states, the District of Columbia, Puerto Rico, and the Island areas (American Samoa, the Commonwealth of the Northern Mariana Islands, Guam, and the United States Virgin Islands) of the United States. States Counties Zip Code Tabulation Areas ...

Read More

Data Warehouse 3.0. A Reference Architecture for the Modern Data Warehouse.

Uli Bethke December 9, 2021

Reference data architecture for data management and analytics. An introduction. I frequently come across data architecture diagrams that are riddled with vendor names, tools, and technologies. Tools and technologies have a place in data architecture but it is not a primary role. It is more of a support act than the main act. First and ...

Read More
1 2 3 4 5 25