SQLBits 2011

Advanced Dimensional Modelling

Many of us know what dimensions and fact tables are. But dimensional modelling is more than just dimensions and fact tables. This session is about advanced dimensional modelling topics, which are useful for anybody involved in the design of a DW.

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 as well as other methods of managing dimensions. Prerequisites: You need have a basic knowledge of dimensional modelling and relational database design.

Speaker

Vincent is a data architect and data scientist specilising in banking and investment. He wrote a book on SQL Server data warehousing & BI, and many articles on www.datawarehouse.org.uk. He works on big data and machine learning.

Vincent Rainardi's Sessions

Advanced Dimensional Modelling