Oracle商務(wù)智能精華介紹ppt課件

1、.Business Intelligence ApplicationsImportant InformationTHIS DOCUMENT IS FOR INFORMATIONAL PURPOSES ONLY AND IS NOT AN OFFER TO BUY OR THE SOLICITATION OF AN OFFER TO SELL ANY SECURITIES. THE SOLICITATION AND THE OFFER TO BUY SHARES OF HYPERIONS COMMON STOCK WILL ONLY BE MADE PURSUANT TO AN OFFER TO

2、 PURCHASE AND RELATED MATERIALS THAT ORACLE INTENDS TO FILE WITH THE SECURITIES AND EXCHANGE COMMISSION. ONCE FILED, HYPERION STOCKHOLDERS SHOULD READ THESE MATERIALS CAREFULLY PRIOR TO MAKING ANY DECISIONS WITH RESPECT TO THE OFFER BECAUSE THEY CONTAIN IMPORTANT INFORMATION, INCLUDING THE TERMS AND

3、 CONDITIONS OF THE OFFER. ONCE FILED, HYPERION STOCKHOLDERS WILL BE ABLE TO OBTAIN THE OFFER TO PURCHASE AND RELATED MATERIALS WITH RESPECT TO THE OFFER FREEOF CHARGE AT THE SECS WEBSITE AT SEC.GOV, FROM THE INFORMATION AGENT NAMED IN THE TENDER OFFER MATERIALS OR FROM ORACLE. Cautionary Statement R

4、egarding Forward-Looking StatementsThis document contains certain forward-looking statements about Oracle and Hyperion. When used in this document, the words “anticipates, “may, “can, “believes, “expects, “projects, “intends, “l(fā)ikely, similar expressions and any other statements that are not histori

5、cal facts, in each case as they relate to Oracle and Hyperion, the management of either such company or the transaction are intended to identify those assertions as forward-looking statements. In making any such statements, the person making them believes that its expectations are based on reasonabl

6、e assumptions. However, any such statement may be influenced by factors that could cause actual outcomes and results to be materially different from those projected or anticipated. These forward-looking statements are subject to numerous risks and uncertainties. There are various important factors t

7、hat could cause actual results to differ materially from those in any such forward-looking statements, many of which are beyond the control of Oracle and Hyperion, including: the impact of general economic conditions in regions in which either such company currently does business, industry condition

8、s, including competition, fluctuations in exchange rates and currency values, capital expenditure requirements, legislative or regulatory requirements, changes in the tax laws, interest rates and access to capital markets. The actual results or performance by Oracle or Hyperion could differ material

9、ly from those expressed in, or implied by, these forward-looking statements. Accordingly, no assurances can be given that any of the events anticipated by the forward-looking statements will transpire or occur, or if any of them do so, what impact they will have on the results of operations or finan

10、cial condition of Oracle or Hyperion. . 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 up

11、on in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracles products remains at the sole discretion of Oracle.BI and Performance Management Consistently the Top IT and Business Priorities Worldwide“ the most important technology in 20

12、07 is Business IntelligenceFinances Top Area of ImportanceSources: CIO Insight, “The Future of I.T.: Whats on Tap for 2007 and Beyond, January 16, 2007; IBM Business Consulting Services, “The Global CFO Study 2005.Business Intelligence Drives Increased Effectiveness in every Business FunctionSales A

13、nalyticsMarketing AnalyticsService & Contact Center AnalyticsConvert service calls into sales through enhanced cross-sellingImprove pipeline visibility and forecast accuracyReal-time visibility into campaign execution, results, and ROIFinancial AnalyticsHR / Workforce AnalyticsSupply Chain Analytics

14、Optimize supplier sourcing, supplier performance, and inventory levelsReal-time view of financial condition and drivers of cost and profitabilityUnderstand what drives employee productivity and org. performance.Our MissionMaking our software a source of continual competitive advantage for our custom

