Business concepts
A business process
Asset lifecycle
Management life cycle

Measurement
Instrument panels and scorecards
A balanced scorecard
Lagging and leading indicators

Dimensional concepts
Entity relationship modelling
Dimensional modelling
Why dimensional modelling

The dimensional model
Facts, dimensions and attributes
Primary, foreign and surrogate keys
Granularity

Inside dimension tables
Drilling down
Large dimensions
Slowly changing dimensions
Mini-dimensions

Inside fact tables
Additive, semi-additive and non-additive facts
Value chains, circles and aggregates
‘Factless’ fact tables

Building dimensional models
Building the matrix
The four steps to define a data mart
Design principles

Documenting dimensional models
Data mart matrix
Fact table diagrams and details
Dimensional table diagram and details

Identifying source data
Candidate data sources
Surveying the data
Mapping source to target data

Data staging
The data staging schematic
Historical and incremental loading
ETL operations and automation

Impact of IT architecture
Relevance of architecture and planning
Principles of data architecture
Data quality an improvement

Data warehouse architecture