One Big Table vs star schema: when to use each approach
OBT (One Big Table) is popular in modern tools like dbt and Fabric. Understand the real trade-offs against the star sch…
1 min
01 Jun 2026
Modelação de Dados (Kimball)
Modeling for Power BI: optimize the semantic model with VertiPaq
The Power BI VertiPaq engine has unique compression and scan characteristics. Learn to model specifically to get maximu…
2 min
06 Jan 2026
Modelação de Dados (Kimball)
Data Vault 2.0: flexibility and traceability for modern warehouses
Data Vault 2.0 is an alternative to Kimball for environments with unstable data sources and demanding audit requirement…
1 min
13 Aug 2025
Modelação de Dados (Kimball)
Slowly Changing Dimensions Type 2: preserving history in the data warehouse
SCD Type 2 keeps the full history of changes in dimensions. Learn how to implement it in SQL Server and how to choose b…
2 min
20 Mar 2025
Modelação de Dados (Kimball)
Kimball dimensional modeling: a practical guide to facts and dimensions
The Kimball methodology for data warehousing defines fact and dimension patterns that have stood the test of time. Lear…
2 min
25 Oct 2024