Advanced Dimensional Modelling with Vincent Rainardi

Platinum Sponsor

Home

Travel & Accommodation

SQLBits Query across the mersey

SQLBits Beside the seaside

SQLBits 7 Wonders of SQL

SQLBits The 6th Sets (VI)

SQLBits goes West (V)

SQLBits goes Forth (IV)

Premium Sponsor

Gold Sponsors

Silver Sponsors

Bronze Sponsors

It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Advanced Dimensional Modelling

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.

Presented by Vincent Rainardi at SQLBits VIII

Downloads

Slide Deck 270 KB

MP4 Video Low 56 MB

MP4 Video Med 82 MB

MP4 Video High 184 MB

MP4 Video HD 353 MB
SpeakerBIO

Vincent Rainardi

Vincent is a data warehouse & BI architect. He wrote a book on SQL Server data warehousing & BI, as well as many articles on www.datawarehouse.org.uk. Vincent is certified in designing BI solutions, database design and DBA (MCTS, MCITP, MCP).
Video

Click here to view in local media player
Session Files Explorer
{1}

##LOC[OK]##

{1}

##LOC[OK]## ##LOC[Cancel]##

{1}

##LOC[OK]## ##LOC[Cancel]##
Advanced_Dimensional_Modelling
Could not find a part of the path '\\sqlbits01\DENALI\SQLBitsFiles\'.