Business Intelligence & AnalyticsTodays ObjectivesSlide 3Definition: Business IntelligenceQuizPervasive Information Access Through a Unified BI FoundationWhat do we do with it?Ad-hoc Query CapabilityBI Applications Multi-Source Analytics with Single ArchitectureSlide 12Change the Economics of BISlide 14Slide 15Slide 16Slide 17Oracle BI Applications ArchitectureETL OverviewData Warehouse Application Console (DAC)Physical Data Model OverviewSelected Key Entities of Business Analytics WarehouseServer Repository OverviewTools and Web Catalog OverviewSlide 27Slide 28Slide 29Slide 30Slide 31Today’s ObjectivesSlide 33Business Intelligence & Analytics Business Intelligence & AnalyticsE. Tom OwensDirector IT Wah ChangE. Tom OwensDirector IT Wah ChangTodays ObjectivesTodays ObjectivesKnow definition of Business Intelligence (BI)Know the difference between BI and Data WarehousingHow is BI derived - structureExamples for understandingEnterprise Performance Management ToolsQ&AKnow definition of Business Intelligence (BI)Know the difference between BI and Data WarehousingHow is BI derived - structureExamples for understandingEnterprise Performance Management ToolsQ&A<Insert Picture Here>Definition : business IntelligenceDefinition: Business IntelligenceDefinition: Business IntelligenceA broad category of applications and technologies for gathering, providing access to, and analyzing data for the purpose of helping enterprise users make better decisions and reports. The term implies you have a complete understanding of your business. We must have a strong knowledge about all factors of your company including customers, competition, business partners, internal operations, and the economic environment to make effective and good quality business decisions. Business Intelligence allows you to make these kinds of decisions. The term BI was used as early as 1996 When Gartner Group said:By 2000, Information Democracy will emerge in forward-thinking enterprises, with Business Intelligence information and applications available broadly to employees, consultants, customers, suppliers and the public.A broad category of applications and technologies for gathering, providing access to, and analyzing data for the purpose of helping enterprise users make better decisions and reports. The term implies you have a complete understanding of your business. We must have a strong knowledge about all factors of your company including customers, competition, business partners, internal operations, and the economic environment to make effective and good quality business decisions. Business Intelligence allows you to make these kinds of decisions. The term BI was used as early as 1996 When Gartner Group said:By 2000, Information Democracy will emerge in forward-thinking enterprises, with Business Intelligence information and applications available broadly to employees, consultants, customers, suppliers and the public.QuizQuizQuestion:What is business intelligence?Question:What is business intelligence?SearchPervasive Information Access Through a Unified BI Foundation Pervasive Information Access Through a Unified BI Foundation Ad-hoc AnalysisInteractive DashboardsProactiveDetectionand AlertsMS Office& OutlookIntegrationReporting & PublishingDisconnected& MobileAnalyticsOLTP & ODSSystemsData WarehouseData MartSAP, OraclePeopleSoft, Siebel,Custom AppsFilesExcelXMLBusinessProcessMultidimensional Calculation and Integration Engine Integrated Security, User Management, PersonalizationIntelligent Request Generation and Optimized Data Access ServicesEssbaseCommon Enterprise Information ModelDesktopGadgetsEnterprise Performance Management SystemBusiness Intelligence FoundationWhat do we do with it?What do we do with it?OracleKerberosiPlanetMSFT ADNovellCustom Others ..Oracle Data Integrator (Sunopsis)Oracle Warehouse BuilderInformaticaAscentialOthers ..Any JSR 168 PortalOracle Data Mining, SPSS, SASOracle EBS, Siebel, SAP, PeopleSoft, JD Edwards ..Excel, Outlook,Lotus Notes ..Oracle RDBMSOracle OLAP OptionMicrosoft SQL Server & Analysis ServicesIBM DB2TeradataEssbaseSAP BWXML, Excel, TextPortals Data Mining Applications Desktop ToolsSecurity Data Access Data IntegrationAd-hoc Query CapabilityAd-hoc Query CapabilityComprehensive subject areas available for Ad-hoc analysisNew Calculated FieldsAvailable within Market Leading BI ToolsetEasy to use Charting toolFormattingWidgetsHighlightingMulti-languageComprehensive subject areas available for Ad-hoc analysisNew Calculated FieldsAvailable within Market Leading BI ToolsetEasy to use Charting toolFormattingWidgetsHighlightingMulti-languageBI ApplicationsMulti-Source Analytics with Single ArchitectureBI ApplicationsMulti-Source Analytics with Single ArchitectureTravel& TransTravel& TransAutoAutoComms& MediaComms& MediaComplexMfgComplexMfgConsumerSectorConsumerSectorEnergyEnergyFinancialServicesFinancialServicesHighTechHighTechInsurance& HealthInsurance& HealthLifeSciencesLifeSciencesPublic SectorPublic SectorOther Operational & Analytic SourcesBI Suite Enterprise EditionPrebuilt adapters:Sales MarketingOrder Management& FulfillmentSupply ChainFinancialsHumanResourcesPipelineAnalysisTriangulatedForecastingSales Team EffectivenessUp-sell / Cross-sellCycle TimeAnalysisLead ConversionEmployee ProductivityCompensation AnalysisHR Compliance ReportingWorkforceProfileTurnoverTrendsReturn on Human CapitalA/R & A/PAnalysisGL / BalanceSheet Analysis Customer & ProductProfitabilityP&L AnalysisExpenseManagementCash FlowAnalysisSupplier PerformanceSpend AnalysisProcurement Cycle TimesInventory AvailabilityEmployeeExpensesBOM AnalysisOrderLinearityOrdersvs. AvailableInventoryCycle TimeAnalysisBacklogAnalysisFulfillmentStatusCustomerReceivablesCampaign ScorecardResponse RatesProduct PropensityLoyalty andAttritionMarket Basket AnalysisCampaign ROIService &Contact CenterChurn PropensityCustomer SatisfactionResolutionRatesService RepEffectivenessService CostAnalysisServiceTrends<Insert Picture Here>Value of Pre-built BI ApplicationsBuild from Scratchwith Traditional 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& DashboardsBack-end ETL andMappingDW DesignDefine
View Full Document