Apologizing the delay, but as promised, here I am writing to you about the bus matrix.
The enterprise data warehouse bus matrix is the essential tool for designing and communicating the enterprise data warehouse bus architecture. According to the Kimball's Group technology independent bus matrix architecture allows incremental data warehouse and business intelligence solutions and "identifies and enforces the relationship between business process metrics (fact) and descriptive attributes (dimensions)".
The associated Enterprise Data Warehouse Bus Matrix, shown below, is a key design tool representing the organization’s core business processes and associated dimensionality. It’s the architectural blueprint providing the top-down strategic perspective to ensure data in the DW/BI environment can be integrated across the enterprise, while agile bottom-up delivery occurs by focusing on a single business process at a time. (source: https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/kimball-data-warehouse-bus-architecture/)
If you look at the below diagram, the rows of the matrix showcase the business processes while the columns displaying the dimensions.
The associated Enterprise Data Warehouse Bus Matrix, shown below, is a key design tool representing the organization’s core business processes and associated dimensionality. It’s the architectural blueprint providing the top-down strategic perspective to ensure data in the DW/BI environment can be integrated across the enterprise, while agile bottom-up delivery occurs by focusing on a single business process at a time. (source: https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/kimball-data-warehouse-bus-architecture/)
If you look at the below diagram, the rows of the matrix showcase the business processes while the columns displaying the dimensions.
The design team scans each row to test whether a candidate dimension is well-defined for the business process and also scans each column to see where a dimension should be conformed across multiple business processes. Bus matrix is used as an input to prioritize DW/BI projects with business management as teams should implement one row of the matrix at a time.
The implementation of this should be of more granular where each business process row has been expanded to show specific fact tables or OLAP cubes. At this level of detail, the precise grain statement and list of facts can be documented.
Below is a sample done for the sales department of a local food manufacturer. (Assume that the most granular level of date is day and the location is city)
Below is a sample done for the sales department of a local food manufacturer. (Assume that the most granular level of date is day and the location is city)
Once this is successfully completed, the BA should start with the working on the visualizing the dashboard and report.
I will do my next article on selecting the best visualization to represent the data. Till then please do comment and share your thoughts.
Reference:
https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/enterprise-data-warehouse-bus-matrix/
https://en.wikipedia.org/wiki/Enterprise_bus_matrix
Data warehouse architecture includes a variety of components such as: data sources, extract, transform, load (ETL) processes, data marts, data warehouses, and data mining. There are many ways to create a data warehouse architecture, and the architecture you use will depend on a variety of factors, including the size and complexity of your organization and the needs of your business.
ReplyDelete