What does a Data Warehouse bus matrix communicate, and to whom?
This is part 3 of a 6-part series on the Data Warehouse bus matrix.
Depending on the audience, a Data Warehouse matrix can communicate different things. The audience can be broken down into:
- Executives/Project Management
- End Users/Business Analysts
- Developers
Executives/Project Management:
- The scope of the data warehouse.
- The coverage across business processes.
- The effort required to complete the Data Warehouse. A Data Warehouse Matrix enhanced with automated estimating can communicate effort to Project Managers for duration and cost Estimation. See "Part 5 - estimation" for more detail.
- Progress. By adding color coding to the Data Warehouse matrix, tracking and communicating progress is possible. See "Part 6 - progress" for more details.
End Users/Business Analysts:
- How end-user analytics requirements are satisfied by the Data Warehouse.
- How end-user requirements fit within a broader enterprise-wide reporting framework.
- How end-users can analyze a given Fact by a given set of Dimension attributes.
- How conformed dimensions enable integrated reporting across business processes.
Developers:
- A master plan for data warehouse delivery, providing context for current iterations.
- Overall high-level design.
- Progress. By adding color coding to the Data Warehouse matrix, tracking and communicating progress is possible. See "Part 6 - progress" for more details.