DOC PREVIEW
OSU BA 471 - Business Intelligence & Analytics

This preview shows page 1-2-3-27-28-29 out of 29 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 29 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 29 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 29 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 29 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 29 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 29 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 29 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

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 ObjectivesKnow definition of Business Intelligence (BI)Know the difference between BI and Data WarehousingHow is BI derived - structureExamples for understandingEnterprise Performance Management ToolsQ&AKnow definition of Business Intelligence (BI)Know the difference between BI and Data WarehousingHow is BI derived - structureExamples for understandingEnterprise Performance Management ToolsQ&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 CapabilityComprehensive subject areas available for Ad-hoc analysisNew Calculated FieldsAvailable within Market Leading BI ToolsetEasy to use Charting toolFormattingWidgetsHighlightingMulti-languageComprehensive subject areas available for Ad-hoc analysisNew Calculated FieldsAvailable within Market Leading BI ToolsetEasy to use Charting toolFormattingWidgetsHighlightingMulti-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

OSU BA 471 - Business Intelligence & Analytics

Documents in this Course
D B M S

D B M S

13 pages

D B M S

D B M S

13 pages

RFID

RFID

12 pages

XML

XML

8 pages

W3C- Web

W3C- Web

23 pages

Linux

Linux

21 pages

Telecoms

Telecoms

11 pages

Linux

Linux

11 pages

Load more
Download Business Intelligence & Analytics
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Business Intelligence & Analytics and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Business Intelligence & Analytics 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?