15、ersBetter InformationBetter Results.Our Approach to BI ApplicationsPre-Build Applications to reduce complexity and TCO for our customersExtend Applications with Best in Class TechnologyIntegrate BI Applications with ERP and CRM123.Pre-Built BI Applications from Oracle Reduce ComplexityDELIVER BETTER

16、 INSIGHT TO CUSTOMERS MULTI-APPLICATION ENVIRONMENTSDASHBOARDS“Visible“PLUMBING“Under the SurfaceMappings to multiple applications and data transformation all take expertise and time.Oracles Product StrategyIntegrated Business Intelligence DatabaseBusiness Intelligence & Data Mining Functions Integr

17、ated in DatabaseIntegrated Business Intelligence ToolsBest-of-Breed, Next Generation Business Intelligence Technology PlatformIntegrated Analytic ApplicationsEnterprise Wide, Industry Specific Analytic and Corporate Performance Management ApplicationsExploits Any Information Technology Environment.T

18、o:From:Product Strategy DriversPervasive useAnalystsReal-time, predictive dataHistorical dataUnified infrastructure and prebuilt analytic solutionsAnalytic toolsInsight-driven business process optimizationReporting resultsUnified, enterprise viewFragmented viewEnterprise Performance Management Syste

19、mPlanning silos with limited BI.Analytic Applications FamiliesAll on Common Oracle BI EE TechnologyOther Operational & Analytic SourcesOracle BI Suite EEAd-hoc AnalysisProactiveDetectionand AlertsMS OfficePlug-inReporting & PublishingInteractive DashboardsDisconnectedAnalyticsWebServicesFusion Intel

20、ligence for EBSFusion Intelligence for PeopleSoft EnterpriseOracle BI ApplicationsEnhancement/Extension of DBIExtension of EPM, Replacement for BO,Cognos,MSTRSingle source, Multi-sourceFor EBS, PSFT, SEBL, SAP, OtherNewNewNewVersion.Oracle BI Suite Enterprise EditionUnified Business Intelligence Inf

21、rastructureAd-hoc AnalysisProactiveDetectionand AlertsMS OfficePlug-inReporting & PublishingInteractive DashboardsDisconnectedAnalyticsOracleBI ServerOLTP & ODSSystemsData WarehouseData MartSAP, OraclePeopleSoft, Siebel,Custom AppsFilesExcelXMLBusinessProcessMultidimensional Calculation and Integrat

22、ion Engine Intelligent Caching ServicesEnterprise Business Model and Abstraction LayerIntelligent Request Generation and Optimized Data Access ServicesWebServices.Oracle BI ApplicationsSingle- and multi-source Analytic Apps Built on BI Suite EEOracle BI Suite EEAd-hoc AnalysisProactiveDetectionand A

23、lertsMS OfficePlug-inReporting & PublishingInteractive DashboardsDisconnectedAnalyticsWebServicesOracle BI ApplicationsSalesService &Contact CenterMarketingOrder Management& FulfillmentSupply ChainFinancialsHumanResourcesPackagedETL MapsUniversalAdaptersIVR, ACD, CTIHyperionMS ExcelOther Data Source

24、sBAW Schema.Oracle BI ApplicationsMulti-Source Analytics with Single ArchitectureTravel& TransAutoComms& MediaComplexMfgConsumerSectorEnergyFinancialServicesHighTechInsurance& HealthLifeSciencesPublic SectorOther Operational & Analytic SourcesOracle BI Suite Enterprise EditionPrebuilt adapters:Sales

25、Service &Contact CenterMarketingOrder Management& FulfillmentSupply ChainFinancialsHumanResourcesPipelineAnalysisTriangulatedForecastingSales Team EffectivenessUp-sell / Cross-sellCycle TimeAnalysisLead ConversionEmployee ProductivityCompensation AnalysisHR Compliance ReportingWorkforceProfileTurnov

