BUSINESS INTELLIGENCE – DIMENSIONAL MODELLING

DURATION:

2 Day Course

COURSE GOALS:

The goals of the Dimensional Modelling training course are: 

• To provide the building blocks for designing a dimensional model for a data warehouse. 
• To discuss specific techniques used to resolve the multiple challenges faced when designing models. 
• To obtain practical dimensional modelling experience through the labs included in the training. 

TARGET AUDIENCE:

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

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).

TOPICS 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.