Dimensional Data Model Design & Documentation
Design and document dimensional data warehouses with templates and best practices
What You Can Do
You can design production-ready dimensional data models (star schemas, snowflake schemas) from business requirements, generate complete technical documentation including DDL scripts, and validate your schema designs for cardinality, grain alignment, and slowly changing dimension strategies. Claude helps you plan fact and dimension tables, identify conformed dimensions, and create comprehensive ERD descriptions and SQL implementations.
Features
plan fact tables, dimensions, and hierarchies from requirements
validate fact table grain, measure additivity, and dimension join scenarios
implement Type 1, Type 2, and Type 3 with surrogate keys
map reusable dimensions across multiple fact tables and subject areas
create ERD descriptions, data dictionaries, and lineage diagrams
produce CREATE TABLE statements, indexes, and constraints ready for your database
define drill-down paths, aggregate levels, and fact table joins
design bridge tables and effective-dated rows for Type 2 implementation
Example Output
Fact & Dimension Design:
FACT_SALES (Grain: Order Line Item)
├─ DIMENSION_DATE (SCD Type 1)
├─ DIMENSION_CUSTOMER (SCD Type 2 with effective dates)
├─ DIMENSION_PRODUCT (SCD Type 2 with versioning)
└─ DIMENSION_CHANNEL (SCD Type 1)
Measures:
- sales_amount (additive)
- quantity (additive)
- discount_percent (semi-additive)
Generated DDL:
CREATE TABLE dim_customer (
customer_key BIGINT PRIMARY KEY,
customer_id VARCHAR(50),
effective_date DATE,
end_date DATE,
is_current BOOLEAN
);
Documentation Output: Dimension definitions, SCD handling strategy, conformed dimension lineage, and SQL implementation guide.
What's Included
- SKILL.md: Complete dimensional modeling methodology with workflows, validation checklists, and decision trees
- Data Model Templates: Blank star schema canvas, fact table grain worksheet, dimension design template
- SCD Implementation Guides: Type 1, Type 2, and Type 3 slowly changing dimension patterns with SQL examples
- Documentation Templates: Data dictionary template, ERD description format, lineage diagram structure
- Validation Checklists: Grain alignment verification, measure additivity rules, conformed dimension mapping
- SQL Generation Snippets: DDL templates, surrogate key patterns, effective dating logic
Who It's For
- Data warehouse architects designing new enterprise data warehouses
- BI and analytics engineers building dimensional schemas for reporting
- Data engineers implementing fact and dimension tables
- Database designers planning schema structures for analytics
- Solutions architects documenting warehouse designs for client delivery
Best For
- Designing star schemas and snowflake schemas from business requirements
- Planning and validating fact table grain and measure additivity
- Implementing slowly changing dimensions (Type 1, 2, and 3)
- Mapping conformed dimensions across multiple subject areas
- Generating comprehensive schema documentation and DDL scripts
You might also like
You'll develop systematic approaches to injectable formulation design, from API selection through sterilization strategy. Claude helps you troubleshoot failed batches by analyzing root causes, recommends regulatory pathways (505(b)(2), ANDA, NDA), and provides science-backed solutions for stability, compatibility, and manufacturability challenges.
This skill helps you systematically assess integration needs across your systems, design architecture patterns that scale with your organization, and identify technical and operational risks before implementation. You'll receive architecture recommendations aligned to your business constraints, clear integration roadmaps, and risk mitigation strategies that reduce deployment surprises. Get structured decision records suitable for architecture review boards and engineering teams.
Claude analyzes your code diffs and generates standardized commit messages that follow the Conventional Commits specification. The skill automatically determines the correct commit type, scope, and description based on the changes you've made, ensuring your messages are parseable by automation tools while remaining human-readable for code reviewers.
You can transform raw text into structured, labeled datasets for machine learning, analysis, and research. This skill performs named entity recognition, sentiment classification, part-of-speech tagging, and dependency parsing—generating consistent, validated annotations at scale. Use it to prepare corpora, extract entities, classify documents, or perform linguistic analysis without manual annotation.
This skill helps you systematically analyze service mesh architectures, identify inter-service communication failures, and design optimal routing and security policies. You'll receive step-by-step troubleshooting guidance tailored to your mesh platform (Istio, Linkerd, Consul), configuration validation reports, and architectural recommendations that reduce latency, improve observability, and tighten security posture.
This skill automates the creation of production-ready deployment validation checklists, infrastructure-as-code templates, and incident response runbooks tailored to your ML stack. You get comprehensive pre-deployment checks covering model validation, data pipeline integrity, infrastructure readiness, and monitoring setup—all customized for your specific models and cloud provider. The skill generates executable runbooks that teams can follow during incidents, including rollback procedures, failover strategies, and diagnostic commands.
Build scalable internal developer platform architectures that reduce cognitive load and standardize workflows for your development organization. Document golden paths that guide developers through common tasks like onboarding, deployment, and troubleshooting. Map platform capabilities, integrations, and service topology to align with your engineering scale and technical strategy.
Rapidly analyze firmware logs and diagnose hardware issues that cause device failures, connectivity problems, and performance degradation. You'll identify root causes from stack traces, crash dumps, and sensor data, then generate specific optimization recommendations. This skill transforms raw device logs into actionable debugging plans that reduce time-to-resolution from hours to minutes.