Dimensional Modeling
Designs enterprise-grade dimensional data models, star schemas, and analytical marts using Kimball and Hoberman methodology.
The Dimensional Modeling skill equips Claude Code with structured methodologies to architect enterprise-ready analytical data warehouses and business intelligence marts. Combining Ralph Kimball's classic four-step dimensional design process with Steve Hoberman's Data Model Scorecard quality framework, this skill guides engineers through grain declaration, fact classification (transaction, periodic snapshot, accumulating snapshot, factless), surrogate key assignment, slowly changing dimension (SCD) strategies, and enterprise bus matrix conformance. It is ideal for data engineers, analytics engineers, and BI architects modernizing operational schemas into high-performance, standardized star and snowflake schemas.