Objectives

Capturing reporting and analysis requirements in a logical BI data model is the fundamental basis for implementing a Performance Management solution.

Capturing reporting and analysis requirements in a logical BI data model is a two-day, instructor-led course that is designed to explain the benefit of multi-dimensional models and that teaches the attendees how to read and how to build such models. The underlying concept will be explained as well as the rules that one has to keep in mind when validating a multi-dimensional model. The ability to correctly read and interpret these star schemas will make the analysis process easier. By understanding the meaning of star schemas you will be able to build them and validate the result of the requirements analysis.

By using a few examples and exercises trainees can turn theory into pratice going through all steps that are required for defining a multi-dimensional model in a business context.

Main topics

Multi-dimensional models bring structure in the information-analysis proces. They are the basis for implementing a Performance Management solution. This process needs to be performed regardless how the data will be presented (scorecards, dashboards, reports or cubes).

• Why capturing reporting and analysis requirements in a logical BI data model
• Detect and define Business requirements
• Define the domains for analysis
• Define priorities
• Step by step approach
• Transaction or Status?
• Define relevant measures
• Aggregations
• Design star schemas
• Combining different star schemas