26、erTrendsReturn on Human CapitalA/R & A/PAnalysisGL / BalanceSheet Analysis Customer & ProductProfitabilityP&L AnalysisExpenseManagementCash FlowAnalysisSupplier PerformanceSpend AnalysisProcurement Cycle TimesInventory AvailabilityEmployeeExpensesBOM AnalysisOrderLinearityOrdersvs. AvailableInventor

27、yCycle TimeAnalysisBacklogAnalysisFulfillmentStatusCustomerReceivablesCampaign ScorecardResponse RatesProduct PropensityLoyalty andAttritionMarket Basket AnalysisCampaign ROIChurn PropensityCustomer SatisfactionResolutionRatesService RepEffectivenessService CostAnalysisServiceTrends.Oracle BI Applic

28、ationsMulti-Source Analytics with Single ArchitectureTravel& TransAutoComms& MediaComplexMfgConsumerSectorEnergyFinancialServicesHighTechInsurance& HealthLifeSciencesPublic SectorOther Operational & Analytic SourcesOracle BI Suite Enterprise EditionPrebuilt adapters:SalesMarketingOrder Management& F

29、ulfillmentSupply ChainHumanResourcesPipelineAnalysisTriangulatedForecastingSales Team EffectivenessUp-sell / Cross-sellCycle TimeAnalysisLead ConversionEmployee ProductivityCompensation AnalysisHR Compliance ReportingWorkforceProfileTurnoverTrendsReturn on Human CapitalSupplier PerformanceSpend Anal

30、ysisProcurement Cycle TimesInventory AvailabilityEmployeeExpensesBOM AnalysisOrderLinearityOrdersvs. AvailableInventoryCycle TimeAnalysisBacklogAnalysisFulfillmentStatusCustomerReceivablesCampaign ScorecardResponse RatesProduct PropensityLoyalty andAttritionMarket Basket AnalysisCampaign ROIService

31、&Contact CenterChurn PropensityCustomer SatisfactionResolutionRatesService RepEffectivenessService CostAnalysisServiceTrendsFinancialsA/R & A/PAnalysisGL / BalanceSheet Analysis Customer & ProductProfitabilityP&L AnalysisExpenseManagementCash FlowAnalysis.Pre-mapped metadata, including embedded best

32、 practice calculations and metrics for Financial, Executives and other Business Users.Presentation LayerLogical Business ModelPhysical Sources3Pre-built ETL to extract data from over 3,000 operational tables and load it into the DW, sourced from SAP, PSFT, Oracle EBS and other sources.2A “best pract

33、ice library of over 360 pre-built metrics, 30 Intelligent Dashboards, 200+ Reports and several alerts for CFO, Finance Controller, Financial Analyst, AR/AP Managers and Executives4Pre-built warehouse with 16 star-schemas designed for analysis and reporting on Financial Analytics1Oracle Financial Ana

34、lytics Product Components.Role Based DashboardsAnalytic WorkflowGuided NavigationSecurity / VisibilityAlerts & Proactive DeliveryLogical to Physical Abstraction LayerCalculations and Metrics DefinitionVisibility & PersonalizationDynamic SQL GenerationHighly ParallelMultistage and CustomizableDeploym

35、ent ModularityAbstracted Data ModelConformed DimensionsHeterogeneous Database supportDatabase specific indexingOracle BI Applications ArchitectureAdministrationMetadataOracle BI Presentation ServicesDashboards by RoleReports, Analysis / Analytic WorkflowsMetrics / KPIsLogical Model / Subject AreasPh

36、ysical MapOracle BI ServerDirect Access to Source DataData Warehouse /Data ModelETLLoad ProcessStaging AreaExtraction ProcessDACFederated Data SourcesSiebelOracleSAP R/3PSFTEDWOther.Oracle BI Apps: Selected Key EntitiesUnified multi-source data modelConformed DimensionsCustomerProductsSuppliersCost

37、CentersProfit CentersInternal OrganizationsCustomer LocationsCustomer ContactsGL AccountsEmployeeSales RepsService RepsPartnersCampaignOffersSalesOpportunitiesQuotesPipelineOrder ManagementSales Order LinesSales Schedule LinesBookingsPick LinesBillingsBacklogsMarketingCampaignsResponsesMarketing Cos

38、tsSupply ChainPurchase Order LinesPurchase Requisition LinesPurchase Order ReceiptsInventory BalanceInventory TransactionsFinanceReceivables Payables General LedgerCOGSCall CenterACD EventsRep ActivitiesContact-Rep SnapshotTargets and BenchmarkIVR Navigation HistoryServiceService RequestsActivitiesA

39、greementsWorkforceCompensationEmployee ProfileEmployee EventsPharmaPrescriptionsSyndicated Market DataFinancialsFinancial AssetsInsurance ClaimsPublic SectorBenefitsCasesIncidentsLeadsModular DW Data Model includes:350 Fact Tables 550 Dimension Tables5,200 prebuilt Metrics(2,500+ are derived metrics

40、)15,000 Data Elements.Example: Analytic WorkflowsBusiness Objectives / IssuesGainInsightsTake ActionTarget collection efforts to reduce overdue balancesDrill toOverdue Invoice DetailWho are the Customersand Collectors?How long is the underlying Overdue Balance pending?Is Overdue Balancestrending up?

41、Is DSO on target?Maximize Cash FlowDrill toDue Balances by RegionWhat is the aging ofDue Balances?Are Payment Termsin compliance?Is DPO on target?Business Function: ReceivablesRole: Director, Credits & CollectionsObjectives:1) Maximize Cash Flow2) Control Risk of Receivables Portfolio.Example: Analy

42、tic WorkflowsBusiness Objectives / IssuesGainInsightsTake ActionTarget collection efforts to reduce overdue balancesDrill toOverdue Invoice DetailWho are the Customers?How long is the underlying Overdue Balance pending?Is Overdue Balancestrending up?Is DSO on target?Maximize Cash FlowDrill to Detail

43、.D E M O N S T R A T I O NOracle BI Applications.Verify Supplier Payable StatusPCS Computing: Analytics in ActionIdentify Problem w/ Revenue1Locate Substitute ProductSource Additional Parts43Execute Multichannel Sales CampaignProblem with Invoice & Backlog210SalesFinanceMarketingContactCenterSupplyC

44、hain5Identify Overstocked Laptops6Create Campaign for Overstock7Ensure Campaign Readiness8Monitor Contact Center Performance11Address Agent Retention issue9Workforce.Seamless Analytics Across Multiple Data SourcesSalesFinanceMarketingContactCenterSupplyChainWorkforce.Build from Scratchwith Tradition

45、al BI ToolsOracle BI ApplicationsPrebuilt Business Adapters for Oracle, PeopleSoft, Siebel, SAP, othersPrebuilt DW design, adapts to your EDWRole-based dashboards and thousands of pre-defined metricsEasy to use, easy to adaptWeeks or MonthsBack-end ETL andMappingDW DesignDefine Metrics& DashboardsBa

46、ck-end ETL andMappingDW DesignDefine Metrics& DashboardsTraining / Roll-outTraining / RolloutMonths or YearsOracle BI Applicationssolutions approach:Faster time to valueLower TCOAssured business valueSource: Patricia Seybold Research, Gartner, Merrill Lynch, Oracle AnalysisSpeeds Time To Value and L

47、owers TCO.Deployed to 800 users in under 90 daysAnalytics for sales-oriented contact centerLive in 120 daysSales Analytics4 months from decision to live for 1,200 usersPharma AnalyticsLive in 100 days, 6,500 usersSales and Marketing Analytics“I can vouch that it can be deployed as rapidly as they cl

48、aim.It is a product that really delivers.Deployed to 3,000+ users in 3 monthsSales AnalyticsWhat Customers Are AchievingWith Oracle BI Applications.New BI Applications 7.9 Release.7.9 Release ThemesUnified multi-source data modelEnhanced user experienceData Warehouse Administration ConsoleExpanded d

