Details

Dimenional Modeling 101

Thomas LeBlanc
60 minutes
BI
Intermediate
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 cage-aids
cage-aids
cage-aids
cage-aids