Design OLAP star schemas with surrogate keys and SCD Type 2 tracking.
npx skills add https://github.com/guygrigsby/dotfiles --skill olap-schema-design
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
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.
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.
High-intent search queries and answers about installing and using this skill.
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.
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.
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.
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.
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.
databricks-solutionsDefine fact table grain patterns for Gold layer data warehouse design.
JNZader-VaultDevelop Power BI solutions with DAX measures, Power Query transformations, and dashboard designs.
mark64oswaldDesign star and snowflake schemas with fact and dimension tables.
brittaniebuffiecsuRead, search, create, and append content to Markdown notes in an Obsidian vault.
