Business IntelligenceWhat is Business Intelligence?BI FundamentalsData bases (DB or DBMS)Data warehouse (DW)Data martBusiness intelligence (BI)Data miningThe BI ChainWhat does BI seek to find?Techniques for Finding PatternsPatterns continuedThe “Shakeout”Leading the IndustryCognosWho uses BI?SourcesBusiness IntelligenceAndrew DavisAndria ZipplerJana KrinskyTiffany FerrisWhat is Business Intelligence?Business Intelligence, or BI, has recently become a hot topic in business information technology. Do you know anything about BI? What comes to mind in relation to this term?BI FundamentalsBusiness TransactionsData BasesData WarehousesData MartsData MiningData bases (DB or DBMS)“A collection of information organized in such a way that a computer program can quickly select desired pieces of data.” http://www.webopedia.comAn electronic filing systemOrganized by Fields: a single piece of informationRecords: one complete set of fieldsFiles: a collection of recordData warehouse (DW)“Contain a wide variety of data that present a coherent picture of business conditions at a single point in time.” http://www.webopedia.com“A database system which contains periodically collected samples or summarized (aggregated) transactional data; e.g., daily totals, or monthly averages”Typically a compilation of information from multiple transactional databasesData mart“A database, or collection of databases, designed to help managers make strategic decisions about their business.” http://www.webopedia.comA smaller and more focused form of a data warehouse. Usually created for a particular department or positionA data mart created as a subset of data warehouse data are referred to as a “dependent data mart”.Business intelligence (BI)‘”The tools and systems that play a key role in the strategic planning process of the corporation. These systems allow a company to gather, store, access and analyze corporate data to aid in decision making .” http://www.webopedia.comCommon applications:customer profiling customer support market researchmarket segmentation product profitability statistical analysisinventory and distribution analysisData mining“A class of database applications that look for patterns in data to be used to predict and direct future behavior.”Increasingly being used by marketers to find consumer data through the web and store purchases.The BI ChainTransactions Data are stored in the databaseDatabase info is periodically summarized (aggregated) and put into the data warehouseSummary data are further condensed into a data mart for specific department or executives Data mining takes place to identify useful information through a search for patternsInterpretation of information is used to make strategic decisionsWhat does BI seek to find?PatternsWhat kind of patterns?SalesStocksAnything usefulTechniques for Finding PatternsStatisticsTrendsCorrelation (searching for a best fit)Patterns continuedCombinatorialIf-then relationshipsExampleIf we put chips on sale on a Friday, then we also sell more soda.The “Shakeout”The Gartner BI MatrixCompares the completeness of a company’s vision to its ability to execute that vision.Leading the IndustryCognosBI software company (most recently Cognos 8)SoftwareUsed for reporting, analysis, scorecarding, dashboards, business event management, and data integrationCognosMultiple SolutionsIndustryBankingEducationDefenseGovernmentDepartmentExecutive ManagementFinanceMarketingWho uses BI?BusinessesThe Government??What are some ethical implications of the use of BI?Sources
View Full Document