Session 5/6 Team F - Olap cube

In Today's session we were taught about cluster analysis and OLAP cubes.

OLAP CUBES

OLAP stands for Online Analytical (A) Processing (P) is software that is designed to allow users to navigate, retrieve and present business or organisational data.

The OLAP Cubes procedure calculates totals, means, and other univariate statistics for continuous summary variables within categories of one or more categorical grouping variables. A separate layer in the table is created for each category of each grouping variable.

OLAP Features

There are four main features:

·         Consolidation – you can roll up or sum the data to higher levels of abstraction e.g. local sales office, regional office, and national office and so on.

·         Drill Down - you can navigate down or up through the data with a few clicks.

·         Calculations – you can create derived calculations such as profit margins, yields etc.

·         Pivot tables – you can readily view the data from different points or perspectives.

To Obtain OLAP Cubes

This feature requires the Statistics Base option.

From the menus choose:

Analyze > Reports > OLAP Cubes...

Select one or more continuous summary variables.

Select one or more categorical grouping variables.

Optionally:

• Select different summary statistics (click Statistics). You must select one or more grouping variables before you can select summary statistics.

• Calculate differences between pairs of variables and pairs of groups that are defined by a grouping variable (click Differences).

• Create custom table titles (click Title).

• Hide counts that are less than a specified integer. Hidden values will be displayed as <N, where N is the specified integer. The specified integer must be greater than or equal to 2.

 

Example

Case Processing Summary

 

 

	Cases
	Included		Excluded		Total
	N	Percent	N	Percent	N	Percent
Usage period In Months  * Mode of payment	206	100.0%	0	.0%	206	100.0%
SMS bill  * Mode of payment	206	100.0%	0	.0%	206	100.0%
Other charges  * Mode of payment	206	100.0%	0	.0%	206	100.0%
Voice calls bill  * Mode of payment	206	100.0%	0	.0%	206	100.0%

 

                                                                                              OLAP Cubes

Mode of payment: Credit Card

	Sum	N	Mean	Std. Deviation	% of Total Sum	% of Total N
Usage period In Months	9	4	2.25	.500	.4%	1.9%
SMS bill	135.00	4	33.7500	7.50000	2.4%	1.9%
Other charges	60.00	4	15.0000	17.32051	5.2%	1.9%
Voice calls bill	140.00	4	35.0000	25.16611	1.4%	1.9%

 

 

Team F

 Amita Kachhap
14068
HR