1 / 42

Oracle Project Analytics 8:30 – 9:30 Oracle Report Manager 9:30 – 10:00

Oracle Project Analytics 8:30 – 9:30 Oracle Report Manager 9:30 – 10:00. Brad Holzer Larry Enright.

Albert_Lan
Download Presentation

Oracle Project Analytics 8:30 – 9:30 Oracle Report Manager 9:30 – 10:00

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. Oracle Project Analytics 8:30 – 9:30Oracle Report Manager 9:30 – 10:00 Brad Holzer Larry Enright

  2. The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle. © 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

  3. Oracle Project Analytics Brad Holzer Senior Sales Consultant

  4. Program Agenda <Insert Picture Here> • Oracle EPM & BI Overview • Value of Prebuilt Oracle BI Applications • Project Analytics Demonstration • Dashboards & Reports • Ad Hoc Reporting • Q&A © 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

  5. Who’d you vote for? ? ? © 2006 Oracle Corporation – Proprietary and Confidential

  6. Oracle BI ApplicationsComplete, Pre-built, Best Practice Analytics ConsumerSector Insurance & Health Complex Mfg FinancialServices HighTech LifeSciences Public Sector Travel& Trans Comms& Media Auto Energy Projects Sales Service &Contact Center Funding &Agreements BudgetsAnalysis Revenue Analysis Billing Analysis Cost Analysis ProfitabilityAnalysis ServiceEffectiveness Customer Satisfaction ResolutionRates Service RepEfficiency Service Cost Churn & Service Trends Marketing Procurement & Spend Supply Chain & Order Management Financials HumanResources Direct / Indirect Spend Buyer Productivity Off Contract Purchases Supplier Performance Purchase Cycle Time Employee Expenses Revenue andBacklog Inventory FulfillmentStatus CustomerStatus Order Cycle Time BOM Analysis PipelineAnalysis ForecastAccuracy Sales Team Effectiveness Up-sell/ Cross-sell Cycle Times Lead Conversion Campaign Effectiveness CustomerInsight Product Propensity Loyalty &Attrition Market Basket Analysis Campaign ROI General Ledger Accounts Receivable Accounts Payable Cash Flow Profitability Expense Management Employee Productivity Compensation Compliance Reporting WorkforceProfile RetentionAnalysis Return on Human Capital and Other Operational & Analytic Sources Source adapters: Oracle BI Suite Enterprise Edition Plus © 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

  7. An enterprise performance management (EPM) system brings the management processes under a single umbrella, connecting financial and operational decisions and ctivities with transactional systems to form a comprehensive management picture. • EPM comprises all performance-related strategic, financial, and operational management processes an organization undertakes. • EPM consists of all methodologies, systems, metric • and structures to support the management processes. Only an EPM system, which includes operational BI applications as well as financial performance management applications, can create that critical link between the operational systems and management systems that enables insight to action. © 2006 Oracle Corporation – Proprietary and Confidential

  8. EPM WORKSPACE Web Search Alerts Mobile Desktop Office Performance Management Applications BI Applications BI Applications Business Intelligence Foundation Fusion Middleware OLAP Data Warehouse Data Mart Business Process OLTP & ODS Systems SAP, Oracle, Siebel, PeopleSoft, Custom Excel XML Enterprise Performance Management System

  9. Enterprise Performance Management SystemMarket Leading Applications EPM Workspace EPM Workspace PERFORMANCE MANAGEMENT APPLICATIONS BI Applications Financial Reporting & Compliance Strategy Management Business Planning Profitability Management Business Intelligence Foundation Fusion Middleware OLAP Data Warehouse Data Mart Business Process Excel XML OLTP & ODS Systems SAP, Oracle, Siebel, PeopleSoft, Custom

  10. Comprehensive BI Applications EPM Workspace Performance Management Applications Business Intelligence Foundation Fusion Middleware BI APPLICATIONS Finance Sales Contact Center Procurement & Spend Service Marketing HR Supply Chain & Order Mgmt OLAP Data Warehouse Data Mart Business Process OLTP & ODS Systems SAP, Oracle, Siebel, PeopleSoft, Custom Excel XML © 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

  11. EPM Workspace Performance Management Applications BUSINESS INTELLIGENCE FOUNDATION Common Enterprise Information Model BI Server Predictive Analytics Essbase Fusion Middleware OLAP Data Warehouse Data Mart Business Process OLTP & ODS Systems SAP, Oracle, Siebel, PeopleSoft, Custom Excel XML Enterprise Performance Management SystemMarket Leading EPM & Comprehensive Analytic Applications BI APPLICATIONS PERFORMANCE MANAGEMENT APPLICATIONS Financial Reporting & Compliance Strategy Management Business Planning Profitability Management Order Mgmt. Supply Chain Service HR Finance Sales Mrktg Projects

  12. EPM Workspace Performance Management Applications BI Applications Business Intelligence Foundation FUSION MIDDLEWARE Data Quality Data Integration Business Process Management Identity Management Content Management MDM SOA OLAP Data Warehouse Data Mart Business Process OLTP & ODS Systems SAP, Oracle, Siebel, PeopleSoft, Custom Excel XML Enterprise Performance Management SystemLeverages Fusion Middleware

  13. Comprehensive BI Applications EPM Workspace Performance Management Applications Business Intelligence Foundation Fusion Middleware BI APPLICATIONS Finance Sales Contact Center Procurement & Spend Service Marketing HR Supply Chain & Order Mgmt OLAP Data Warehouse Data Mart Business Process OLTP & ODS Systems SAP, Oracle, Siebel, PeopleSoft, Custom Excel XML © 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

  14. Proactive Detection and Alerts Actionable Dashboards Reporting & Publishing Ad-hoc Analysis Disconnected Analytics MS Office Plug-in WebServices Oracle BI Suite EE Plus Oracle Project AnalyticsSingle- and multi-source Analytic Apps Built on BI Suite EE Sales Service &Contact Center Marketing Supply Chain & Order Management Procurement and Spend Financials HumanResources Projects Oracle BI Applications Legacy Project Management, Budget Management, and Accounting Systems DW Schema Packaged ETL Maps UniversalAdapters © 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

  15. Pre-mapped metadata, including embedded best practice calculations, and over 500 pre-built metrics for the project organization. 3 • Presentation Layer • Logical Business Mode • Physical Sources Pre-built ETL to extract data from a large number of operational tables and load it into the DW, sourced from CRM, ERP, and other sources. A “best practice” library of over 100 pre-built intelligence dashboards, reports and alerts for project managers, program managers, project accountants, and executives 2 4 Oracle Project Analytics Pre-built warehouse with 7 star-schemas designed for analysis and reporting on Project funding, agreements, budgets, costing, billings, revenue, performance and profitability data. 1 © 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

  16. Oracle BI ApplicationsComplete, Pre-built, Best Practice Analytics ConsumerSector Insurance & Health Complex Mfg FinancialServices HighTech LifeSciences Public Sector Travel& Trans Comms& Media Auto Energy Projects Sales Service &Contact Center Funding &Agreements BudgetsAnalysis Revenue Analysis Billing Analysis Cost Analysis ProfitabilityAnalysis ServiceEffectiveness Customer Satisfaction ResolutionRates Service RepEfficiency Service Cost Churn & Service Trends Marketing Procurement & Spend Supply Chain & Order Management Financials HumanResources Direct / Indirect Spend Buyer Productivity Off Contract Purchases Supplier Performance Purchase Cycle Time Employee Expenses Revenue andBacklog Inventory FulfillmentStatus CustomerStatus Order Cycle Time BOM Analysis PipelineAnalysis ForecastAccuracy Sales Team Effectiveness Up-sell/ Cross-sell Cycle Times Lead Conversion Campaign Effectiveness CustomerInsight Product Propensity Loyalty &Attrition Market Basket Analysis Campaign ROI General Ledger Accounts Receivable Accounts Payable Cash Flow Profitability Expense Management Employee Productivity Compensation Compliance Reporting WorkforceProfile RetentionAnalysis Return on Human Capital and Other Operational & Analytic Sources Source adapters: Oracle BI Suite Enterprise Edition Plus © 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

  17. Oracle BI ApplicationsComplete, Pre-built, Best Practice Analytics ConsumerSector Insurance & Health Complex Mfg FinancialServices HighTech LifeSciences Public Sector Travel& Trans Comms& Media Auto Energy Projects Sales Service &Contact Center Funding &Agreements BudgetsAnalysis Revenue Analysis Billing Analysis Cost Analysis ProfitabilityAnalysis ServiceEffectiveness Customer Satisfaction ResolutionRates Service RepEfficiency Service Cost Churn & Service Trends Marketing Procurement & Spend Supply Chain & Order Management Financials HumanResources Direct / Indirect Spend Buyer Productivity Off Contract Purchases Supplier Performance Purchase Cycle Time Employee Expenses Revenue andBacklog Inventory FulfillmentStatus CustomerStatus Order Cycle Time BOM Analysis Campaign Effectiveness CustomerInsight Product Propensity Loyalty &Attrition Market Basket Analysis Campaign ROI General Ledger Accounts Receivable Accounts Payable Cash Flow Profitability Expense Management Employee Productivity Compensation Compliance Reporting WorkforceProfile RetentionAnalysis Return on Human Capital and Other Operational & Analytic Sources Source adapters: Oracle BI Suite Enterprise Edition Plus © 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

  18. Oracle Project Analytics: Business NeedDrive Intelligent Decisions With The Insight • Improve Cash Flow - For a $200M project revenue based company, reducing receivables one day > $500k in cash flow • Accelerate Deliveries - 10% acceleration of a 16 mo. project with 40% margin and est. rev of $20M = $1M Cash Flow • Lower operational costs - Organization can save up to 30-60% in time dedicated to reporting/ communicating status • Improve Margins by increasing visibility into change impact • Reduce project & financial risk by drilling down and identifying underlying issues © 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

  19. Dashboards Dashboard Pages Roles Flexible Dashboard Parameters Integration with Financial Analytics Charts/Graphs Reports based on Multiple Sources Integration with Procurement and Spend Analytics © 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

  20. Decision Workflows – Actionable Analytics Business Objectives/ Issues Improve Project Performance Is Financial performance on target? NOT REALLY Drill toDetail Are Project costs under control? NO Gain Insights Why? What is the cost variance? Why? What is source of variance? Who? Which resources is causing cost variances TakeAction Target effortsto reduce theproject costs © 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION "This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

  21. <Insert Picture Here> Project Analytics Demonstration © 2006 Oracle Corporation – Proprietary and Confidential

  22. Report Manager Overview Larry Enright – Applications Sales Consultant

  23. Safe Harbor Statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle. © 2006 Oracle Corporation – Proprietary and Confidential

  24. First let me introduce myself Brittni Tammy Dean Derek Larry © 2006 Oracle Corporation – Proprietary and Confidential

  25. Before Today Who is Larry Enright 1980 College Graduate 1992 Oracle Applications 1995 Applications Consultant 2005 Joined Oracle © 2006 Oracle Corporation – Proprietary and Confidential

  26. Before Today Industry Experience Oil & Gas, Manufacturing, Mining, Distribution, Retail, Financial, Software What else about Larry Enright Oracle Applications Customer Over 10 Implementations (Character / Client Server Web Based) Customers Revenue Over Billion to Under 50 Million Before © 2006 Oracle Corporation – Proprietary and Confidential

  27. Almost 30 year of IT experience © 2006 Oracle Corporation – Proprietary and Confidential

  28. 16 of those 30 years are with Oracle and Oracle Applications © 2006 Oracle Corporation – Proprietary and Confidential

  29. Oracle isn’t the only team that I’m responsible for © 2006 Oracle Corporation – Proprietary and Confidential

  30. Agenda <Insert Picture Here> • Report Manager Overview • Repository Management • Submission Flows • User to Value Security • FSG Template Editor • Profile Options • Demonstration • Questions and Answers © 2006 Oracle Corporation – Proprietary and Confidential

  31. Report Manager OverviewRepository Management • Capabilities • View Reports • Create SSWA Menus • Update Publishing Options • Move Folders/Reports • Add Folders • Archive/Delete Reports/Folders © 2006 Oracle Corporation – Proprietary and Confidential

  32. Report ManagerOverviewFSG Submission • Capabilities • Submit Defined FSG Reports and publish to Report Manager Repository • Can burst report through Content Set page expansion on a segment © 2006 Oracle Corporation – Proprietary and Confidential

  33. Report Manager OverviewAd Hoc FSG Submission • Capabilities • Submit Ad Hoc FSG Report by selecting existing FSG components and publishing into the Repository © 2006 Oracle Corporation – Proprietary and Confidential

  34. Report Manager OverviewStandard Report Submission (SRS) • Capabilities • Submit SRS Reports (XML Output) and publish to Repository • Provides LOV for Report Parameters as defined in Applications © 2006 Oracle Corporation – Proprietary and Confidential

  35. Report ManagerOverviewFile Upload • Capabilities • Upload 3rd Party Files into the Repository © 2006 Oracle Corporation – Proprietary and Confidential

  36. Report Manager OverviewReport Set/Request Set Publishing • Capabilities • Publish previously submitted Report Set or Request Set into the Repository • Can save a template of publishing options to apply to a set whenever it is published © 2006 Oracle Corporation – Proprietary and Confidential

  37. Report Manager OverviewUser to Value Security • Capabilities • Security system unique to the Report Manager application • Controls what expanded values a user can view © 2006 Oracle Corporation – Proprietary and Confidential

  38. Report Manager OverviewFSG Template Editor • Capabilities • Create custom Templates for FSG Reports • A template is automatically generated generated based on the FSG Report Definition • Provides interface to provide layout and control fonts, colours, etc. © 2006 Oracle Corporation – Proprietary and Confidential

  39. Report ManagerOverviewProfile Options © 2006 Oracle Corporation – Proprietary and Confidential

  40. <Insert Picture Here> Report Manager Demonstration © 2006 Oracle Corporation – Proprietary and Confidential

  41. For More Information • Report Manager About Document • Metalink Note 378338.1 • Report Manager Users Guide © 2006 Oracle Corporation – Proprietary and Confidential

  42. <Insert Picture Here> Questions & Answers © 2006 Oracle Corporation – Proprietary and Confidential

More Related