49、eployment optionsSupport Oracle EBS v11 v11i9 and v11i10Support DB2 V8 on z/OS as both source and target databaseSupport Teradata V2R6 as target databaseFull localizationTranslation to 15 languages.Tight Integration with ApplicationsShared security with Oracle EBS and Siebel CRMEBS Security Integrat

50、ionFND_User securityShared responsibilities between Oracle EBS and Oracle BI AppsOracle SSOSiebel CRM Security IntegrationSiebel native security Shared responsibilities between Siebel CRM and Oracle BI AppsHot-Pluggable SecurityPre-built security roles in BI ApplicationsUsers/roles synchronized with

51、 selected security environment.Tight Integration with ApplicationsAction Links navigate from analytical to operationalAction LinksDirect navigation from analytical report to transactional detail while maintaining contextTake action immediately without navigating to a different screenOracle EBS Integ

52、rationSiebel CRM Integration.Analytic WorkflowsDirected analysis helps inexpert usersGuided NavigationEnables users to quickly navigate a standard path of analytical discovery specific to their function and roleEnhances usability and lowers learning curve for new usersConditional NavigationAppears o

53、nly when conditions are met and alerts users to potential out of ordinary conditions that require attentionGuides users to next logical step of analytical discovery.Data Warehouse Administration Console (DAC)Strong Competitive DifferentiatorFor warehouse developers and ETL Administrator “ETL orchest

54、ration toolApplication ConfigurationExecution & RecoveryMonitoringAllows:Pin-point deploymentLoad balancingReduced load windowsFine-grained failure recovery.Portfolio of Analytic Applications.Analytic Applications FamiliesAll on Common Oracle BI EE TechnologyOther Operational & Analytic SourcesOracl

55、e BI Suite EEAd-hoc AnalysisProactiveDetectionand AlertsMS OfficePlug-inReporting & PublishingInteractive DashboardsDisconnectedAnalyticsWebServicesFusion Intelligence for EBSFusion Intelligence for PeopleSoft EnterpriseOracle BI ApplicationsEnhancement/Extension of DBIExtension of EPM, Replacement

56、for BO,Cognos,MSTRSingle source, Multi-sourceFor EBS, PSFT, SEBL, SAP, OtherNewNewNewVersion.Daily Business Intelligence Fully Integrated Business Intelligence for the E-Business SuiteSuite of pre-built, role-based BI Applications Easy-to-use, interactive, and extensible dashboardsSeamless integrati

57、on with E-Business SuiteSingle source of truth (no upload to data warehouse)Seamless drilldown to transaction tablesEasy to deployNo separate ETL tool to learn and maintainVery low TCO.Oracle Daily Business Intelligence (DBI)Easy-To-Use Dashboards Within E-Business SuiteRole Based DashboardsLeverage

58、s EBS Infrastructure and Materialized ViewsNo Data Movement RequiredDrill Directly to Transactions from SummariesImplements in DaysFastest Path to Information from EBSPart of EBS “Rapid InstallNo Training Required.Drill Through: Summary to Actual Transactions Summary & TrendsDetail InformationTransa

59、ctions.11i.9 (DBI v6) 11i.10 (DBI v7+)12 (DBI v8)IntelligenceReports332143775431382760362918DashboardsKPIs EBS R12: Continued Delivery of Pre-built Apps VP of HRLine ManagementHR ManagerLine ManagerHR Analyst Benefits ManagerBenefits AnalystLearning ManagerHR SpecialistLearning CoordinatorHR Help De

60、sk ManagerCompensation ManagerCompensation AnalystBenefits ManagerBenefits AnalystHR AnalystCFOControllerTreasurerAP managerAR ManagerAssets ManagerTax ManagerCost ManagerProjects ManagerRevenue ManagerCollections ManagerPayroll ManagerAccountantCompliance ClerkAP ClerkAR ClerkFinancials AnalystSupp