E-Business Intelligence
Agenda Issue E-BI Architecture ORACLE E-BI Solutions ORACLE E-BI ORACLE E-BI
I. Issue? KPI. (KPI ). Jeff Henley, CFO, Oracle Corporation
I. Issue?
I. Issue Many Sources, Users,and Uses Sales Marketing Finance Operations Human Resources Region Region Region
II. E-BI Architecture The business intelligence imperative insists we elevate BI to a strategic initiative now, or risk disaster! - Howard Dresner Gartner group
II. E-BI Architecture Gartner BI Architecture A business intelligence framework enables enterprises to align their various BI initiatives and helps them determine the right return on investment. By 2003, most ERP vendors will offer a credible BI platform (0.7 probability). Viador PlumTree Hyperion Cognos ABC Tech Crystal Reports Business Objects Micro Strategy Informatica SAS engines will Microsoft haveoim absorbed Prism 60 Sagent percent of BI platform IBM functionality Sybase By 2003,RDBMS (0.6 probability). SAP People Soft JD Edwards Gartner Report SPA-13-8990, July 2001
III. Oracle E-BI Solutions E-BI Now! BSC/ABM/EPB/OFA Analyzer Op. Intelligence Discoverer Express Reports Workbooks Ad-hoc Queries Performance Management Framework Workflow Alert Personal Homepage Data Data Data DataMart Mart Mart EDW Architecture Data Mart Oracle Warehouse Builder Flat ORACLE Applications files Legacy Database SAPDB2
III. Oracle E-BI Solutions Role-Based Intelligence Integration KPI, Performance Measures Data and Architecture Personalization Free from Source Embedded DW Cost effective Built-in Best Practice
III. Oracle E-BI Solutions Role-Based Intelligence Role Required Intelligence Solution KPI Personalized View, Best practice Balanced Scorecard ABM/ Analyzers Line Manager (Alert) Process Benchmarks Embedded Data Warehouse Enterprise Front Applications Office Applications Internet Computing Operational Intelligences
III. Oracle E-BI Solutions Integration : Framework Planning PM/PI KPI CSF Doing Profit Sharing Incentive Merit Increase Seeing
III. Oracle E-BI Solutions Personalization Personal Home Page(PHP)/Portal Single Sign-On Favorites Inbox Menu Shortcuts Current Documents Charts Tabbed User Interfac Search a Topic Calendar To-do list Performance Measur View Report
III. Oracle E-BI Solutions (Scalability, Extensibility) Integration from heterogeneous sources Low TCO Oracle Mainframe DB2, Informix SAP, People Soft Syndicated data Benchmarking data 1 Define Sources 2 3 4 Design Target Warehouse Map Source to Target Generate Code OWB (Oracle Warehouse Builder) 5 Instantiate Warehouse 6 Extract Data
III. Oracle E-BI Solutions BI - OBSC :
III. Oracle E-BI Solutions BI - OBSC : What technologies/tools to facilitate the performance measurement process? How would you rate the quality of information in the PM Sys.? Specialized Tools(EIS, DSS) 93% Excellent More than adequate 21% ERP Adequate Generic Tools (Excel, Access, Notes) Less than adequate Poor (N=1,767/1,990) 0% 20% 40% 60% 80%100% (N=1,808/1,990) 0% 10% 20% 30% 40% 50% 60% Source: Performance Measurement Practices Survey Results, AICPA,Inc., 2001
III. Oracle E-BI Solutions BI - OBSC : What techniques are utilized to capture performance information? Executive Dashboard BSC 43% Others (N=1,440/1,990) 0% 10% 20% 30% 40% 50% 60% Source: Performance Measurement Practices Survey Results, AICPA,Inc., 2001
III. Oracle E-BI Solutions BI - OBSC : Communication
III. Oracle E-BI Solutions BI - OABC/M :
III. Oracle E-BI Solutions BI - OABC/M : Process
III. Oracle E-BI Solutions BI Analyzer : Pivoting /,,,,,... OFA OBA Discoverer Express : GL /
III. Oracle E-BI Solutions BI - O I* : Zero (Management by Exception) Predefined Performance Measure Alert Details High Range Exception Target Low Range Exception Alert Recipients Alert Schedule * Operational Intelligence
IV. Oracle E-BI Solutions BI BI BI Right Management Feedback Fact Business BI Anytime Anywhere Every Person ERP - Intelligence
V. Oracle E-BI Oracle
D E M O N S T R A T I O N Oracle E-BI Suite
V. Oracle E-BI Oracle E-BI : Role-Based Intelligence E-BI PORTAL
V. Oracle E-BI - Cycle time
V. Oracle E-BI ERP (, ) 25 : Action ERP+ (BSC+ABM+OFA) 7 : Action, 3~4/ Data 5~8/ Data 8~10/ 10~15 15~17/ 18~25 16~18 25~, 31/ Data 1~2/ 3~4/ ABM 5~6 Review BSC CEO Load 5 Monitoring Feedback 5~6 BSC 7~10 OI 7~10 7 ~ Manual Process Automated Process Decision Corrective Action /
Q & A Q U E S T I O N S A N S W E R S