Tutorials — Data, Architecture & Cloud
Practical technical tutorials on Power BI, DAX, Azure, Databricks and much more.
Data Warehouse
How to Create and Use Surrogate Keys in a Data Warehouse
Learn how to create and use surrogate keys in a Data Warehouse with T-SQL: IDENTITY, the dimension table…
How to model a snowflake schema in a Data Warehouse
Learn how to model a snowflake schema in a Data Warehouse: normalize dimensions into linked tables and a…
How to create a bridge table in a Data Warehouse
Learn how to create a bridge table in a data warehouse to model many-to-many relationships and sum value…
How to create a junk dimension in a Data Warehouse
Learn how to create a junk dimension in a Data Warehouse: combine several flags into one dimension with …
How to use a role-playing dimension in a Data Warehouse
Learn how to reuse a single date dimension in several roles inside a Data Warehouse using SQL JOINs and …
How to create a fact table in a Data Warehouse
Learn how to create a fact table in a Data Warehouse step by step: define the grain, link it to the dime…
Need expert implementation?
Our team delivers end-to-end data projects — BI, cloud architecture and AI.
Book a free meeting →