La business intelligence - publié le 21/07/2009

Résumé du document

- 1989, Howard Dresner; Gartner Group
"Concepts and methods to improve business decision making by using fact-based support systems".

Provide easy access to information relevant to meeting the strategic goals of the organization.
Facilitate and support the information and decision-making needs of top level executives (...)

Extraits

[...] When customers buy product A they usually buy product B Defining groups of customers (Clustering) Define marketing strategies Reporting Analyze Key Performance Indicators through Dimensions Tables, Charts, Alerts, For Business users Need to be defined closely with final users Ease of use and fast response time Often Web Applications Static reports Defined screens Or Interactive reports Explore data (drill down, drill up) Summary BI Definition Business Intelligence Chain BI Solutions Main players SAS IBM Cognos Market of BI solutions Jobs in a BI project Perspectives & Conclusion BI tools Types Complete BI solutions Platform Tools Query & Reporting Major vendors SAS IBM Cognos SAP - BO (Business Objects) Oracle Hyperion Microsoft Example - SAS Example - SAS Example - SAS Example - SAS IBM - Cognos IBM Cognos 8 BI Analysis Studio (Explore data to answer business questions) Report Studio (Professional Report Authoring) Query Studio (Ad Hoc Report Authoring) Metric Studio (Monitor, Analyze, and Report on KPI) Summary BI Definition Business Intelligence Chain BI Solutions Jobs in a BI project Perspectives & Conclusion Jobs in a BI project Summary BI Definition Business Intelligence Chain BI Solutions Jobs in a BI project Perspectives & Conclusion Perspectives Gartner “Through 2012, more than 35 per cent of the top 5,000 global companies will regularly fail to make insightful decisions about significant changes in their business and markets” 2012, business units will control at least 40 per cent of the total budget for per cent of organizations will have an industry-specific analytic application delivered via software as a service (SaaS) as a standard component of their BI portfolio” 2009, collaborative decision making will emerge as a new product category that combines social software with BI Platform capabilities” Conclusion Business users oriented Projects Everything must be defined with users Dimensions, measures Level of detail Reports Update frequency . [...]

[...] DE Activity Business Intelligence Summary BI Definition Business Intelligence Chain BI Solutions Jobs in a BI project Perspectives & Conclusion Business Intelligence - Definition 1958, Hans Peter Luhn, IBM ability to apprehend the interrelationships of presented facts in such a way as to guide action towards a desired goal.” 1989, Howard Dresner; Gartner Group “Concepts and methods to improve business decision making by using fact-based support systems.” Business Intelligence - Purpose Provide easy access to information relevant to meeting the strategic goals of the organization Facilitate and support the information and decision-making needs of top level executives Business Intelligence - Framework Summary BI Definition Business Intelligence Chain ETL Datawarehouse & OLAP Reporting, Datamining BI Solutions Jobs in a BI project Perspectives & Conclusion Business Intelligence Chain ETL Extract Transform Load Extract from multiple, heterogeneous sources Transform data Select Condition data (translate, calculate ) Condense, Aggregate Clean Load to datawarehouse Datawarehouse and Datamarts Contain all of company's Business data Data is clean, reliable, coherent Intelligent storage Issues Data update Response time Datamarts Subsets of the datawarehouse Specialized sets of data for specific Business users (Financial, HR, ) Adequate level of aggregation, specific vocabulary Online analytical processing (OLAP) Multidimensional view Hypercube concept Dimensions Hierarchy Measures, Facts Easy exploration Concepts of Drill down, Drill up, Different technologies R-OLAP, M-OLAP, H-OLAP Data mining Explore Huge sets of data to extract relevant information Finding not apparent correlations E.g. [...]