DimensionalModeling Hub

Dimensional modeling — fact and dimension tables, star and snowflake schemas — is the standard approach to designing data warehouses. The patterns are decades old; the choices around them shape the performance and usability of analytics systems.

Foundations

- [DimensionalModeling](DimensionalModeling) — Core concepts: fact tables, dimensions, slowly-changing dimensions

- [DataWarehouseDesign](DataWarehouseDesign) — Warehouse architecture and modeling integration

- [DatabaseDesignPatterns](DatabaseDesignPatterns) — Broader DB design context

- [NormalizationAndDenormalization](NormalizationAndDenormalization) — When each fits

Adjacent

- [Data Modeling Fundamentals](DataModelingFundamentals) — Dimensional vs. transactional modeling

- [Data Engineering Hub](DataEngineeringHub) — Where dimensional modeling fits

- [DbtAndAnalyticsEngineering](DbtAndAnalyticsEngineering) — Tool for implementing dimensional models

- [EtlVsElt](EtlVsElt) — Where transformations land