Dimenional Modeling 101

Speaker(s)Thomas LeBlanc

Duration: 60 minutes

Track: BI

This session is going to help create a dimensional Data Mart from the AdventoureWorks database that includes dimension tables and 2 example fact tables. The Kimball spreadsheet for documenting a Data Mart will be used to reenforce the need for Requirements and Functional specifications.  A brief review of ETL for Slowly Changing Dimension and population of the Fact will be deomstrated as well as a simple cube for reporting.

Back to Top