Topic 04: Data Warehouse Design

At the completion of this topic, you should be able to:

Explain how and why dimensional modelling is used to design data warehouses

Create a dimensional model from a given case study

Explain, and be able to resolve, some of the problems often associated with dimensional modelling

Sample Exam Questions

Explain the role and give examples of the following:

Dimension tables

Fact tables

How does the use of a dimensional model simplify analytical queries?

How is transaction time typically represented in a dimensional model?

Explain and give examples of what is meant by the granularity of a fact table.

Explain and give an example of a summarisability problem.