View Schedule

What you will learn:

At the end of this course the students will be familiar with building blocks to design a dimensional model for a data warehouse. They will be able to discuss specific techniques that resolve the multiple modelling challenges faced in design time. The labs included in the training will help them achieve practical dimensional modelling experience.

Course Description:

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

Target Audience:

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

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

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

View Schedule