An internal training presentation from March 2012 that looks at how the choice of technology affects the choice of data modelling strategy
It start with a review of the current state of the art:
- The concept of a Data Mart as the data access interface layer for Business Intelligence has been around for over 25 years
- Kimball style Dimensional Modelling and Star Schemas have become the de facto data modelling technique for data marts
- These have been and continue to be hugely successful with relational databases and reporting tools – but are they the right tool for todays technologies ?
And moves on to look at what the options are now
Download Using the right data model in a data mart now