olap-schema-design

Design OLAP star schemas with surrogate keys and SCD Type 2 tracking.

Updated Nov 30, 2018

Search Tags:#cqrs #data-warehouse #dimensional-modeling #star-schema #kimball #olap

Ready to run

npx skills add https://github.com/guygrigsby/dotfiles --skill olap-schema-design

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: olap-schema-design
Source: https://github.com/guygrigsby/dotfiles/tree/main/opencode/skills/olap-schema-design
Command: npx skills add https://github.com/guygrigsby/dotfiles --skill olap-schema-design

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

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.

Frequently Asked Questions about olap-schema-design

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I design a star schema for a data warehouse?▼

Designing a star schema requires defining a grain-first business process, building fact tables, and linking denormalized dimensions. This Skill guides you through creating fact and dimension tables with surrogate keys to optimize analytical queries and BI reporting.

What is the best way to track slowly changing dimensions in OLAP?▼

Tracking slowly changing dimensions in OLAP is best achieved using SCD Type 2 with surrogate keys. This Skill implements SCD Type 2 patterns to maintain historical accuracy for conformed dimensions across your data warehouse read models.

Can I use Kimball dimensional modeling for CQRS read models?▼

Yes, you can use Kimball dimensional modeling for CQRS read models by applying star schema principles to separate analytical read workloads. This Skill targets CQRS read models, optimizing them with conformed dimensions and indexing strategies.

How do I handle role-playing dates and junk dimensions in dimensional modeling?▼

Handling role-playing dates and junk dimensions in dimensional modeling requires specific schema patterns to manage multiple date contexts and low-cardinality attributes. This Skill provides domain-specific patterns for time dimensions, role-playing dates, and junk dimensions.

Does star schema design improve BI reporting query performance?▼

Yes, star schema design improves BI reporting query performance by using denormalized dimensions and indexing strategies to maximize query speed. This Skill enforces grain-first design and surrogate keys to build scalable, query-optimized read models for BI dashboards.