f5afaaaaf064c11c26d4f33686da98eb.ppt
- Количество слайдов: 57
1
<Insert Picture Here> Business Intelligence Applications
BI and Performance Management Consistently the Top IT and Business Priorities Worldwide “… the most important technology in 2007 is Business Intelligence” Finance’s Top Area of Importance Sources: CIO Insight, “The Future of I. T. : What's on Tap for 2007 and Beyond, ” January 16, 2007; IBM Business Consulting Services, “The Global CFO Study 2005” 5
Business Intelligence Drives Increased Effectiveness in every Business Function Financial Analytics Sales Analytics Real-time view of financial condition and drivers of cost and profitability Improve pipeline visibility and forecast accuracy Service & Contact Center Analytics Supply Chain Analytics Optimize supplier sourcing, supplier performance, and inventory levels Convert service calls into sales through enhanced cross-selling HR / Workforce Analytics Marketing Analytics Real-time visibility into campaign execution, results, and ROI Understand what drives employee productivity and org. performance 6
<Insert Picture Here> Our Mission Making our software a source of continual competitive advantage for our customers Better Information Better Results 7
Our Approach to BI Applications 1 Pre-Build Applications to reduce complexity and TCO for our customers 2 Extend Applications with Best in Class Technology 3 Integrate BI Applications with ERP and CRM 8
Pre-Built BI Applications from Oracle Reduce Complexity DASHBOARDS • “Visible” “PLUMBING” • “Under the Surface” • Mappings to multiple applications and data transformation all take expertise and time DELIVER BETTER INSIGHT TO CUSTOMERS’ MULTI-APPLICATION ENVIRONMENTS 9
Oracle’s Product Strategy • Integrated Business Intelligence Database • Business Intelligence & Data Mining Functions Integrated in Database • Integrated Business Intelligence Tools • Best-of-Breed, Next Generation Business Intelligence Technology Platform • Integrated Analytic Applications • Enterprise Wide, Industry Specific Analytic and Corporate Performance Management Applications Exploits Any Information Technology Environment 10
Analytic Applications Families All on Common Oracle BI EE Technology New Fusion Intelligence for EBS Fusion Intelligence for People. Soft Enterprise Enhancement/Extension of DBI Extension of EPM, Replacement for BO, Cognos, MSTR Interactive Dashboards Reporting & Publishing Ad-hoc Analysis Proactive Detection and Alerts New Version Oracle BI Applications Single source, Multi-source For EBS, PSFT, SEBL, SAP, Other Disconnected Analytics MS Office Plug-in Web Services Oracle BI Suite EE Other Operational & Analytic Sources 12
Oracle BI Suite Enterprise Edition Unified Business Intelligence Infrastructure Interactive Dashboards Reporting & Publishing Ad-hoc Analysis Proactive Detection and Alerts Disconnected Analytics MS Office Plug-in Web Services Enterprise Business Model and Abstraction Layer Oracle BI Server Intelligent Caching Services Multidimensional Calculation and Integration Engine Intelligent Request Generation and Optimized Data Access Services OLTP & ODS Systems Data Warehouse Data Mart SAP, Oracle People. Soft, Siebel, Custom Apps Files Excel XML Business Process 13
Oracle BI Applications Single- and multi-source Analytic Apps Built on BI Suite EE Sales Service & Contact Center Order Management & Fulfillment Marketing Supply Chain Financials Human Resources Oracle BI Applications Interactive Dashboards Reporting & Publishing Ad-hoc Analysis Proactive Detection and Alerts Disconnected Analytics MS Office Plug-in Web Services Oracle BI Suite EE Packaged ETL Maps BAW Schema Universal Adapters IVR, ACD, CTI Hyperion MS Excel Other Data Sources 14
Oracle BI Applications Multi-Source Analytics with Single Architecture Auto Comms & Media Complex Consumer Sector Mfg Sales Service & Contact Center Pipeline Analysis Energy Financial Services High Tech Insurance Life & Health Sciences Public Sector Travel & Trans Marketing Order Management & Fulfillment Supply Chain Financials Human Resources Churn Propensity Campaign Scorecard Order Linearity Supplier Performance A/R & A/P Analysis Employee Productivity Triangulated Forecasting Customer Satisfaction Response Rates Orders vs. Available Inventory Spend Analysis Sales Team Effectiveness Resolution Rates Product Propensity Cycle Time Analysis Procurement Cycle Times Customer & Product Profitability HR Compliance Reporting Up-sell / Cross-sell Service Rep Effectiveness Loyalty and Attrition Backlog Analysis Inventory Availability P&L Analysis Workforce Profile Cycle Time Analysis Service Cost Analysis Market Basket Analysis Fulfillment Status Employee Expenses Expense Management Turnover Trends Lead Conversion Service Trends Campaign ROI Customer Receivables BOM Analysis Cash Flow Analysis Return on Human Capital GL / Balance Compensation Sheet Analysis Other Operational & Analytic Sources Prebuilt adapters: Oracle BI Suite Enterprise Edition 15
Oracle BI Applications Multi-Source Analytics with Single Architecture Auto Comms & Media Complex Consumer Sector Mfg Sales Service & Contact Center Pipeline Analysis Energy Financial Services High Tech Insurance Life & Health Sciences Public Sector Travel & Trans Marketing Order Management & Fulfillment Supply Chain Financials Human Resources Churn Propensity Campaign Scorecard Order Linearity Supplier Performance A/R & A/P Analysis Employee Productivity Triangulated Forecasting Customer Satisfaction Response Rates Orders vs. Available Inventory Spend Analysis Sales Team Effectiveness Resolution Rates Product Propensity Cycle Time Analysis Procurement Cycle Times Customer & Product Profitability HR Compliance Reporting Up-sell / Cross-sell Service Rep Effectiveness Loyalty and Attrition Backlog Analysis Inventory Availability P&L Analysis Workforce Profile Cycle Time Analysis Service Cost Analysis Market Basket Analysis Fulfillment Status Employee Expenses Expense Management Turnover Trends Lead Conversion Service Trends Campaign ROI Customer Receivables BOM Analysis Cash Flow Analysis Return on Human Capital GL / Balance Compensation Sheet Analysis Other Operational & Analytic Sources Prebuilt adapters: Oracle BI Suite Enterprise Edition 16
Oracle Financial Analytics Product Components 1 Pre-built warehouse with 16 star- schemas designed for analysis and reporting on Financial Analytics 3 Pre-mapped metadata, including embedded best practice calculations and metrics for Financial, Executives and other Business Users. Ø Presentation Layer Ø Logical Business Model Ø Physical Sources 2 Pre-built ETL to extract data from 4 A “best practice” library of over 360 over 3, 000 operational tables and load it into the DW, sourced from SAP, PSFT, Oracle EBS and other sources. pre-built metrics, 30 Intelligent Dashboards, 200+ Reports and several alerts for CFO, Finance Controller, Financial Analyst, AR/AP Managers and Executives 17
Oracle BI Applications Architecture Dashboards by Role Oracle BI Presentation Services § § § Role Based Dashboards Analytic Workflow Guided Navigation Security / Visibility Alerts & Proactive Delivery Oracle BI Server § § Logical to Physical Abstraction Layer Calculations and Metrics Definition Visibility & Personalization Dynamic SQL Generation § § Abstracted Data Model Conformed Dimensions Heterogeneous Database support Database specific indexing § § § Highly Parallel Multistage and Customizable Deployment Modularity Logical Model / Subject Areas Physical Map Metadata Metrics / KPIs Data Warehouse / Data Model Direct Access to Source Data Load Process Staging Area ETL DAC Administration Reports, Analysis / Analytic Workflows Extraction Process Oracle SAP R/3 Siebel PSFT EDW Federated Data Sources Other 18
Oracle BI Apps: Selected Key Entities Unified multi-source data model Sales § Opportunities § Quotes § Pipeline Order Management § Sales Order Lines § Sales Schedule Lines § Bookings § Pick Lines § Billings § Backlogs Marketing § Campaigns § Responses § Marketing Costs Supply Chain § Purchase Order Lines § Purchase Requisition Lines § Purchase Order Receipts § Inventory Balance § Inventory Transactions Finance § Receivables § Payables § General Ledger § COGS Call Center § ACD Events § Rep Activities § Contact-Rep Snapshot § Targets and Benchmark § IVR Navigation History Service § Service Requests § Activities § Agreements Workforce § Compensation § Employee Profile § Employee Events Pharma § Prescriptions § Syndicated Market Data Financials § Financial Assets § Insurance Claims Public Sector § Benefits § Cases § Incidents § Leads Conformed Dimensions § § § § Customer Products Suppliers Cost Centers Profit Centers Internal Organizations Customer Locations Customer Contacts GL Accounts Employee Sales Reps Service Reps Partners Campaign Offers Modular DW Data Model includes: ~350 Fact Tables ~550 Dimension Tables ~5, 200 prebuilt Metrics (2, 500+ are derived metrics) ~15, 000 Data Elements 19
Example: Analytic Workflows Business Objectives / Issues Maximize Cash Flow Is DSO on target? Is Overdue Balances trending up? How long is the underlying Overdue Balance pending? What is the aging of Due Balances? Who are the Customers and Collectors? Gain Insights Are Payment Terms in compliance? Drill to Due Balances by Region Drill to Overdue Invoice Detail Take Action Is DPO on target? • Business Function: Receivables • Role: Director, Credits & Collections • Objectives: • 1) Maximize Cash Flow • 2) Control Risk of Receivables Portfolio Target collection efforts to reduce overdue balances 20
Example: Analytic Workflows Business Objectives / Issues Maximize Cash Flow Is DSO on target? How long is the underlying Overdue Balance pending? tail o De Gain Insights Drill t Is Overdue Balances trending up? Who are the Customers? Drill to Overdue Invoice Detail Take Action Target collection efforts to reduce overdue balances 21
PCS Computing: Analytics in Action 1 Sales Identify Problem w/ Revenue 2 3 Supply Chain 10 Problem with Invoice & Backlog Locate Substitute Product 4 5 Finance Source Additional Parts 6 Identify Overstocked Laptops Verify Supplier Payable Status 7 Marketing Create Campaign for Overstock 8 Ensure Campaign Readiness Contact Center 9 Workforce Execute Multichannel Sales Campaign Address Agent Retention issue 11 Monitor Contact Center Performance 23
Seamless Analytics Across Multiple Data Sources Sales Supply Chain Finance Marketing Contact Center Workforce 24
Speeds Time To Value and Lowers TCO Build from Scratch with Traditional BI Tools Oracle BI Applications Training / Roll-out Oracle BI Applications solutions approach: • Faster time to value • Lower TCO • Assured business value Define Metrics & Dashboards DW Design Training / Rollout Back-end ETL and Mapping Define Metrics & Dashboards DW Design Back-end ETL and Mapping Months or Years Easy to use, easy to adapt Role-based dashboards and thousands of pre-defined metrics Prebuilt DW design, adapts to your EDW Prebuilt Business Adapters for Oracle, People. Soft, Siebel, SAP, others Weeks or Months Source: Patricia Seybold Research, Gartner, Merrill Lynch, Oracle Analysis 25
What Customers Are Achieving With Oracle BI Applications Deployed to 800 users in under 90 days Analytics for sales-oriented contact center Live in 120 days Sales Analytics Deployed to 3, 000+ users in 3 months Sales Analytics 4 months from decision to live for 1, 200 users Pharma Analytics Live in 100 days, 6, 500 users Sales and Marketing Analytics “I can vouch that it can be deployed as rapidly as they claim. . . It is a product that really delivers. ” 26
New BI Applications 7. 9 Release 27
7. 9 Release Themes • Unified multi-source data model • Enhanced user experience • Data Warehouse Administration Console • Expanded deployment options • Support Oracle EBS v 11 i 9 and v 11 i 10 • Support DB 2 V 8 on z/OS as both source and target database • Support Teradata V 2 R 6 as target database • Full localization • Translation to 15 languages 28
Tight Integration with Applications Shared security with Oracle EBS and Siebel CRM • EBS Security Integration • FND_User security • Shared responsibilities between Oracle EBS and Oracle BI Apps • Oracle SSO • Siebel CRM Security Integration • Siebel native security • Shared responsibilities between Siebel CRM and Oracle BI Apps • Hot-Pluggable Security • Pre-built security roles in BI Applications • Users/roles synchronized with selected security environment 29
Tight Integration with Applications Action Links navigate from analytical to operational • Action Links • Direct navigation from analytical report to transactional detail while maintaining context • Take action immediately without navigating to a different screen • Oracle EBS Integration • Siebel CRM Integration 30
Analytic Workflows Directed analysis helps inexpert users Guided Navigation • Enables users to quickly navigate a standard path of analytical discovery specific to their function and role • Enhances usability and lowers learning curve for new users Conditional Navigation • Appears only when conditions are met and alerts users to potential out of ordinary conditions that require attention • Guides users to next logical step of analytical discovery 31
Data Warehouse Administration Console (DAC) Strong Competitive Differentiator • For warehouse developers and ETL Administrator • “ETL orchestration tool” • Application Configuration • Execution & Recovery • Monitoring • Allows: • Pin-point deployment • Load balancing • Reduced load windows • Fine-grained failure recovery 32
Portfolio of Analytic Applications 33
Analytic Applications Families All on Common Oracle BI EE Technology New Fusion Intelligence for EBS Fusion Intelligence for People. Soft Enterprise Enhancement/Extension of DBI Extension of EPM, Replacement for BO, Cognos, MSTR Interactive Dashboards Reporting & Publishing Ad-hoc Analysis Proactive Detection and Alerts New Version Oracle BI Applications Single source, Multi-source For EBS, PSFT, SEBL, SAP, Other Disconnected Analytics MS Office Plug-in Web Services Oracle BI Suite EE Other Operational & Analytic Sources 34
Daily Business Intelligence Fully Integrated Business Intelligence for the E-Business Suite • Suite of pre-built, role-based BI Applications • Easy-to-use, interactive, and extensible dashboards • Seamless integration with E-Business Suite • Single source of truth (no upload to data warehouse) • Seamless drilldown to transaction tables • Easy to deploy • No separate ETL tool to learn and maintain • Very low TCO 35
Oracle Daily Business Intelligence (DBI) Easy-To-Use Dashboards Within E-Business Suite • • Role Based Dashboards Leverages EBS Infrastructure and Materialized Views No Data Movement Required Drill Directly to Transactions from Summaries Implements in Days Fastest Path to Information from EBS Part of EBS “Rapid Install” No Training Required 36
Drill Through: Summary to Actual Transactions Summary & Trends Detail Information Transactions 37
EBS R 12: Continued Delivery of Pre-built Apps 11 i. 9 (DBI v 6) 11 i. 10 (DBI v 7+) 12 (DBI v 8) Dashboards 33 54 60 KPIs 214 313 362 Intelligence Reports 377 827 918 Finance Human Resources Supply Chain Procurement § CFO § VP of HR § Supply Chain VP § CFO § Controller § Line Management § Service VP § CPO § Treasurer § HR Manager § Manufacturing VP § VP Corporate § AP manager § Line Manager § Material Management § AR Manager § HR Analyst § Assets Manager § Benefits Manager § Product Management VP § Tax Manager § Benefits Analyst § Planning VP § VP Central Procurement § Cost Manager § Learning Manager § Plant Manager § Procurement Manager § Projects Manager § HR Specialist § Production Manager § Buyer § Revenue Manager § Learning Coordinator § Production Line § Contracts Manager § Collections Manager § HR Help Desk Manager § Payroll Manager § Compensation Manager § Accountant § Compensation Analyst § Compliance Clerk § Benefits Manager § Inventory Manager § AP Clerk § Benefits Analyst § Warehouse Manager § AR Clerk § HR Analyst § Sales Contracts Mgr § Financials Analyst VP Supervisor Procurement § VP Business Unit Procurement § Contracts Administrator § Production Scheduler § Commodity Manager § Production Process § Sourcing Strategy Engineer Analyst § Contracts Analyst
Fusion Intelligence EBS Edition Pre-Packaged Repository Scope Financials Intelligence • General Ledger • • AP Expenses (GL) AR Revenue (GL) GL Activity Budget Supply Chain Intelligence • • Order to Revenue Order Fulfillment and Shipping Manufacturing (Process and Discrete) Inventory (Process and Discrete) • Accounts Payable • • • AP Invoices Aging (Due & Past) AP Payments Schedule • Accounts Receivable • • • AR Adjustments AR Payments Schedule AR Receipts AR Invoices AR Aging Receivables • Sales Credits • Compliance • • Sales Opportunity Sales Pipeline Sales Forecasting Service Human Resources Intelligence Procurement Intelligence • • CRM Intelligence Procurement Management Supplier Management • • • DBI Workforce Activity and Deployment DBI Compensation Salary Summarization DBI Leave and Absences HCM EUL Recruitment Pipeline HCM EUL Recruitment Vacancies Not a Commitment to Deliver—Subject to Change 39
Solution Architecture Components of Intelligence Applications Oracle BI Applications (former SBA) Fusion Intelligence for People. Soft Pre-Packaged Reports Pre-Packaged Dashboards Pre-Packaged Semantic Objects Maps JD Edwards Packaged Integrations Fusion Intelligence for Oracle Metrics In-Place Schema (DBI) MDW (EPM) RMW & CW (SBA) Models 40
Fusion Intelligence for EBS “Best of Both Worlds!” After Value Proposition : Flexible, Extensible BI Platform that is open to multiple data sources; low TCO of DBI "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality 41 described remains at the sole discretion of Oracle"
Fusion Intelligence for EBS Features Flexible Time Periods After Multiple Currencies Guided Navigation Key Performance Indicators Summary Results Multiple Data Widgets for presenting data "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality 42 described remains at the sole discretion of Oracle"
Fusion Intelligence for EBS Details • End-to-end Oracle solution • Pre-packaged dashboard templates • A repository with a business model based on underlying DBI data model 43
Pre-Integrated For Embedded BI Embedded, In-context, reports and graphs to promote action within transactional workflows 44
Guided Drilldown Summary & Trends Detail Information Actual Transactions 45
Ad-hoc Query Capability • DBI Base Summaries and • • MVs available for Ad-hoc analysis New Calculated Fields Available within Market Leading BI Toolset Easy to use Charting tool Formatting Widgets Highlighting Multi-language 46
Guided Navigation & Action Links • Analytic Workflows • Guided Navigation and Conditional Navigation links • Checks for specific conditions and displays (or not) a dashboard section, or a navigational link to either a report or a dashboard • Action Links • Direct navigation from record to transactional while maintaining context 47
Integrated Security • Launch Oracle DBI EE dashboard from Application Navigator • Shared responsibilities between Oracle EBS and Oracle DBI EE • Sign in only once in EBS 48
Three Components of Fusion Intelligence 1 Fusion Intelligence for EBS and People. Soft* 2 Oracle BI Enterprise Edition Suite License 3 DBI or EPM Apps (many customers already have this) OLTP EBS PSFT 49
Product Roadmap 50
Oracle BI Apps Roadmap OBI Apps Oracle BI Applications BI 7. 9 § Unified enterprise data model § Leverages BI EE 10 g. R 3 § Enhanced DAC Oracle BI Applications 7. 9. 1 § PSFT 8. 8 HR, Financials adapter § SEBL 8. 0 adapter § Data Lineage Console § OFSA Analytics BI Oracle BI Applications BI 8. 0 § New application content Oracle BI Applications BI 7. 9. 0. 1 § Translation to 15 languages Oracle BI Applications 7. 9. X § PSFT 8. 9, 9. 0 HR, Financials adapters § SAP 4. 6 c, 4. 7 adapters § EBS R 12 adapter BI Oracle BI Apps for Fusion Applications "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality 51 described remains at the sole discretion of Oracle"
Oracle BI Applications ETL Adapter Support CRM Financials Human Resources Supply Chain Order Management Procurement & Spend EBS 12 7. 9. x EBS 11. 5. 10 7. 9. x 7. 9 7. 9 EBS 11. 5. 9 7. 9 EBS 11. 5. 8 7. 9 7. 9 PSFT 9. 0 7. 9. x PSFT 8. 9 7. 9. x PSFT 8. 8 7. 9. 1 SAP 4. 7 7. 9. x SAP 4. 6 c 7. 9 Universal 7. 9 7. 9. 1 7. 9. x Strategy: ETL adapters to be delivered as 7. 9. x patches as they become available. To be available soon: • SEBL 8. 0 Siebel 8. 0 7. 9. 1 • PSFT 8. 8 Siebel 7. 8 7. 9 • PSFT 8. 9 Siebel 7. 7 7. 9 Siebel 7. 5 7. 9 Siebel 6. 3 7. 9 Not Applicable • EBS 12 • SAP 4. 6 c • SAP 4. 7 "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality 52 described remains at the sole discretion of Oracle"
Fusion Intelligence Supported Integrations CRM Financials Human Resources Supply Chain Order Management Procurement & Spend EBS 12 FI R-0. 1 EBS 11. 5. 10 FI R-0 FI R-0 EBS 11. 5. 9 DBI v 6 DBI v 6 PSFT 9. 0 EPM 9. 0 FI R-0 EPM 9. 0 PSFT 8. 9 EPM 9. 0 FI R-0 EPM 9. 0 PSFT 8. 8 EPM 9. 0 FI R-0 EPM 9. 0 PSFT 8. 4 EPM 9. 0 FI R-0 EPM 9. 0 SAP 4. 7 SAP 4. 6 c Siebel 8. 0 7. 9 Siebel 7. 5 FI R-0, DBI v 6+: Released FI R-0. 1 - In dev, target end of Apr. 7. 9 Siebel 6. 3 No planned release 7. 9 Siebel 7. 7 FI R-0. 1 7. 9. 1 Siebel 7. 8 FI R-0, DBI R-0 7. 9 Not Applicable "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality 53 described remains at the sole discretion of Oracle"
OBIA ETL Statement of Direction • Informatica and Oracle Data Integrator to be supported • Informatica Power. Center • OEM distribution extended until at least 2010, with optional extensions • After distribution terminates, 8 additional years full support for existing customer, including new Informatica versions • Informatica use: any sources, any extension of BI Applications, must be used to target BI Applications • Oracle Data Integrator (ODI) • Plan to offer as alternative to Informatica • Full ongoing support for both Informatica and ODI • DAC to support both Informatica and ODI "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality 54 described remains at the sole discretion of Oracle"
<Insert Picture Here> Working with Oracle Marketing Joe Thomas April 3 rd, 2007
“Intelligent” Partners… 1 …are easy to market! 2 …know how to tell a good story! 3 …are good partners! 58
…are easy to market • Differentiated Skills • Expertise, Geography, Verticals, “Oracle Only” vs “Mixed” • Ready to Engage • Have stories, spokespeople and venues, and want to take advantage of Oracle’s • Agile • Short “windows of opportunity” • Avoid lengthy approval cycles 59
…know how to tell a good story • Interesting Characters • Can “names”, customer hook • Engaging Plot • Details/Metrics/Benchmarks • Business Problem • Happy Endings • Business Benefits • Customer quotes 60
…are Good Partners • Engaged with the Oracle Network • BI Partner Team, Product Marketing, Field Marketing, BI Sales Team, ASMs, PR, Oracle Press, AR, Executives. • Understand the Oracle Eco-system • User Groups • Mutual Partners • Shared Value Proposition • Partners not vendors • Willing to co-brand co-sponsor events and content 61
Suggestions • Write my marketing pitch on you • Brief • How does Oracle fit inside your business • Mutual Customer Reference Inventory • Have 3 • Write them up or forward already existing ones • Work with us to package • Pick a Story • Co-branded content • Bi-lined articles 62
63
f5afaaaaf064c11c26d4f33686da98eb.ppt