Sales Management Customer Relationship Human Resources Business Performance BI & Data Quality IT Tools & Vendors

Sign-in   Register
Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline
   Online Analytic Processing (OLAP)-Overview Advanced Data Analysis Types- Building Blocks  

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.
 

   Online Analytic Processing (OLAP)-Overview Advanced Data Analysis Types- Building Blocks  

All Chapters in "Data Analysis/OLAP." Section
 Online Analytic Processing (OLAP)-Overview →  Basic Data Analysis Types- Building Blocks →  Advanced Data Analysis Types- Building Blocks →  Business Hierarchies in OLAP and Data Warehouse →  Additivity and Aggregation of Measures-Facts in OLAP Analysis → 

 
 
Back
 
More on Data Analysis/OLAP
Online Analytic Processing (OLAP)
Advanced Data Analysis Types
Hierarchies in OLAP & DW
Additivity & Aggregation-Facts
Additional Channels
Principles & Rules
Free Templates
Glossary
Key Performance Indicators



Most Popular Zones with list of pages crossing 25000 hits  →→→ 
Maximising Sales Performance
Sales Objectives Clarity
Sales productivity
Sales Revenue SWOT
Sales Channel Partner Acquisition
Sales facility Infrastructure
Read more...
  Customer Relationship Management
Customer Satisfaction and Retention- Overview
What is Customer Segmentation?
Customer Service and Support Overview
Customer Segmentation approach
Drivers for Customer Satisfaction & Retention
Read more...
  Human Resources & Leadership
Empower Front-line Employees
Feedback does not mean only negative feedback
Roles and Level based Competency Segregation
Act with Decisiveness
Fostering Innovation
Read more...
 
 
Business Performance & Planning
strategy blueprint Rationalize Align and Publish
Strategic Business Plan
Performance Review should have no surprises
Creating Strategy Blueprint
For important KPIs- Install first & Fix later
Read more...
  Business Intelligence & Data Quality
Synergies & Shared Capabilities-Overview
BI Competency Centre- A preface
Source system mapping matrix
Data Warehouse Project Initiation Phase
Business Partner Interface Controls
Read more...
  IT Vendors & Tools Management
Data Profiling and Monitoring
Vendor Quality Evaluation
OLAP Security
Delivery Evaluation Matrix
Vendor Delivery Project Evaluation
Read more...