Data Dimensional Modeling

Use this skill when designing dimensional data models — Kimball star schemas, Data Vault 2.0, slowly changing dimensions, fact table design, or bus matrix development. This skill enforces: Kimball 4-step methodology (business process, grain, dimensions, facts), star schema design with conformed dimensions, SCD Type 0-6 selection, fact table granularity and additive/non-additive measures, and Data Vault 2.0 hub/link/satellite modeling. Do NOT use for: OLTP normalization, NoSQL data modeling, or data lake table format design.

j4flmao Updated 41 repo stars

File contents

j4flmao/agent-skills commit 99f4b62392

Frequently asked questions

npx get-skill add j4flmao/data-dimensional-modeling