Data Warehousing and Data Science

8 March 2011

SQLBits 8 Brighton: Advanced Dimensional Modelling

Filed under: Data Warehousing — Vincent Rainardi @ 7:23 pm

I will be presenting Advanced Dimensional Modelling session at SQLBits 8 in Brighton on Saturday 9th April at 12:10 to 13:10. Link to the agenda is here.

The session excerpt is below:

This session is for anybody involved in the design of a data warehouse. Many of us know what dimensions and fact tables are. But as I explained in my blog, dimensional modelling is more than just dimensions and fact tables. This session is about advanced dimensional modelling topics such as Fact Table Primary Key, Vertical Fact Tables, Aggregate Fact Tables, SCD Type 6, Snapshotting Transaction Fact Tables, 1 or 2 Dimensions, Dealing with Currency Rates, When to Snowflake, Dimensions with Multi Valued Attributes, Transaction-Level Dimensions, Very Large Dimensions, A Dimension With Only 1 Attribute, Rapidly Changing Dimensions, Banding Dimension Rows, Stamping Dimension Rows and Real Time Fact Table. Prerequisites: You need have a basic knowledge of dimensional modelling and relational database design.

I’d like to say congratulations all the speakers for getting your session chosen, particularly those who I know: Dr. John Tunnicliffe, Alistair Aitchison, Jamie Thomson, Chris Testa O’Neil, Marco Russo and Alberto Ferrari. For those who I don’t know yet, I hope I can make your acquaintance there. So to all the speakers and all the audience, see you all there.

Any specific question or request about advanced dimensional modelling please contact me at I will be writing the material in the next 2 weeks. I know the word “advanced” has different meaning from person to person, but I hope I won’t get too many of “that was way too easy for me” or “that went straight through my head”. Vincent 8/3/11.

My slide deck is here. I will put the slides using SlideShare in the next few days. As usual I welcome any comments and questions on

Update 14/4/11: Click here to view the PowerPoint presentation on SlideShare


  1. […] will be one of the topics I’m presenting at SQLBits 8. As usual I welcome any question and discussion at Vincent […]

    Pingback by When To Snowflake « Data Warehousing and Business Intelligence — 11 March 2011 @ 7:22 pm | Reply

  2. […] 原文链接: […]

    Pingback by SQLBits 8 Brighton: 高级维度建模 | 数据仓库 — 18 April 2011 @ 7:46 am | Reply

  3. […] give you an exhaustive list. You can also refer to my Advanced Dimensional Modelling presentation here to get some ideas. GA_googleAddAttr("AdOpt", "1"); GA_googleAddAttr("Origin", "other"); […]

    Pingback by Dimensional Model Check List « Data Warehousing and Business Intelligence — 24 April 2011 @ 8:03 am | Reply

  4. […] see my SQLBits Brighton presentation here, page 35 about bridge […]

    Pingback by Bridge Table with Date « Data Warehousing and Business Intelligence — 30 July 2011 @ 3:06 am | Reply

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: