OLAP Theory-English version
                                    supplement to OLAP 20050425

[Ing.Skorkovský,CSc]

Katedra aplikované matematiky a informatiky

Agenda



l  The Market / obchod/ marketing

l  Why OLAP / proč OLAP

l  Introduction to OLAP / úvod

l  OLAP Terms and Concepts/ terminologie

l   Summary / Závěr

OLAP market size

Why OLAP

l  The Right Information In The Right Place At The Right Time

l  Why

–       More self-sufficient Business users

–       Keep the integrity of the data

–       Reduces the query drag(přítěž) and network traffic (zatížení na síti)

–       Organization can respond more quickly to market demands

Introduction to OLAP



“OLAP enables analysts, managers, and executives to gain insight into data through fast,
consistent, interactive access to a wide variety of possible views of information. OLAP transforms
raw data so that it reflects the real dimensionality of the enterprise as understood by the user. “



Introduction to OLAP

l  Users

–       Analysts, managers and executive

l  Access

–       Fast consistent, interactive

–       Wide variety of possible views

l  Transformation

–       Raw data

–       Real dimensionality of enterprise



Introduction to OLAP

l   Organizational functions

–         Finance

l  Budgeting

l  Performance analysis

–         Sales

l  Sales analysis and forecasting

–         Marketing

l  Market research analysis

l  Market/customer segmentation

–         Purchase

l  Cost of materials

–         Production

l  Cost of conversion

–         Distribution

l  Cost of shipping

–         etc

OLAP Terms and Concepts

OLAP Terms and Concepts

l  Relational database



l  Multidimensional database

OLAP Terms and Concepts

l   Cube

–          Information Is conceptually viewed as cubes.

OLAP Terms and Concepts

l   Cube

–          Information Is conceptually viewed as cubes.

l   Dimension

–          Distinct categories for business data.

OLAP Terms and Concepts

l   Cube

–          Information Is conceptually viewed as cubes.

l   Dimension

–          Distinct categories for business data.

l   Hierarchy

–          Levels of details on the data.

OLAP Terms and Concepts

l   Cube

–          Information Is conceptually viewed as cubes.

l   Dimension

–          Distinct categories for business data.

l   Hierarchy

–          Levels of details on the data.

OLAP Terms and Concepts

l   Cube

–          Information Is conceptually viewed as cubes.

l   Dimension

–          Distinct categories for business data.

l   Hierarchy

–          Levels of details on the data.

l   Measure

–          Quantitative values.

OLAP Terms and Concepts

OLAP Terms and Concepts

l   Cube

–          Information Is conceptually viewed as cubes.

l   Dimension

–          Distinct categories for business data.

l   Hierarchy

–          Levels of details on the data.

l   Measure

–          Quantitative values.

l   Data slice

–          A subset of the data in a partition.

 OLAP Cube