Data Dimensional Modeling

Use when the user asks to design a star schema for sales analytics, Kimball fact and dimension tables, grain, conformed dimensions, slowly changing dimensions (SCD Type 2), bus matrix or Data Vault 2.0. Produces a dimensional model with grain, keys, SCD choices and measures. Not for warehouse platform tuning (use data-data-warehouse).

45 stars 6 forksAI, LLMs & Agents

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add j4flmao/agent-skills --skill data-dimensional-modeling
Manual install
git clone --depth 1 https://github.com/j4flmao/agent-skills.git /tmp/agent-skills
mkdir -p ~/.claude/skills
cp -r /tmp/agent-skills/skills/data/dimensional-modeling ~/.claude/skills/data-dimensional-modeling

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# 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)

### Output Artifact
Dimensional model with bus matrix, star schemas, SCD strategy, fact table designs, and DDL statements.

### Response Format
```sql
-- Dimension and fact table DDL
-- SCD implementation
```
```yaml
# Bus matrix
# Grain declaration
```
```markdown
# Design decisions and trade-offs
```

No preamble. No postamble. No explanations. No filler/hedging/transitions.

### Completion Criteria
- [ ] Business process selected and grain declared
- [ ] Bus matrix created showing dimensions by process
Read the full skill on GitHub

Details

Skill name
data-dimensional-modeling
Path
skills/data/dimensional-modeling/SKILL.md
License
MIT
Repo updated
17 November 2026

FAQ

What does the Data Dimensional Modeling skill do?

Use when the user asks to design a star schema for sales analytics, Kimball fact and dimension tables, grain, conformed dimensions, slowly changing dimensions (SCD Type 2), bus matrix or Data Vault 2.0. Produces a dimensional model with grain, keys, SCD choices and measures. Not for warehouse platform tuning (use data-data-warehouse).

How do I install the Data Dimensional Modeling skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add j4flmao/agent-skills --skill data-dimensional-modeling. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Data Dimensional Modeling popular?

It lives in j4flmao/agent-skills, which has 45 GitHub stars and 6 forks.

Related skills

Agent Observability

45

j4flmao/agent-skills

Use when the user asks about agent observability, tracing agent reasoning, debugging an agent loop, OpenTelemetry GenAI spans for LLM calls, LLM cost tracking per agent, agent audit logs or hallucination/eval monitoring in production. Produces instrumentation config, trace schema, dashboards, alerts and cost attribution. Not for generic service tracing without LLMs (use devops-opentelemetry).

DevOps & Cloud

AI Agent Architectures

45

j4flmao/agent-skills

Use when the user asks to build an AI agent, design an agent that calls tools and keeps memory, write an agent system prompt or pick an agent framework (Claude Agent SDK, OpenAI Agents SDK, LangGraph). Produces an architecture brief covering loop, tools, memory, guardrails and evals, routing depth to child skills. Not for workflow patterns (use ai-agentic-workflows).

AI, LLMs & Agents

AI Agent Core Loop

45

j4flmao/agent-skills

Use when the user asks about the agent loop, ReAct vs plan-and-solve, re-planning, Reflexion, an agent stuck in a loop, max iterations or termination conditions. Produces a loop spec or patch with state, success predicate, caps and no-progress detection. Not for overall agent design (use ai-agent-architectures) or tool schemas (use tool-calling-principles).

AI, LLMs & Agents

Data Modeling

45

j4flmao/agent-skills

Use when the user asks about relational or graph data modeling: 3NF normalization, surrogate keys, temporal tables, table inheritance, property graph vs RDF or knowledge graph schemas. Produces a schema-first model with keys, constraints and denormalization rules. Not for Kimball star schemas (use data-dimensional-modeling) or graph DB operations (use data-graph-database).

AI, LLMs & Agents

Data Data Virtualization

45

j4flmao/agent-skills

Use when the user asks about Trino, Presto, Starburst, Dremio, query federation, cross-source joins or connector pushdown. Produces federation architecture, connector config and pushdown and join tuning. Not for warehouse modeling (use data-data-warehouse) or lake table formats (use data-data-lake).

AI, LLMs & Agents

Data Vector Databases

45

j4flmao/agent-skills

Use when the user asks to pick an index type for vector similarity search, pgvector, Qdrant, Milvus, Pinecone, Weaviate, HNSW vs IVF vs PQ, metadata filtering or storing embeddings. Produces vector store choice, collection schema and ANN index settings for recall, latency and memory. Not for full RAG pipeline design (use llm-rag-retrieval-internals).

AI, LLMs & Agents

Browse the most popular Claude skills, all ai, llms & agents skills, or write your own with the skills generator.