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 and best practic…
4 min
04 Jul 2026
Data Warehouse
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 history of changes…
4 min
04 Jul 2026
Data Warehouse
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 examples.
2 min
20 Jun 2023