How to Create a Conformed Dimension in Data Modeling (Kimball)
How to create a Conformed Dimension in Data Modeling (Kimball): step-by-step to align dimensions across fact tables and…
5 min
08 Aug 2026
How to create a Conformed Dimension in Data Modeling (Kimball): step-by-step to align dimensions across fact tables and…
How to create an incremental snapshot in Data Modeling (Kimball): practical step-by-step to capture periodic states and…
Accumulating snapshot in Data Modeling (Kimball): practical example to create an accumulating fact table and update the…
Learn how to build a periodic snapshot fact table in SQL: define the grain, create the table, run an idempotent daily l…
Learn how to build a factless fact table in SQL to count events and reveal absences in your data warehouse, with a clea…
Learn how to build a bridge table in SQL to solve many-to-many relationships in a star schema and sum values without do…
Learn how to create a junk dimension in your data warehouse to group low-cardinality flags, simplify the fact table, an…
Learn how to build role-playing dimensions in a star schema: reuse a single date dimension in multiple roles, with SQL …
Learn how to build a date dimension in SQL for your data warehouse: table design, date generation, and linking it to th…
OBT (One Big Table) is popular in modern tools like dbt and Fabric. Understand the real trade-offs against the star sch…
The Power BI VertiPaq engine has unique compression and scan characteristics. Learn to model specifically to get maximu…
Data Vault 2.0 is an alternative to Kimball for environments with unstable data sources and demanding audit requirement…
This site uses essential cookies and, with your consent, statistics cookies (Google Analytics) to improve your experience. Cookie Policy