Strategic planning tool for dimensional data warehouse design
The Enterprise Bus Matrix (also called Data Warehouse Bus Architecture) is a strategic planning and design tool from the Kimball methodology. It's a grid that maps business processes (rows) against conformed dimensions (columns), showing which dimensions are used by which processes.
The Bus Matrix serves as the architectural blueprint for the enterprise data warehouse, ensuring consistent dimension definitions across data marts and enabling integrated cross-process analysis. It's called "bus" because conformed dimensions act like a communication bus connecting different processes.
Each row represents a business process or subject area that generates measurable events. Examples: Order Taking, Shipments, Inventory Snapshots, Customer Service Calls, Product Returns, Financial Transactions.
Each column represents a conformed dimension shared across multiple business processes. Examples: Customer, Product, Date, Location, Employee, Promotion, Payment Method.
A checkmark or "X" in a cell indicates that the business process (row) uses that specific conformed dimension (column). Empty cells mean the dimension is not relevant to that process.
| Business Process | Date | Customer | Product | Store | Promotion | Supplier | Employee |
|---|---|---|---|---|---|---|---|
| Retail Sales | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| Inventory | ✓ | ✓ | ✓ | ✓ | |||
| Purchasing | ✓ | ✓ | ✓ | ✓ | |||
| Shipments | ✓ | ✓ | ✓ | ✓ | |||
| Customer Service | ✓ | ✓ | ✓ | ✓ | ✓ | ||
| Returns | ✓ | ✓ | ✓ | ✓ | ✓ |
List all major business processes that generate measurable events. Focus on processes that stakeholders want to analyze. Examples: Orders, Shipments, Payments, Service Calls, Production Runs.
For each business process, identify the descriptive contexts (who, what, where, when). Look for dimensions that appear in multiple processes - these become conformed dimensions.
Build a grid with processes as rows and potential conformed dimensions as columns. Mark which dimensions are used by which processes.
Look for dimensions appearing in multiple rows. These should be standardized and shared. Define the master definition for each conformed dimension.
Use the matrix to determine which data marts to build first based on business priority and technical dependencies. Start with high-impact processes using well-defined dimensions.
Update the matrix as new business processes are added or requirements change. It's a living document that guides the evolution of your data warehouse.
A conformed dimension is a dimension that has the same meaning and content when referenced from multiple fact tables or data marts. It's managed once and shared across the enterprise.