OLAP example

83 %
17 %
Information about OLAP example

Published on February 7, 2008

Author: Miranda

Source: authorstream.com

Slide1:  Example: Olap Usage of an Automobile Marketer Slide2:  Example: The Multidimensional Database Used Sales Volumes Blue Red White Van Coupe Sedan Miller Clyde Smith COLOR DEALERSHIP MOD E L Slide3:  OLAP Features: “Dicing“ - Ranging of Data Sales Volumes Blue Red White Van Coupe Sedan Miller Clyde Smith COLOR DEALERSHIP MOD E L Color: Blue and White Model: Coupe only Dealership: Clyde only Choosing a range out of each dimension: Slide4:  OLAP Features: “Slicing“ - Rotation of Data Sales Volumes Blue Red White Van Coupe Sedan COLOR MOD E L Different Users will require different views (cross tables or “slices“) of the multidimensional cube – OLAP allows easy rotation of data Slide5:  OLAP Features: Drill-Down and Roll-Up Data can be disaggregated and aggregated along a dimension according to their natural hierarchy Drill-Down Roll-Up State Region Dealership Miller Smith Clyde Lucas Gleason Atlanta Athens Georgia Sales Volumes by Organization Dimension - three level hierarchy -

Add a comment

Related presentations

Related pages

OLAP-Würfel – Wikipedia

OLAP-Würfel kommen häufig bei der Analyse von Unternehmensdaten zum Einsatz, beispielsweise Umsätze, Lagerbestände und Verkäufe. Zu den Dimensionen, ...
Read more

OLAP Examples - technet.microsoft.com

This feature will be removed in the next version of Microsoft SQL Server. ... OLAP Examples. OLAP Examples. OLAP Examples. Working with Servers.
Read more

What is OLAP (online analytical processing)? - Definition ...

OLAP (online analytical processing) is computer processing that enables a user to easily and selectively extract and view data from different points of view.
Read more

Online Analytical Processing – Wikipedia

Online Analytical Processing (OLAP) wird neben dem Data-Mining zu den Methoden der analytischen Informationssysteme gezählt. OLAP wird weiterhin den ...
Read more

Overview of Online Analytical Processing (OLAP) - Excel

Online Analytical Processing (OLAP) ... For example, OLAP and business intelligence help answer the following types of questions about business data:
Read more

Online analytical processing - Wikipedia

For example, all sales offices ... Multidimensional structure is quite popular for analytical databases that use online analytical processing (OLAP ...
Read more

Create First OLAP Cube in SQL Server Analysis Services ...

Learn creation of OLAP Cube in SSAS (SQL Server Analysis Services) using Microsoft BIDS (Business Intelligence Development Studio) Environment and Data ...
Read more

OLAP - Business Intelligence - SAP Library

OLAP Purpose. SAP NetWeaver Business Intelligence uses OLAP technology to analyze the data that is stored in the data warehouse. Online Analytical ...
Read more

Oracle OLAP

Oracle OLAP makes it easy to produce analytic measures, including time-series calculations, financial models, forecasts, allocations, regressions, and more.
Read more

OLAP by example - pagesperso-orange.fr

Understand OLAP technology by example ... In reality, the different types of shoes are held in a Styletable, and we only include the corresponding key ...
Read more