OLAP cubes_ Group C

There were many new concepts been taught in class today right from clustering of data to methods of analysis like euclidean squared euclidean distance and one of the concepts taught in class was OLAP(Online Analytical Processing) 

OLAP 

On-Line Analytical Processing (OLAP) is a category of software technology that enables analysts, managers and executives to gain insight into data through fast, consistent, interactive access to a wide variety of possible views of information that has been transformed from raw data to reflect the real dimensionality of the enterprise as understood by the user.

OLAP functionality is characterized by dynamic multi-dimensional analysis of consolidated enterprise data supporting end user analytical and navigational activities including:

• Calculations and modeling applied across dimensions, through hierarchies and/or across members
• Trend analysis over sequential time periods
• Slicing subsets for on-screen viewing
• Drill-down to deeper levels of consolidation
• Reach-through to underlying detail data
• Rotation to new dimensional comparisons in the viewing area

A variety of charts and graphs: Provide you with the right visual to describe your results. Graph types include:

Categorical charts: including several types of 3-bar, bar, line, area, pie, boxplot, and error bar charts Quality control charts: including Pareto, X-Bar, and Sigma charts 

Scatterplots: including simple, grouped, scatterplot matrix, and 3-D charts Density charts: including population pyramids, dot charts, and histograms

Diagnostic and exploratory plots: including caseplots and time-series plots 

Probability plots: including plots of observed and expected values 

Autocorrelation and partial autocorrelation function plots: including natural log transformations and seasonal and nonseasonal differencing Cross-correlation function plots: including natural log transformations and seasonal and nonseasonal differencing 

Multiple use charts: use the Chart Builder to create new chart types, 2-D line charts (both axes can be scale axes) and charts for multiple response sets Custom charts: through support for SPSS Inc.’s Graphic Production Language (GPL). This custom chart creation language enables advanced users to attain a broader range of chart and option possibilities than the interface supports.

Report OLAP cubes in SPSS Base are easier to use than OLAP cubes found in other software because you can set up the OLAP cubes yourself—there's no need to involve your IT department. Report OLAP cubes work right from your SPSS data files to include value and variable labels. Also, SPSS can take millions of rows and aggregate them in an OLAP cube to make them meaningful in seconds.

By-

Amar Kumar

14067, Operations

Source:- www.moulton.com & spss.wikia.com