| Business Performance and Information Excellence Practice
|
|
|
|
|
|
|
BiPM ENCYCLOPEDIA →
Intelligent Enterprise →
SECTION - Data Analysis/OLAP →
|
CHAPTER - Basic Data Analysis Types- Building Blocks
|
This chapter covers the likes of drill down, exception, max-min analysis. The list is long and will be enhanced on ongoing basis
|
|
| |
Topics
|
|
|
these are the methods of moving horizontally and vertically with in the dimensional structure of Data-warehouse and OLAP. This term is more used in context with OLAP, because typically various End-user Business Intelligence tools sit on top of OLAP, which in turn sits over Data-Warehouse.
|
| |
|
|
Time trending analysis includes period to period comparisons, across the periods and within a period analysis.
|
| |
|
|
Exception analysis throws-up the areas not meeting the expectations.
|
| |
|
|
Min-Max Analysis helps to identify the extreme positions and combining with aggregation analysis provides a more comprehensive analysis
|
| |
|
|
Like other analysis types covered in the chapter, Filtration analysis essentially allows you to place filters for your queries. Applying filter can be seen both for exclusion or selecting specific values for inclusion. In simplistic way, filtering can be equivalent to where clause of an SQL query.
|
| |
|
|
Slicing means taking out the slice of a cube, given certain set of select dimension (product), and value (home furnishings..) and measures (sales value, sales units..). Dicing means viewing the slices from different angles. For example -Revenue for different products within a given state or revenue for different states for a given product. One form of Slicing and Dicing is called pivoting.
|
| |
|
|
|
|
|
|
All Chapters in "Data Analysis/OLAP." Section
|
|
|
|
| |
| |
| Back |
