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

Introduction
XXI
Chapter 3: Modeling Business Dimensions
Modeling “detail about detail”: Discovering dimensions and documenting their
attributes with stakeholders. Telling dimension stories and overcoming weak
narratives.
Discovering dimensional hierarchies: Using hierarchy charts to model hierarchi-
cal relationships and discover additional dimensional attributes.
Documenting historical value requirements: Using change stories and BEAM ✲
short codes to define and document slowly changing dimension policies for sup-
porting current (as is) and historically correct (as was) analysis views.
Step-by-step
modeling of
dimensions and
hierarchies
Chapter 4: Modeling Business Processes
Modeling multiple business events: Modelstorming with an event matrix to
storyboard a data warehouse design by identifying and documenting the relation-
ships between events and dimensions. Using event stories to prioritize require-
ments and plan development sprints.
Modeling for agile data warehouse development: Defining and reusing con-
formed dimensions. Generalizing dimensions and documenting their roles. Sup-
porting incremental development and creating a data warehouse bus architecture.
Step-by-step
modeling multiple
business events
and conformed
dimensions
Chapter 5: Modeling Star Schemas
Agile data profiling: Reviewing and adapting stakeholder models to data realities.
Using BEAM ✲ annotation to document data sources and physical data types,
provide feedback to stakeholders on model viability and help estimate ETL tasks as
a team.
Converting BEAM ✲ tables to star schemas: defining and using surrogate keys to
complete dimension tables, and convert event tables to fact tables. Using BEAM ✲
technical codes to document the database design decisions and generate database
schemas using the BEAM ✲ Modelstormer spreadsheet. Prototyping to define BI
reporting requirements. Creating enhanced star schemas and physical dimensional
matrices for a technical audience.
Validating
stakeholder models
and converting them
into star schemas
Part II: Dimensional Design Patterns
Part II covers dimensional modeling techniques for designing high-performance
star schemas. For this, we take a design pattern approach using a combination of
BEAM ✲ and star schema ER notation to capture significant DW/BI requirements,
explain their associated issues/problems, and document pattern solutions and the
consequences of implementing them. We have organized these design patterns
around the 7W dimensional types discovered in Part I. By using the 7Ws to exam-
ine the complexities of modeling customers and employees (who), products and
services (what), time (when), location (where), business measures (how many),
Collaborative
modeling within the
DW/BI team. Using
design patterns
associated with
each of the 7W
dimensional types