Day 3 - Team H

OLAP Cube

OLAP (online analytical processing) is computer processing that enables a user to easily and selectively extract and view date from different points of view. In other words it is primarily involved with reading and aggregating large groups of diverse data involved in complex relationships. OLAP analyses these relationships and looks out for patterns, trends and exception conditions.

For example, using the data of different a user of various telecom services we analyse the data to find the find different types of relationships such as for a particular telecom service, for a given gender what is the max source of revenue i.e SMS, Fixed cost etc.

                                                                                             OLAP Cubes

Gender of respondent: Female

Name of current service provider: Airtel

	Sum	N	Mean	Std. Deviation	% of Total Sum	% of Total N
Age in years of respondent	170	10	17.00	.471	4.9%	4.9%
Fixed component of bill	507.00	10	50.7000	13.35041	5.1%	4.9%
Monthly expenditure on phone	3145.00	10	314.5000	41.47891	4.3%	4.9%
SMS bill	228.00	10	22.8000	9.51957	4.1%	4.9%
Other charges	45.00	10	4.5000	8.31665	3.9%	4.9%
Voice calls bill	345.00	10	34.5000	15.17491	3.5%	4.9%

It can be seen from the above example that OLAP Cubes are source of slicing and dicing in data mining. Where Slicing means taking out the slice of a cube, given certain set of select dimension (customer segment), and value (home furnishings..) and measures (sales revenue, sales units..) or KPIs (Sales Productivity). 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.

Slicing and Dicing leads to creation of Pivot. Pivot is the standard and basic look and feel of the views you create on the OLAP cubes. A pivot creates ability for you to create the width and depth in your view of the data.

There are three types of OLAP

1.     Multidimensional OLAP (MOLAP)

2.     Relational OLAP

3.     Hybrid OLAP (HOLAP)

Ruhi Singla

14103