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 — Core concepts: fact tables, dimensions, slowly-changing dimensions
• DataWarehouseDesign — Warehouse architecture and modeling integration
• DatabaseDesignPatterns — Broader DB design context
• NormalizationAndDenormalization — When each fits

Adjacent

• Data Modeling Fundamentals — Dimensional vs. transactional modeling
• Data Engineering Hub — Where dimensional modeling fits
• DbtAndAnalyticsEngineering — Tool for implementing dimensional models
• EtlVsElt — Where transformations land