+ Chapter 7: Business Intelligence Tools and Vendors + Outline BI tools Relationship with capabilities and solutions Customization and standardization BI vendors Types of vendors + Outline BI vendors Type basis Ability to execute (ATE) Completeness of vision (COV) Type classifications Leaders Challengers Visionaries Niche Players + Business Intelligence Tools? Application software which enables BI Facilitates access, analysis of data and presentation of results Complement traditional ITs (DW, data mining, transaction processing systems) to enable 4 BI capabilities + Business Intelligence Tools Differ from BI Capabilities BI capabilities Organizational memory Information integration Insight creation Presentation + Business Intelligence Tools Differ from BI Solutions BI solutions Utilize BI tools acquired by an organization Draw upon existing data from traditional ITs, and other information to support the BI process by delivering information and knowledge to facilitate decision-making The four BI capabilities come together in BI solutions + Figure 7.1: BI Tools in Relation to BI Capabilities, Solution, Product, and Process BI Product Data and Information (External & Internal; Structured & Unstructured) BI Process Information (that leads to knowledge and/or enables decision making) BI Solution BI Capabilities Organizational Memory Sabhewal & Becerra-Fernandez Information Integration BI Tools Insight Creation OtherTechnologies Technologies Other (e.g., Data (e.g., Data Warehouse,Data Data Warehouse, Mining) Mining) Presentation +Figure 7.2: A Variety of BI Tool and Technologies Text Mining tools Knowledge Repositories Web Mining tools Data Warehousing Visualization tools Enterprise Resource Planning systems Business Analytics tools Environmental Scanning Scorecarding tools Real-time Decision Support tools Digital Dashboards BPM tools Document Management tools Digital Content Management tools Sabhewal & Becerra-Fernandez OLAP tools RFID Data Mining + BI Tools Classified into Categories Reporting, data mining, OLAP (Baars and Kemper) Increasing: cost, functionality, BI complexity & Decreasing: # of users (Keydata) Supports: data, information, knowledge, decisions (Olsak and Ziemba) BI tools and technologies map into four BI capabilities Drawn from other arenas to support BI capabilities Emerged with development of BI +Figure 7.3: Classifying BI Tools and Technologies Based on Supported Capability Organizational Memory Information Integration Data Warehousing ERP Knowledge Repositories Digital Content Management tools Document Management tools Business Analytics tools Data Mining Real-time Decision Support BI Capabilities BI Tools and Technologies Insight Creation Text Mining tools Web Mining tools Environmental Scanning RFID Presentation OLAP tools Visualization tools Digital Dashboards Scorecarding tools BPM tools Note: The highlighted tools have emerged along with development of BI, whereas the others have been adapted from other technologies to support BI. Sabhewal & Becerra-Fernandez + Customization vs Standardization of BI Tools Customization Could lead to wasting time on tools rather than business tasks Could lead to creating queries that are not useful to all Standardization Could be overly restrictive Could inhibit some of the major benefits from BI + Customization vs Standardization of BI Tools: Recommendations Tools supporting organizational memory capability should be standardized Tools supporting information integration should be customized only with respect to roles Tools supporting insight creation capabilities should be customized with respect to roles and tasks Tools supporting presentation capability should be customized with respect to roles, tasks, and individuals +Figure 7.4: Customization and Standardization of BI Tools and Technologies Standardization becomes more important Customization for users/situations becomes more important BI Capabilities BI Tools and Technologies No customization Customization for roles Organizational Memory Information Integration Data Warehousing ERP Knowledge Repositories Digital Content Management tools Document Management tools Business Analytics tools Data Mining Real-time Decision Support Customization for roles and tasks Insight Creation Text Mining tools Web Mining tools Environmental Scanning RFID Customization for roles, tasks, and individuals Presentation OLAP tools Visualization tools Digital Dashboards Scorecarding tools BPM tools Note: The highlighted tools have emerged along with development of BI, whereas the others have been adapted from other technologies to support BI. Sabhewal & Becerra-Fernandez + BI Mega-Vendors Oracle IBM Microsoft + Six Major Independent BI Vendors SAS Micro Strategy Information Builders TIBCO (including Spotfire) Qliktech Actuate + Other Notable BI Vendors Teradata HP arcplan Board International Panorama Software + Classification of BI Vendors ... #1 BI vendors Basis of classification Ability to execute (ATE) Completeness of vision (COV) Four types Leaders (strong in ATE, strong in COV) Challengers (strong in ATE, limited in COV) Visionaries (limited in ATE, strong in COV) Niche Players (limited in ATE, limited in COV) + Recap We have: Discussed BI tools, examined them in relation to BI Capabilities and solutions, and illustrated them Identified and classified major BI vendors and the tools they offer + Key Terms business intelligence tools business intelligence solutions business intelligence vendors mega-vendors independent BI vendors customization of BI tools standardization of BI tools Sabherwal & Becerra-Fernandez 19