|
|
|
|
|
Execution-MiH ENCYCLOPEDIA →
Enterprise Intelligence →
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
|
|
Drill (horizontal) and Cross (horizontal) Navigation and Analysis
|
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 Data Analysis
|
Time trending analysis includes period to period comparisons, across the periods and within a period analysis.
|
| |
|
Exception Analysis
|
Exception analysis throws-up the areas not meeting the expectations.
|
| |
|
Data Min-Max Analysis
|
Min-Max Analysis helps to identify the extreme positions and combining with aggregation analysis provides a more comprehensive analysis
|
| |
|
Data Filtration 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.
|
| |
|
Pivoting, and Slicing & Dicing Analysis
|
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 |
