Business IntelligenceIntroductionHistory of BIHistory of BI, cont.History of BI, cont.Data WarehousesData Warehouses, cont.Data MartsModern Uses and ApplicationsDesigning and implementing a business intelligence programGartner: Insights and advice from more than 1,000 technology expertsTransferring Data Into WisdomCompany Club CardsBI SoftwareBI SoftwareFatal Flaws of BI“Data Quality Problem…we don’t have one”“Our enterprise applications vendor will deliver the best solution”Smarter use of BISlide 20Business IntelligenceBusiness IntelligenceTony DevineTony DevineRyan FeigelsonRyan FeigelsonAngie KoslowskiAngie KoslowskiIntroductionIntroductionBusiness Intelligence: the exploration and Business Intelligence: the exploration and mining of data in search of meaningful mining of data in search of meaningful patternspatternsHistory and DefinitionsHistory and DefinitionsProgress through the 1990’s-->9/11Progress through the 1990’s-->9/11Modern Uses & Applications of BIModern Uses & Applications of BICompanies that provide this serviceCompanies that provide this serviceHistory of BIHistory of BIEarly references to Early references to Art of WarArt of WarTo succeed in war, one should have full To succeed in war, one should have full knowledge of one's own strengths and knowledge of one's own strengths and weaknesses and full knowledge of one's weaknesses and full knowledge of one's enemy's strengths and weaknessesenemy's strengths and weaknessesSimilar to business:Similar to business:Collecting DataCollecting DataDiscerning patterns and meaning from dataDiscerning patterns and meaning from dataResponding to resultant informationResponding to resultant informationHistory of BI, cont.History of BI, cont.Before information age, businesses struggled to Before information age, businesses struggled to gather data from non-automated sources and gather data from non-automated sources and made decisions based on intuition.made decisions based on intuition.As more systems became automated, more data As more systems became automated, more data became available.became available.Due to incompatibilities between systems and Due to incompatibilities between systems and platforms, businesses were unable to merge data platforms, businesses were unable to merge data from various sources in order to make it from various sources in order to make it meaningful.meaningful.Need for short- and long-term data to make Need for short- and long-term data to make company-wide strategic decisions. company-wide strategic decisions.History of BI, cont. History of BI, cont. Impact of 9/11Impact of 9/11Made security issues more of a concernMade security issues more of a concernNeed to know enemyNeed to know enemyThe need to discern patterns and make strategic decisions in The need to discern patterns and make strategic decisions in business and governmental organizations.business and governmental organizations.Encouraged developers to create efficient systems that Encouraged developers to create efficient systems that worked for many industries and organizations.worked for many industries and organizations.Data warehouses and data marts emerged as an Data warehouses and data marts emerged as an answer to the problem of multi-system answer to the problem of multi-system incompatibilityincompatibilityData WarehousesData WarehousesData Warehouse: repository of integrated Data Warehouse: repository of integrated information, available for queries and information, available for queries and analysis.analysis.Place where relevant data can be held for Place where relevant data can be held for completing strategic reports for management.completing strategic reports for management.Strategy-->most execs are less concerned with Strategy-->most execs are less concerned with day to day operations, as they are with overall day to day operations, as they are with overall business functionsbusiness functionsCan use this information for strategic decisions.Can use this information for strategic decisions.Data Warehouses, cont.Data Warehouses, cont.Businesses use multiple platforms and Businesses use multiple platforms and technology. technology. Data Warehouses take data from multiple Data Warehouses take data from multiple platforms and place them in common location platforms and place them in common location using common query tool.using common query tool.This makes decision support more readily This makes decision support more readily available without affecting day to day operations.available without affecting day to day operations.Not a location for Not a location for all data, all data, but a location for data that is but a location for data that is interesting.interesting.Data MartsData MartsData warehouses combine data across the Data warehouses combine data across the entire enterprise.entire enterprise.Data mart: specialized version of data Data mart: specialized version of data warehouse. Creation of data is predicated warehouse. Creation of data is predicated on specific, defined need for certain on specific, defined need for certain grouping of select data.grouping of select data.Smaller than warehouse, focuses on particular Smaller than warehouse, focuses on particular subject/department.subject/department.Modern Uses and ApplicationsModern Uses and ApplicationsBusiness Intelligence can be used in a Business Intelligence can be used in a variety of business functions, including:variety of business functions, including:Process Re-EngineeringProcess Re-EngineeringDecision Support SystemsDecision Support SystemsFinance/BudgetingFinance/BudgetingCompetitive AnalysisCompetitive AnalysisSupply Chain ManagementSupply Chain ManagementDesigning and implementing a business Designing and implementing a business intelligence programintelligence programGoal Alignment queriesGoal Alignment queries-The first step determines the short and medium-term purposes of the program.-The first step determines the short and medium-term purposes of the program. -What strategic goals of the organization will the program address? -What strategic goals of the organization will the program address? -What organizational mission/vision does it relate to?-What organizational mission/vision does it relate to?-A crafted hypothesis needs to detail how this initiative will eventually improve results / -A crafted hypothesis needs
View Full Document