DAY 3 - TEAM G - ANKIT MAHESHWARI

OLAP (ONLINE ANALYTICAL PROCESSING) – SPSS BASE

An OLAP cube is an array of data that is understood in terms of its dimensions. OLAP is a computer-based technique for analyzing business data in the search for business intelligence. OLAP tools enable users to interactively analyze multidimensional data from multiple perspectives.
OLAP consists of three basic analytical operations:

·        Consolidation

·        Drill-down and

·        Slicing and dicing.

Consolidation involves the aggregation of data that can be accumulated and computed in one or more dimensions. The drill-down is a technique that allows users to navigate through the details. Slicing and dicing is a feature whereby users can take out a specific set of data of the OLAP cube and view the slices from different viewpoints.

The OLAP (Online Analytical Processing) Cubes procedure calculates totals, means, and other 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 cubes in SPSS Base are easier to use because you can set up the OLAP cubes yourself. OLAP cubes work right from your SPSS data files to include value and variable labels. Also, SPSS can take number of rows and aggregate them in an OLAP cube to make them meaningful in seconds.

The following steps guide you through the process of producing a three-dimensional table:

1.     Choose File : Cell Inter.Sav (example)

2.     The OLAP Cubes dialog box appears

3.     In the list on the left:
a. Select Current age, usage period, monthly expenditure and SMS bills, move it to the Summary Variable(s) panel by clicking the arrow button.
b. Select Educational Level, monthly recharge and mode of payment, move it to the Grouping Variable(s) panel.

                       

4.     Click the OK button.

This is only the total layer of the multilayered table. Double-clicking the OLAP Cubes table selects it and causes the appearance of pull-down lists.  One pull-down list appears for each grouping variable. By making selections from the lists, you change the view by changing the table that appears on top.

           

5.     Now you can find relationship between any variables by changing parameters.

Ref:: SPSS(website), Wikipedia, IBM

By 

ANKIT MAHESHWARI

TEAM G