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 can accelerate your entire antenna design workflow—from initial concept to optimized specifications—by leveraging Claude's knowledge of electromagnetic theory, antenna types, and design trade-offs. Claude helps you parameterize designs, identify optimal configurations for your frequency band and application, and prepare detailed briefs for simulation and manufacturing. You'll generate design reviews, impedance-matching solutions, and validation checklists without context-switching to multiple tools.
Rapidly analyze production incidents by correlating observability signals—logs, metrics, traces, and events—to identify the true root cause instead of symptoms. You'll reconstruct incident timelines, quantify impact scope, and generate both immediate remediation steps and long-term prevention measures.
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'll transform high-level feature requirements into a complete development plan covering API design, frontend implementation, testing strategy, and documentation. The skill helps you identify dependencies, parallelize work across frontend and backend teams, and establish quality gates that ensure features ship bug-free with proper error handling and logging.
Transform schema and data changes into production-ready migration packages that protect data integrity and minimize downtime. You can handle column additions, renames, type conversions, and backfills using proven patterns like expand-contract and shadow tables. The skill generates explicit rollback scripts, validation checklists, and phased execution plans that keep applications stable throughout the migration.
You can design end-to-end NGS pipelines tailored to your experiment type (WGS, WES, RNA-seq, targeted), troubleshoot pipeline failures by analyzing QC metrics and logs, and optimize performance by fine-tuning parameters and identifying bottlenecks. This skill handles the full workflow from raw sequencing data quality assessment through variant interpretation and annotation.
You can analyze any NoSQL query—whether MongoDB, DynamoDB, Cassandra, or Firestore—to identify performance bottlenecks, missing indexes, and inefficient data access patterns. You'll receive structured recommendations with before/after comparisons, cost estimates, and refactored queries that dramatically improve performance and reduce database costs.
You can rapidly design, optimize, and validate chromatographic and LC-MS/MS methods for analyzing drugs and metabolites in biological matrices. This skill guides you through analytical method development workflows—including parameter selection, sensitivity optimization, and regulatory strategy—while ensuring ICH Q2(R2) and FDA compliance throughout the development process.