|
|
|
| Business Performance and Information Excellence Practice
|
|
|
|
|
|
|
BiPM ENCYCLOPEDIA →
Intelligent Enterprise →
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
|
|
|
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.
|
| |
|
|
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.
|
| |
|
|
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.
|
| |
|
|
|
|
|
|
All Chapters in "Data Analysis/OLAP." Section
|
|
|
|
| |
| |
| Back |
|
|
|
|
|
