dimensional

What problem does it solve?

This Skill helps translate conceptual and logical data models into physical dimensional models, addressing the complexities of star schema, fact/dimension design, and temporal tracking.

Core Features & Use Cases

• Physical Design Mapping: Guides the conversion of entities and relationships into dimensional structures (dimensions, facts, bridges).
• History and Temporal Strategy: Provides clear rules for handling data mutability and temporal tracking (SCD types, valid/transaction time).
• Inheritance and Enum Handling: Offers patterns for modeling inheritance and managing enumerations within dimensional models.
• Use Case: A data architect needs to design a star schema for customer orders. This Skill will guide them on how to model customers, products, and order events as dimensions and facts, including how to handle slowly changing dimensions for customer attributes.

Quick Start

Use the dimensional skill to design a physical dimensional model for customer and order data.