Tutorials — Data, Architecture & Cloud
Practical technical tutorials on Power BI, DAX, Azure, Databricks and much more.
Data Warehouse
How to create a date dimension in a Data Warehouse
Learn how to create a date dimension (calendar table) in a Data Warehouse with SQL: table, load script a…
How to Implement SCD Type 2 in a Data Warehouse
Learn how to implement an SCD Type 2 dimension in a Data Warehouse with simple SQL and keep the full his…
How to model a data warehouse with a star schema
Learn to model a data warehouse with a star schema: fact table, dimensions and surrogate keys, with SQL …
Need expert implementation?
Our team delivers end-to-end data projects — BI, cloud architecture and AI.
Book a free meeting →