My first Publication Agile-Data-Warehouse-Design-eBook | Page 123
102
Chapter 4
Scan down the
matrix columns to
identify potential
conformed
dimensions
Scan across the
matrix rows to
compare process
complexity
Start with a high-
level matrix to help
you plan
dimensionally
Scanning down the dimension columns reveals the potential for dimensional
conformance. Conformed dimensions that could form a data warehouse bus show
up with multiple ticks. The contrast between these valuable dimensions that
support cross-process analysis (Hurray!) and the non-conformed dimensions that
do not (Boo!) should encourage everyone to work towards conformance.
Scanning across the process rows helps to estimate the complexity of a business
process: generally, the more dimension ticks, the more complex a process is likely
to be and the more resource needed to define its business events and implement
them.
It’s a good idea to start your agile DW/BI project by creating a high-level matrix to
help you plan your data warehouse design from a conformed dimensional process
measurement perspective from the outset. You may want to add to it some of the
additional features of the event matrix described below.
Use a high-level dimensional matrix to gain support from senior business and IT
management for conforming dimensions.
The Event Matrix
The event matrix is
a modelstorming
version of the
dimensional matrix
It contains details
for BEAM✲ event
An event matrix is a more detailed version of the dimensional matrix. It is a busi-
ness event-level modelstorming tool designed to be filled in by/with stakeholders,
using the 7Ws framework. Figure 4-6 shows an event matrix version of the Figure
4-5 manufacturing processes. The additional details on this matrix include:
Event Sequences: Business events, including their main clause short stories,
recorded in time/value/process order.
story telling and
Scrum planning
Dimensions in BEAM ✲ story sequence (who, what, where, why, and how).
This helps you fill in the matrix using the 7Ws, read summary event stories,
spot opportunities to reuse dimensions of the same W-type and focus on con-
forming the most important who and what dimensions: typically customer,
employee and product.
Stakeholder Group columns for recording event interest and ownership. Ticks
can be linked to attendee lists of who was involved in modelstorming the event
details, or should be.
Importance and Estimate rows and columns for prioritizing events and
dimensions on a Scrum product backlog and estimating their ETL tasks for a
sprint backlog.