My first Publication Agile-Data-Warehouse-Design-eBook | Page 46

How to Model a Data Warehouse
25
Table 1-3 BEAM✲ Diagram Types
D IAGRAM U SAGE
BEAM✲ (Example Data)
Table Modeling business events and
dimensions one at a time using
example data to document their
7Ws details.
D ATA
M ODEL
T YPE
A UDIENCE
P RINCIPAL
C HAPTER
Business
Logical
Physical Data Modelers
Business Analysts
Business Experts
Stakeholders
BI Users 2
Business Data Modelers
Business Analysts
Business Experts
Stakeholders
BI Users 3
Business Data Modelers
Business Analysts
Business Experts
Stakeholders
BI Users 8
Business
Logical
Physical Data Modelers
Business Analysts
Business Experts
Stakeholders
BI Users
Data Modelers
ETL Developers
BI Developers 4
Logical
Physical Data Modelers
DBAs
DBMS
ETL Developers
BI Developers
Testers 5
Example data tables are also used
to describe physical dimension
and fact tables and explain
dimensional design patterns.
Hierarchy Chart
Discovering hierarchical relation-
ships within dimensions and
prompting stakeholders for
dimensional attributes.
Hierarchy charts are also used to
help define BI drill-down settings
and aggregation levels for report
and OLAP cube definition.
Timeline
Exploring time relationships
between business events.
Timelines are used to discover
when details, process sequences
and duration facts for measuring
process efficiency.
Event Matrix
Documents the relationships
between all the events and
dimensions within a model.
Event matrices record events in
value-chain sequences and
promote the definition and reuse
of conformed dimensions across
dimensional models. They are
used instead of high-level ERDs
to provide readable overviews of
entire data warehouses or multi-
star schema data marts.
Enhanced Star Schema
Visualizing individual dimensional
models and generating physical
database schemas.
Enhanced star schemas are
standard stars embellished with
BEAM✲ short codes to record
dimensional properties and design
techniques not directly supported
by generic data modeling tools.