Dimensional modeling
Kimball-style dimensional models for analytics workloads — facts, dimensions, and conformed grain.
- Star and snowflake schema design
- Slowly changing dimension strategies (SCD Type 1/2/6)
- Conformed dimensions across business domains
- Aggregate and materialized-view strategy