BI CORE – DIMENSIONAL MODELING

DURATION:

2 Day Course

COURSE GOALS:

The goals of the Dimensional Modeling training course are: 

• To provide the building blocks to design a dimensional model for a data warehouse. 
• To discuss specific techniques that resolve the multiple modeling challenges faced in design time. 
• To obtain practical dimensional modeling experience through the labs included in the training. 

TARGET AUDIENCE:

• BI Consultants – raise dimensional modeling skills to advanced level. 
• IT Consultants – understand what is behind dimensional modeling with a hands-on training. 

PRE-REQUISITES:

Basic data modeling knowledge will help you to quickly understand the different concepts. 

LANGUAGES:

Dimensional Modeling is offered in English and Spanish (training material is only available in English).

TOPIC COVERED:

• BI System Architecture. 
• Dimensional Modeling Concepts. 
• Fact Table Types. 
• Design Methodology. 
• Surrogate Keys. 
• Degenerated Dimensions. 
• Dimension Hierarchies. 
• Conforming Dimensions. 
• Slowly Changing Dimensions. 
• Mini-dimensions. 
• Role Playing Dimensions. 
• Multiple Levels of Granularity. 
• Multiple Currencies & Units of Measure. 
• Junk Dimensions. 
• Date & Time Dimensions. 
• Performance Implications.