kimball_data_modeling
CommunityDesign dimensional models that stay query-ready.
Data & Analytics#data warehouse#kimball#star schema#dimensional modeling#scd2#fact tables#surrogate keys
Authorivanshamaev
Version1.0.0
Installs0
System Documentation
What problem does it solve?
It helps you design dimensional (Kimball) data warehouse models so your facts, dimensions, keys, and SCD handling are consistent and produce correct analytics.
Core Features & Use Cases
- Define the grain and facts correctly: choose the business process, set the atomic row grain, and model measures with the right additivity behavior.
- Build star/snowflake/constellation schemas: design fact tables and denormalized (or normalized) dimensions to match performance and maintainability goals.
- Implement dimension history with SCD types: apply SCD1/SCD2/SCD3/SCD4/SCD6 patterns and write practical DDL/DML load/update strategies.
Quick Start
Use the kimball_data_modeling skill to plan a star-schema data mart for your orders business process by specifying the fact table grain, selecting the right SCD strategy for each dimension, and generating the corresponding DDL and load/update approach.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: kimball_data_modeling Download link: https://github.com/ivanshamaev/de-agent-skills/archive/main.zip#kimball-data-modeling Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.