Weeks 5&6 Outline • Capabilities of BI Solutions • Organizational Memory Capability • Information Integration • Insight Creation • Presentation • BI Vendors 4 Key Capabilities of BI Solutions Organizational Memory Capability • The ability to store information and knowledge Information Integration • The ability to link structured and unstructured data from a variety of sources Insight Creation • The ability to develop new insights and use them in the shortterm or long-term to make better decisions Presentation • The ability to use appropriate reporting and balanced scorecards tools, and thereby make BI more valuable to users Technologies Enabling Organizational Memory Capability Enterprise Resource Planning (ERP) • Refers to transactional systems that capture organizational memory related to all business processes that the organization engages in • Example: Order to cash captures all the transactions in an organization Transactional Systems • Capture all the relevant information for one accounting period (i.e. month/quarter/year/etc.) Data Warehouse • Provides the source of data and information for business intelligence (BI) analysis Why Information Integration Capability? • Mutually disconnected, incompatible transactional systems exist within an organization • Data exists outside of transactional systems such as e-mail, audio and video files, etc. • A lot of relevant external data is available, such as web sites, industry reports, expert opinions • More complex decision making due to an increase in the diversity of factors to consider Technologies Enabling Insight Creation Capabilities Data mining • Describe what happened or predict what will happen Business analytics • Discovery by using existing information • Discovery by finding useful patterns in observations Knowledge-modeling tool • Decision trees, rule induction Real time decision support Why Insight Creation Capabilities? • Need quick reflexes • Decisions must be made quickly to be competitive • Domain complexity is increasing • Must consider information from diverse arenas Why Presentation Capability? Content and format needs differ • Role • Ex. Top executive interest in firm-level performance vs. customersupport personnel interest in aids that support real-time responses to customers • Task • Ex. Customer-support specialist uses different information for each task • Preference • Ex. Individuals differ: Big picture view vs details first Technologies That Enable Presentation Capability Online Analytical Processing (OLAP) • OLAP is used essentially to query the data warehouse Visual Analytics • Refers to the use of computer graphics to create a visual representation of large collections of information Performance Dashboards • Measure performance • Used for forecasting Inputs and Outputs of the Four Business Intelligence Capabilities Users Information presented in user-friendly fashion and in ways most appropriate for the specific role, task, and situation Roles, tasks, and users’ inputs regarding preferred nature of presentation Users’ inputs about the analyses that may be appropriate Real-time data, Unstructured Information, External Information Data, information, explicit knowledge (mainly internal, structured) stored in systems as events occur Presentation Insight Creation New insights and information to support learning and real-time decision making Synthesized information about the past and present (structured and unstructured, external and internal) Information Integration Organizational Memory Historical information and explicit knowledge accumulated over time (mainly structured and internal) Four BI Mega-Vendors • Oracle (including Hyperion) • SAP (including Business Objects) • IBM (including Cognos and SPSS) • Microsoft Six Major Independent BI Vendors • SAS • Micro Strategy • Information Builders • TIBCO (including Spotfire) • Qliktech • Actuate
Purchase answer to see full attachment