Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline

Basic Data Analysis Types- Building Blocks	Business Hierarchies in OLAP and Data Warehouse

Execution-MiH ENCYCLOPEDIA → Enterprise Intelligence → SECTION - Data Analysis/OLAP →

CHAPTER -

Advanced Data Analysis Types- Building Blocks

This chapter provides the advanced analysis capabilities within OLAP, which provides the building blocks for BI- End-User tools to fulfill contextual analysis requirements.

Topics

OLAP what if Analysis

What-if analysis is essentially scenario building capability of OLAP. You can draw a straight parallel of what-if analysis in MS Excel, with more sophisticated capabilities in OLAP.

OLAP Data Allocation Analysis

Allocation Engines is another differentiator for OLAP vs. Data Warehouse. Simplistically-It allows the users to automatically allocate or in other words 'split' the value into multiple values.

OLAP Goal-Seek Data Analysis

Goal-Seek is What-if analysis in OLAP, but of a reverse order. In a typical What-if analysis, A Calculation model takes a set of input values, to give the set of out-put values. Each different set of these 'input and output value combinations' is called a what-if analysis scenario. Depending upon your needs you can build different scenarios of input values, and you can apply those scenarios on the calculation model, and generate the output values. Here we are traveling from input values to output values.