Slide 1Slide 2Definition of Business IntelligenceSlide 4The Business Intelligence CycleQuery, Analysis and Reporting ToolsHistory of Business IntelligenceRelevance and Influence of BI on organizationsRelevance and Influence of BI on organizationsHow can BI tools fulfill business needs?How can BI tools fulfill business needs?Slide 12Query ExampleSlide 14Future of BI, Going ForwardSlide 16BUSINESS INTELLIGENCE ANALYTICSQuery, Analysis and Reporting ToolsBrian BALSERLamia BENKIRANEJeralyn PASINABODave WILSONMBA 664April, the 13th, 20091. WHAT IS BUSINESS INTELLIGENCE?Definition of Business IntelligenceBusiness Intelligence (BI) is the set of methodologies, processes and tools that are used by corporations to gather, store, access, and analyze data to enable users to make better business decisions fasterThe principal goal of BI is to increase performance and gain a competitive advantage in the market placeBI also enables an effective implementation of the strategy by setting agreed upon and understood Key Performance Indicators (KPI)BI gives the right information to the right people at the right timeWhat is the difference between Business Intelligence and the Operational Systems?The data is captured daily in different databases which are stored in the Relational Database Management System (RDBMS)Several dimensions that we should consider to distinguish these two types of information systems. OIS Systems have limited Analysis capacities Analytical tools in BI systems provide insights to the analysts that they would not have been able to see within an OIS configuration.The Business Intelligence CycleThe OIS systems export the data to the BI systems that transform raw data into useful information by organizing it in dimensions, hierarchies and measures for analysis.Then, the users can turn this information into knowledge by using the various analytical tools of BI such as the query and reporting tools.BI allows the users to transform knowledge and rules into action by taking fact based decisions quickly.Query, Analysis and Reporting ToolsProvide the ability to any user at every level in the organization to analyze the data.Deliver fast and efficient multidimensional analysisAnswer business questions at the speed of thoughtEx: What is the profitability by product and by customer for 2008? Ex: What are the actual sales compared to the forecasted sales by period by region by salesperson? Present the data in reports where the user can:choose the dimensionsslice and dice the datafilter the datadrill down and drill acrossObjective: identify trends, patterns or anomalies; threats or opportunities and take informed decisions quickly.History of Business Intelligence Origins of BI: - first data simple processing applications (i.e. accounts payable and receivable in the early 1990s)- ran in sequential technology, such as magnetic and paper tapesBy the early 1990s, BI consisted of two nascent segments: data warehousing and desktop query and reporting tools.In the late 1990s, these desktop query and reporting tools were converted to the web and bundles with other types of analytical tools to create what are today called “BI suites” or “BI platforms”.The modern face of BI:Performance dashboards represent the latest incarnation of BI, the modern face of BI; they are built on years of technical and process innovation within the BI field and span both the data management and analytical sides of BI.Relevance and Influence of BI on organizationsTangible and Intangible BenefitsTangible Benefit can have value in relationship to bottom lineTime Savings Cost SavingsROIIntangible Benefit can have value to organization, but not to bottom line. Better quality decision makingRelevance and Influence of BI on organizationsTangible and Intangible BenefitsData Warehousing Institute: Study on a sample of 510 companies in 2003 Most BI benefits are intangible!How can BI tools fulfill business needs?Richmond Virginia Police Department Big Problem – 5th Most Dangerous City in 2004Had data – Crime Reports Too much InformationNeeded to extract information from dataHow can BI tools fulfill business needs?Richmond Virginia Police Department Improvement– 15th Most Dangerous City 2005Used BICrime Reports - Geographical Location - Weather Patterns - Sporting EventsReports– predictive crime analysis, data mining, reporting and GIS capabilities to the RPD2. Example of Analytical Tools•Query•ReportnetTWDC Planning Report - SegmentBusiness areaCompany codeCompany Code PartnerCost CenterCons.bus.areaControlling areaDest. GeographyDistribution ChannelDisney SegmentsDriverFiscal yearFiscal year/periodFunctional areaGroup CurrencyLocal CurrencyMaterialMedia issueMedia productPosting periodDimensionPartner UnitProfit CenterTWDCCPLSL Licensing Ap parel, Accessories & Footwea...Product TypePropertyProfit by Prdct Cat.QuarterTransaction CurrencyUnit of measureStructureAmount (T C P1B -2009; Amount (TC P1J -2008; Amount (TC PAZ -2007Account NumberTWDCSCPX031600 [L3] Rents and Leases - Real Property...Account Number Complex selectionBusiness area Complex selectionChart of accounts Walt Disney Company Chart of AccountsCompany code Complex selectionPosting period 1..12Fiscal Year Variant Z9G/L Account TWDC/Not assigned, 400001..979999Profit Center Disney Consumer ProdDest. Geography L3 GreeceAmount (TC) P1B -2009Amount (TC) P1B -2009Amount (TC) P1B -2009Amount ( TC) P1B -2009Quarter 1 2 3 4Profit Center Account Number Q1 Q2 Q3 Q4Overall Result -$ 3,073 -$ 2,749 -$ 2,822 -$ 3,436TWDCCPLHM Licens ing Home Result -$ 563 -$ 433 -$ 548 -$ 587TWDCCPLHM Licens ing Home TWDCSCPX031200 [L3] AllocationsTWDCCPLHM Licens ing Home TWDCSCPX041210 [L4] General AllocatTWDCCPLHM Licens ing Home TWDCSCPX041258 [L4] EME G&A AllocatTWDCCPLHM Licens ing Home TWDCSCPX031300 [L3] Other - GeneralTWDCCPLHM Licens ing Home TWDCSCPX041310 [L4] 670000 Bad DebtTWDCCPLHM Licens ing Home TWDCSCPX041346 [L4] 699000 MiscellaTWDCCPLHM Licens ing Home TWDCSCPX032200 [L3] Total DistributTWDCCPLHM Licens ing Home TWDCSCPX042224 [L4] 525000 RoyaltieTWDCCPLHM Licens ing Home TWDCSCPX032800 [L3] Revenues - Roya -$ 563 -$ 433 -$ 548 -$ 587TWDCCPLHM Licens ing Home TWDCSCPX042810 [L4] 401000 Earned R -$ 563 -$ 443 -$ 549 -$ 587TWDCCPLHM Licens ing Home TWDCSCPX042820 [L4] 401000 AdvancesTWDCCPLHM Licens ing Home