Multidimensional Modeling
Course Description
This instructor-led training package provides a thorough understanding of the purpose of multidimensional models and teaches the participants how to construct correct models.
Multidimensional Modeling is a technique greatly appreciated in translating Performance Management information requirements into comprehensible information models suitable for different purposes.
Multidimensional models bring structure into the information requirements analysis process. They are used as a communication medium between business, end users, ICT and implementers. They are the basis for preparing an implementation of a Performance Management solution, regardless if information will be disclosed through scorecarding, dashboards, standard and ad-hoc reports, or OLAP cubes.
Course Objectives
- Understand the concepts behind multidimensional models.
- Grasp the rules to take into account when evaluating if a multidimensional model is correct.
- Construct multidimensional models.
Course Duration
2 days
Course Audience
Anyone (going to be) actively involved in a Performance Management project.
Course Prerequisites
A basic understanding of the purpose of Performance Management solutions is an advantage though not specifically required.
Course Topics
- Introduction.
- Step 1: Logical model or star schema. A
- Step 2: Combining different star schema’s.
- Step 3: Factless facts.
- Wrap up of the complete model.
Upcoming public Multidimensional Modeling trainings
Upcoming public MDM trainings
More information
Deloitte Academy Consulting
Ineke Hoogmartens, Academy Leader
Leen Vandebergen, Assistant
bedeloitteacademy@deloitte.com
+32 (0)2 749 53 48
Material on this website is © 2013 Deloitte Global Services Limited, or a member firm of Deloitte Touche Tohmatsu Limited, or one of their affiliates. See Legal for copyright and other legal information.
Deloitte refers to one or more of Deloitte Touche Tohmatsu Limited, a UK private company limited by guarantee, and its network of member firms, each of which is a legally separate and independent entity. Please see www.deloitte.com/about for a detailed description of the legal structure of Deloitte Touche Tohmatsu Limited and its member firms.