Guides
Guides
Foundational data modeling guides for analytics engineers.
- Data Vault 2.0 Explained
A practical introduction to Data Vault 2.0 -- hubs, links, and satellites for scalable data warehousing.
- Kimball Dimensional Modeling
An overview of the Kimball approach to dimensional modeling -- from business processes to star schemas.
- Kimball vs Inmon
A side-by-side comparison of the Kimball and Inmon approaches to data warehouse architecture.
- Salesforce Dimensional Modeling
Translate the Salesforce object model into a Kimball star schema. Patterns for the Opportunity timeline, Account hierarchy, and the activity-history mess.
- SAP FI/CO Star Schema Design
Translate SAP Finance and Controlling tables into a clean Kimball star schema. Practical patterns for grain, conformed dimensions, and the document-flow trap.
- SCD Type 2 Implementation
A practical guide to implementing Slowly Changing Dimensions Type 2 — surrogate keys, effective dates, current-row flags, and the MERGE patterns that make it work in production.
- Snowflake Schema vs Star Schema
A practical comparison of snowflake and star schemas — how they differ, when to use each, and why most analytical workloads still favor the star.
- What Is a Star Schema?
A concise guide to star schema -- the central structure of Kimball dimensional modeling for analytics.