Dimensional Modeling

Purpose

Design robust dimensional data models for analytical workloads following Kimball methodology, star schema best practices, slowly changing dimension strategies, fact table design patterns, and Data Vault 2.0 architecture.

Agent Protocol

Trigger

Exact user phrases: "dimensional modeling", "Kimball", "star schema", "snowflake schema", "bus matrix", "conformed dimension", "slowly changing dimension", "SCD", "fact table", "dimension table", "data vault", "hub link satellite", "grain declaration", "surrogate key", "degenerate dimension".

Input Context

• Business processes to model (sales, inventory, orders, payments)
• Source systems and data granularity
• Reporting and analytics requirements
• Query patterns (aggregations, drill-down, slice-and-dice)
• Data volume and growth rate
• Historical tracking requirements (how far back, what changes to track)
• BI tool requirements (Tableau, Power BI, Looker)