1 / 24

OLAP Theory-English version On-Line Analytical processing (Buisness Intzlligence)

OLAP Theory-English version On-Line Analytical processing (Buisness Intzlligence). [ Ing.Skorkovský,CSc ] KPH_ESF_MU. Agenda. The Market Why OLAP Introduction to OLAP OLAP Terms and Concepts Summary. OLAP market size. Why OLAP.

Download Presentation

OLAP Theory-English version On-Line Analytical processing (Buisness Intzlligence)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. OLAP Theory-English version On-Line Analytical processing (Buisness Intzlligence) [Ing.Skorkovský,CSc] KPH_ESF_MU

  2. Agenda • The Market • Why OLAP • Introduction to OLAP • OLAP Terms and Concepts • Summary

  3. OLAP market size

  4. 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

  5. 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. “

  6. Introduction to OLAP • Users • Analysts, managers and executive managers • Access • Fast consistent, interactive • Wide variety of possible views • Transformation • Raw data • Real dimensionality of enterprise

  7. 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 • Distribution • Cost of shipping • etc

  8. OLAP Terms and Concepts

  9. OLAP Terms and Concepts • Relational database • Multidimensional database Relational database Multidimensional database

  10. OLAP Terms and Concepts • Cube • Information Is conceptually viewed as cubes.

  11. OLAP Terms and Concepts • Cube • Information Is conceptually viewed as cubes. • Dimension • Distinct categories for business data.

  12. OLAP Terms and Concepts • Cube • Information Is conceptually viewed as cubes. • Dimension • Distinct categories for business data. • Hierarchy • Levels of details on the data.

  13. OLAP Terms and Concepts • Cube • Information Is conceptually viewed as cubes. • Dimension • Distinct categories for business data. • Hierarchy • Levels of details on the data.

  14. 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.

  15. 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.

  16. 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.

  17. OLAP Cube

  18. Reporting Reporting (NAV tools or JETs)

  19. Main principles Main principles (source tables and their entries) Control parameters (time, type of products, Costs, Revenue, Area,..) Customer Vendor Item Account Dimension

  20. Analysis Working capital – setup of the accounting schedulefrom NAV Some chosen analysis asked by CFO EUROM Czech Republic

  21. Analysis Working capital – Show of the results from NAV Some chosen analysis asked by CFO EUROM Czech Republic

  22. Working Capital JETs Working capital – Show of the results from JETs Some chosen analysis asked by CFO EUROM Czech Republic

  23. Inventory Dashboard Some chosen analysis asked by CFO EUROM Czech Republic

  24. Analysis examples Some chosen analysis examples (JETs)

More Related