Data Warehousing and Data Science

20 April 2009

Data Warehouse Data Modelling

Filed under: Data Warehousing — Vincent Rainardi @ 11:34 pm

My presentation at SQLBits 4, 28th March 2009 in Manchester, is here: Data Warehouse Data Modelling.

In this presentation I explained what dimensional data model is, why we use it for data warehousing, when to use and when not to use, what are the advantages and disadvantages and what are the alternatives. To get first hand experience about how a third normal form transactional database is translated into fact and dimension tables in a dimensional model I used a real world example as a case study. I also discussed some particular points in dimensional modelling such as smart date key, choosing dimensional grain, and real time fact table.

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at

%d bloggers like this: