olap theory-english version on-line analytical processing (business intelligence)...
TRANSCRIPT
![Page 1: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/1.jpg)
OLAP Theory-English version On-Line Analytical processing (Business Intelligence)
[Ing.J.Skorkovský,CSc.]Department of corporate economy
![Page 2: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/2.jpg)
Agenda
The Market Why OLAP (On-Line-Analytic-Processing Introduction to OLAP OLAP Terms and Concepts Summary
![Page 3: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/3.jpg)
OLAP market size
![Page 4: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/4.jpg)
Why OLAP The Right Information In The Right Place
At The Right Time Why
– More self-sufficient Business users– Keep the integrity of the data– Reduces the query drag(burden) and
network traffic – Organization can respond more quickly to
market demands
![Page 5: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/5.jpg)
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. “
![Page 6: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/6.jpg)
Introduction to OLAP Users
– Analysts, managers (CEO,..) and executive managers (CFO,..)
Access– Fast consistent, interactive– Wide variety of possible views
Transformation of– Raw data– Real dimensionality of enterprise
![Page 7: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/7.jpg)
Introduction to OLAP
Organizational functions– Finance
Budgeting Performance analysis
– Sales Sales analysis and forecasting
– Marketing Market research analysis Market/customer segmentation
– Purchase Cost of materials
– Production Cost of conversion (components to final product)
– Distribution Cost of shipping
– etc
![Page 8: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/8.jpg)
OLAP Terms and Concepts
![Page 9: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/9.jpg)
Relational database
Multidimensional database
OLAP Terms and Concepts Relational
database
Multidimensional database
![Page 10: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/10.jpg)
OLAP Terms and Concepts Cube
– Information Is conceptually viewed as cubes.
![Page 11: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/11.jpg)
OLAP Terms and Concepts Cube
– Information Is conceptually viewed as cubes.
Dimension– Distinct categories for business
data.
![Page 12: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/12.jpg)
OLAP Terms and Concepts Cube
– Information Is conceptually viewed as cubes.
Dimension– Distinct categories for business
data. Hierarchy
– Levels of details on the data.
![Page 13: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/13.jpg)
OLAP Terms and Concepts Cube
– Information Is conceptually viewed as cubes.
Dimension– Distinct categories for business
data. Hierarchy
– Levels of details on the data.
![Page 14: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/14.jpg)
OLAP Terms and Concepts Cube
– Information Is conceptually viewed as cubes.
Dimension– Distinct categories for business
data. Hierarchy
– Levels of details on the data. Measure
– Quantitative values.
![Page 15: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/15.jpg)
OLAP Terms and ConceptsCube
Information Is conceptually viewed as cubes.
DimensionDistinct categories for business data.
HierarchyLevels of details on the data.
MeasureQuantitative values.
![Page 16: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/16.jpg)
OLAP Terms and Concepts Cube
– Information Is conceptually viewed as cubes.
Dimension– Distinct categories for
business data. Hierarchy
– Levels of details on the data. Measure
– Quantitative values. Data slice
– A subset of the data in a partition.
![Page 17: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/17.jpg)
OLAP Cube
![Page 18: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/18.jpg)
Data Warehouse->Data Marts (Technology)
DataWarehouse
Data Mart
Data Mart
Data Mart
Decision Support
Information
Decision Support
Information
Decision Support
Information
![Page 19: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/19.jpg)
OLAP architecture OLAP (Technology)
METADATA
![Page 20: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/20.jpg)
Data pump (Technology)
Prime transaction oriented
system(ERP,CRM,..)
Data
warehouse
Datapump
![Page 21: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/21.jpg)
Reporting (NAV tools or JETs)
Reporting
21
http://www.jetreports.com/jet-essentials/reporting-solutions.php
![Page 22: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/22.jpg)
Main principles (source tables and their entries)
Main principles
22
CustomerCustomer
VendorVendor
ItemItem
AccountAccount
DimensionDimension
Control parameters(time, type of products,
Costs, Revenue, Area,..)
Control parameters(time, type of products,
Costs, Revenue, Area,..)
![Page 23: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/23.jpg)
Some chosen analysis asked by not named important customer (prospect) in the Czech Republic
Analysis
Working capital – setup of the accounting schedule from NAV
23
![Page 24: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/24.jpg)
Analysis
Working capital – Show of the results from NAV
24
Some chosen analysis asked by not named important customer (prospect) in the Czech Republic
![Page 25: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/25.jpg)
Working Capital JETs
Working capital – Show of the results from JETs
25
Some chosen analysis asked by not named important customer (prospect) in the Czech Republic
![Page 26: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/26.jpg)
Inventory Dashboard
26
Some chosen analysis asked by not named important customer (prospect) in the Czech Republic
![Page 27: OLAP Theory-English version On-Line Analytical processing (Business Intelligence) [Ing.J.Skorkovský,CSc.] Department of corporate economy](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9d5503460f94b9e6c8/html5/thumbnails/27.jpg)
Some chosen analysis examples (JETs)
Analysis examples
27