1 / 18

OLAP TOOLS

OLAP TOOLS. Alex Barfield Jechand Chennupati John O’Toole Shantea Stanford Marc Tardif. Agenda. OLAP Overview OLAP Concerns & ProClarity Background How ProClarity Works How to Use ProClarity Hands-on Exercise Decomposition Tree Demo Example Query Quiz!!!. The FASMI Test.

brian
Download Presentation

OLAP TOOLS

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 TOOLS Alex Barfield Jechand Chennupati John O’Toole Shantea Stanford Marc Tardif

  2. Agenda • OLAP Overview • OLAP Concerns & ProClarity Background • How ProClarity Works • How to Use ProClarity • Hands-on Exercise • Decomposition Tree Demo • Example Query • Quiz!!!

  3. The FASMI Test • Fast – System delivers responses to users within roughly 5 seconds • Analysis – System copes with relevant business logic and statistical analysis, yet is simple enough for target user • Shared – System handles multiple updates in a secure and timely manner • Multidimensional – A conceptual view of the data along several dimensions • Information – All data and derived information needed, capacity measured by how much input data can be handled

  4. More OLAP Features • Cubes - Typically, “cubes” of data are examined along X, Y, and Z axes • Dicing - Data “diced” in a range specified for each dimension • Drill-down/Roll-up - Data can be disaggregated (drill-down) or aggregated (roll-up) along a dimension • Slicing - Data can be rotated to produce different views or “slices” of a cube for analysis

  5. OLAP Applications • Marketing/Sales Analysis – Consumer goods, retailers, financial services • Clickstream Analysis – e-commerce sites in constant redesign based on analysis • Financial Reporting/Consolidation – Accounts, org. structure, time, actual/budget/forecast, business line/product line = 5 or 6 dimensions

  6. OLAP Market

  7. OLAP Market Niches • Application OLAP – Complete applications or toolkits from which complex applications can be built, integration and high functionality, complexity and high cost per user • MOLAP – Unbundled, high performance multidimensional or hybrid databases, multi-user updating, applications handled are smaller than ROLAP

  8. OLAP Market Niches • DOLAP – Client-based OLAP products, easy to deploy and low cost per seat, limited functionality and capacity • ROLAP – Data and metadata in a RDBMS, none stored in external files, large data volumes, complex and expensive, slow query performance, smallest OLAP niche by far

  9. Pricing • Hyperion’s Essbase - $25,000, includes 10 licenses • Microsoft’s SQL Server - $5,000 (Standard Edition) and $20,000 (Enterprise Edition) • Cognos - ~$1,200 per seat • ProClarity - $495 per seat + 20% maintenance fee

  10. OLAP Competitors

  11. OLAP Competitors

  12. OLAP Competitors

  13. OLAP Concerns • Company Politics - Much more troubling than product issues • “Environmental” – Failure to agree on (and stick to the agreed) requirements • Quality – Poor data quality and unavailable data

  14. OLAP Concerns • Slow Query Performance – Most commonly reported product-related problem • Reliability – Relatively few sites report problems, but the more expensive products had the most reported problems • Results – Higher priced products did not necessarily achieve better results than lower-priced options

  15. The Microsoft Effect • Bundling – MS-OLAP bundled with its low-priced SQL Server • Cost – MS product is low cost yet scalable, builds cubes quickly with good query response time • Marketing – OLAP software should proliferate due to Microsoft’s marketing network

  16. Increased OLAP Usage • Commodity Position – MS-OLAP will likely transition OLAP software into a commodity • Choice – Many will choose MS-OLAP on price, ease of use, and availability • “New” users – These will represent the OLAP move from specialist boutique to a mass market

  17. ProClarity • Accessible – Founded in 1995 to make OLAP accessible to broader business market • Experienced – Consulting, traning, and market-development staff (US & Europe) • Legitimate – Over 250 corporate customers, 30 independent software vendor partners, and closely linked with Microsoft

  18. ProClarity/MS Partnership • Familiarity – ProClarity provides analysis tools in the context of MS Office 2000, Outlook Digital Dashboard, IE • “Live” Reporting – With familiar MS & ProClarity products, decision-makers can query their data to do live reporting • Corporate Goal – Give decision-makers a clear understanding of the drivers of their organizations performance

More Related