04-conformed-dimensions

What problem does it solve?

This Skill addresses the challenge of integrating disparate data sources by ensuring dimensions are consistently defined and usable across multiple fact tables, preventing data silos and enabling cross-process analytics.

Core Features & Use Cases

• Bus Matrix Design: Creates a planning document to map business processes to dimensions, identifying which dimensions need to be conformed.
• Conformed Dimension Rules: Enforces identical naming, keys, attributes, grain, and single source for shared dimensions.
• Shrunken Dimensions: Designs subset dimensions for aggregate fact tables.
• Drill-Across Queries: Enables combining measures from multiple fact tables using conformed dimensions.
• Use Case: When building an enterprise data warehouse, use this skill to define a single dim_product that can be used by both fact_sales and fact_inventory tables, allowing unified reporting on sales and stock levels for the same product.

Quick Start

Use the 04-conformed-dimensions skill to design a bus matrix for sales and inventory fact tables.