BUSINESS INTELLIGENCE – DIMENSIONAL MODELING

SHARE THIS PAGE

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

 

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. 

INTERESTED?

For further information about this course, please fill out the form below or feel free to call us at +34 93 272 1546.