1 / 12

OLAP Cubes 101 Introduction and Terminology

OLAP Cubes 101 Introduction and Terminology. Presenter: Steve Little Product Manager. Questions? Sales.US@Jetreports.com. The leading provider of Reporting, Business Intelligence and Data Warehouse automation for Microsoft Dynamics. 70,000 + users worldwide

cody-wilkinson
Download Presentation

OLAP Cubes 101 Introduction and Terminology

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 Cubes 101 Introduction and Terminology Presenter: Steve Little Product Manager Questions? Sales.US@Jetreports.com

  2. The leading provider of Reporting, Business Intelligence and Data Warehouse automation for Microsoft Dynamics. • 70,000+ users worldwide • Four Solutions to match your needs • Unmatched time-to-ROI • Quick Installation • World Class Service • “I work with a lot of companies for software technical support and Jet Reports has the top service levels I’ve seen.” ~Bernatello’s Pizza

  3. In the next 15 minutes we’re going to cover- • What are cubes? • What are cubes good for? • Cube terminology • Three myths about Cubes OLAP Online Analytical Processing OLAP = Cubes Secret Session: OLAP Cubes 101 – Introduction and Terminology Questions? Sales.US@Jetreports.com

  4. What are Cubes? Let’s start by stating what cubes are NOT… Cubes are not relational databases… (Microsoft Dynamics NAV, AX and GP are all examples of relational databases) • Relational databases are optimized to get information into the system Secret Session: OLAP Cubes 101 – Introduction and Terminology Questions? Sales.US@Jetreports.com

  5. Getting information out of a relational database can be challenging “How much profit did we make selling Sno-cones to Icelanders last year?” • In a Relational Database the information you need to answer this question is scattered across many tables • Customer • Country/Region • Item • Sales Invoice Line • Sales Invoice Header • Sales Credit Memo Line • Sales Credit Memo Header Getting this information out of a relational database is slow and difficult. What you want is easy and fast Secret Session: OLAP Cubes 101 – Introduction and Terminology Questions? Sales.US@Jetreports.com

  6. There’s another less obvious problem… Once you get your answer to a question like this, it spurs other questions • Who were these customers? • Are our sales growing or shrinking? • Did sales fluctuate month over month? • Who was our top salesperson? • And could we put her to better use? Cubes make it easy to answer questions like these by reorganizing a copy of the data so that it’s easy and fast to get information out. Secret Session: OLAP Cubes 101 – Introduction and Terminology Questions? Sales.US@Jetreports.com

  7. Cubes are a multi-dimensional way of organizing data Cubes enable near instantaneous analysis of large amounts of data Customer (Country) Iceland Canada U.S. Taffy Products 2011 Chocolate SnoCones 2012 2013 Sales $10,000 Profit $3,000 Profit Pct 30% Cube with three dimensions Secret Session: OLAP Cubes 101 – Introduction and Terminology Questions? Sales.US@Jetreports.com

  8. Cube Terminology Dimensions and Measures Customer (Country) Iceland Canada U.S. Dimension A category that can be used to slice the data Taffy Products 2011 Chocolate SnoCones 2012 Measure A calculated numerical value e.g. sums, counts, averages, percentages 2013 Sales $10,000 Profit $3,000 Profit Pct 30% Many measures are pre-calculated in a cube – providing extremely fast performance Cube with three dimensions Secret Session: OLAP Cubes 101 – Introduction and Terminology Questions? Sales.US@Jetreports.com

  9. Cube Terminology Levels & Hierarchies Iceland Country Reykyavik Selfoss Level- A grouping within a dimension City Hagar’s hut Sláturfélag Sweets Hannesson and son Iceland Ice cream Reykyavik Snacks Icy Hots Hierarchy- A way to organize different levels of a dimension (usually largest to smallest) Customer Month Quarter Year Q1 Q2 Q3 Q4 2011

  10. Demonstration of the user interface within Excel

  11. Three Myths about Cubes • Cubes require months of planning and implementation before users can get value out of them - Jet Enterprise is typically installed and running in two hours or less for NAV and GP customers • Customizing Cubes is slow and difficult • Jet Enterprise includes a Data Warehouse Automation tool which makes it easy to customize cubes in a drag-and-drop interface • Cube are a luxury, applicable only to large companies with BI development teams and large budgets - This is no longer true. Jet Reports has more than 600 clients running our cubes, ranging from large multi-national corporations to small non-profits Secret Session: OLAP Cubes 101 – Introduction and Terminology Questions? Sales.US@Jetreports.com

  12. FREE Report Designer with ALL new packages + $500 Off Jet Enterprise BI Q2 PROMOTION Valid Until 6/26/14 - Cannot be Combined with Other Offers Thank you for your participation! Presenter: Steve Little Sales.US@Jetreports.com

More Related