olap-schema-design
CommunityDesign fast analytical schemas with Kimball.
Authorguygrigsby
Version1.0.0
Installs0
System Documentation
What problem does it solve?
OLAP schema design enables analytics teams to build scalable, query-optimized read models by applying Kimball's star schema principles, separating read workloads from transactional systems, and hardening the data foundation for BI and dashboards.
Core Features & Use Cases
- Star schema design guidance for fast analytics, BI reporting, and CQRS read models.
- Best practices for surrogate keys, SCD Type 2, conformed dimensions, and denormalized dimensions.
- Domain-specific patterns for time dimensions, role-playing dates, junk dimensions, and index strategies.
Quick Start
Create a star-schema read model for a defined business process, including dim_date, dim_product, dim_customer, and fact_sales with surrogate keys and SCD Type 2 where appropriate.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 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: olap-schema-design Download link: https://github.com/guygrigsby/dotfiles/archive/main.zip#olap-schema-design 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 223,000+ vetted skills library on demand.