E-BI Day Presentation

Size: px

Start display at page:

Download "E-BI Day Presentation"

서헉 개
5 years ago
Views:

2 E-Business Intelligence

3 Agenda Issue E-BI Architecture ORACLE E-BI Solutions ORACLE E-BI ORACLE E-BI

4 I. Issue? KPI. (KPI ). Jeff Henley, CFO, Oracle Corporation

5 I. Issue?

6 I. Issue Many Sources, Users,and Uses Sales Marketing Finance Operations Human Resources Region Region Region

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

8 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 , July 2001

9 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

10 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

11 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

12 III. Oracle E-BI Solutions Integration : Framework Planning PM/PI KPI CSF Doing Profit Sharing Incentive Merit Increase Seeing

13 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

Syndicated data Benchmarking data 1 Define Sources 2 3 4 Design Target Warehouse

14 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 Design Target Warehouse Map Source to Target Generate Code OWB (Oracle Warehouse Builder) 5 Instantiate Warehouse 6 Extract Data

15 III. Oracle E-BI Solutions BI - OBSC :

16 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

17 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

18 III. Oracle E-BI Solutions BI - OBSC : Communication

19 III. Oracle E-BI Solutions BI - OABC/M :

20 III. Oracle E-BI Solutions BI - OABC/M : Process

21 III. Oracle E-BI Solutions BI Analyzer : Pivoting /,,,,,... OFA OBA Discoverer Express : GL /

22 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

23 IV. Oracle E-BI Solutions BI BI BI Right Management Feedback Fact Business BI Anytime Anywhere Every Person ERP - Intelligence

24 V. Oracle E-BI Oracle

25 D E M O N S T R A T I O N Oracle E-BI Suite

26 V. Oracle E-BI Oracle E-BI : Role-Based Intelligence E-BI PORTAL

27 V. Oracle E-BI - Cycle time

28 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 /

29 Q & A Q U E S T I O N S A N S W E R S

Oracle Apps Day_SEM

Oracle Apps Day_SEM Senior Consultant Application Sales Consulting Oracle Korea - 1. S = (P + R) x E S= P= R= E= Source : Strategy Execution, By Daniel M. Beall 2001 1. Strategy Formulation Sound Flawed Missed Opportunity