hyperionessbase多維數(shù)據(jù)庫(kù)(編輯修改稿)
2025-03-20 13:28 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 le, Kentucky, is one of the nation’s largest publicly traded health and supplemental benefits panies, with approximately million medical members and million specialty members. After ? Oracle Financial Analytics, Essbase and OBIEE are all integrated with Oracle EBS to provide “accelerated reporting cycles”. ? Essbase cubes and Financial Analytics dashboards are refreshed 4X daily ? “Super Users” within business units handle the vast majority of reporting needs ? Humanaspecific customizations are easily created and supported with Oracle BI ? Over 400 Dashboards are in production Copyright 169。 2022, Oracle and / or its affiliates. All rights reserved. 23 The Challenges to Answering Forward Looking Questions Timeconsuming Management reporting and Variance analysis Users living in spreadsheet hell Inability to build new scenarios 3 2 1 Copyright 169。 2022, Oracle and / or its affiliates. All rights reserved. 24 Most Modeling is Done Here! It is a Good Departmental Tool, but… ? Disconnected ? Data Security Risks ? Errorprone ? Doesn’t scale ? No controls / audit trails Copyright 169。 2022, Oracle and / or its affiliates. All rights reserved. 25 Users are Accustomed to Spreadsheets ? Spreadsheets are inefficient for more than two dimensions ? Data (Measures) for each bination of “Row” by “Column” ? ., Sales for Qtr1 = 95,820 Measures Time Copyright 169。 2022, Oracle and / or its affiliates. All rights reserved. 26 But Business is More than Two Dimensions ? We typically look at more than two dimensions (multidimensional) ? So what do we do? ? Add more column headers! ? In our example: ? “Total” Market BY “Total” Product, Actual Sales for Qtr1 = 95,820 ? Creates HEADACHES! Measures Time Scenario Market Product Copyright 169。 2022, Oracle and / or its affiliates. All rights reserved. 27 MultiDimensional = MultiSheet… ? Add a sheet for each market ? 4 Markets + Total = 5 Sheets ? The problem exacerbates… Market(s) Copyright 169。 2022, Oracle and / or its affiliates. All rights reserved. 28 MultiSheet = Nightmare ? How about by Product and by Market? ? 5 Markets BY 500 Products = 2500 Sheets! ? What about by Industry too? ? Wele to “Spreadsheet Hell” Copyright 169。 2022, Oracle and / or its affiliates. All rights reserved. 29 The Solution: Eradicate Spreadsheet Hell Essbase Provides the Best of Both Worlds ? Use the same familiar tools, Excel, Word, PowerPoint ? Achieve Speed of Thought response time ? Benefit from a centralized enterprisescale solution Oracle Essbase Copyright 169。 2022, Oracle and / or its affiliates. All rights reserved. 30 No More Spreadsheet Hell Improved Performance Visibility and Service Quality Before ? Excel – cumbersome, manually maintained (store managers phoned in results) ? Data discrepancies, low confidence in the numbers ? No standard set of performance measures, lack of detail for analysis ? Operators and managers spent a lot of time gathering data, less on running the business Third largest pizza chain in the US 3000 locations worldwide More than $1 billion in sales After ? Improved availability of data (from hours to 30 minutes) ? Standard set of measures ? Improved quality of service (order pleteness improved, “out the door“ time reduced 10%, higher customer satisfaction scores) ? Faster identification and reaction to theft issues Copyright 169。 2022, Oracle and / or its affiliates. All rights reserved. 31 The Challenges to Answering Forward Looking Questions Timeconsuming Management reporting and Variance analysis Users living in spreadsheet hell Inability to build new scenarios 3 2 1 Copyright 169。 2022, Oracle and / or its affiliates. All rights reserved. 32 Volatility Demands Rapid Scenario Modeling Commodity Prices, Energy Prices, Interest Rates… Copyright 169。 2022, Oracle and / or its affiliates. All rights reserved. 33 But Models are Constantly Evolving Dynamic, Iterative Processes Drive New Questions McDonalds: application that collects POS data every 15 minutes to monitor amp。 model customer service levels Alcoa: marketing application called SMART (Strategic Marketing Analysis and Reporting Tool) for tracking and modeling product profitability across 29 dimensions Southwest Airlines: application for modeling fuel costs and demand (98% forecast accuracy after the 9/11 crisis) C
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1