Transcription of Dimensional Modelling by Example - Database Answers
{{id}} {{{paragraph}}}
Dimensional Modelling by Example Page 1 04/09/2014 13:02 Dimensional Modelling by Example Barry Williams Dimensional Modelling by Example Page 2 04/09/2014 13:02 1. Management Summary .. 5 The Purpose of this Book .. 5 The Contents of this Book .. 5 Three Stages .. 5 What are Dimensional Models ? .. 5 Data Marts .. 6 Best Practice .. 7 Types of Dimensional Models .. 7 How to use the Dimensional Models .. 12 2. Getting Started .. 12 Design Guidelines - a Four-Step Approach .. 12 Always use Surrogate Keys .. 12 Agree an Architecture .. 13 Conceptual Data Models.
Here we discuss the use of Subject Areas as a techniques for designing Dimensional Models. We take the simple example of Customers, Products and Revenue. This analysis shows that the three dominant Subject Areas are :- 1. Customers 2. Products 3. Revenue from Sales of Products to Customers. Revenue
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}