02 decision support bi
TRANSCRIPT
-
8/3/2019 02 Decision Support Bi
1/46
Decision Support andecision Support andBusiness Intelligenceusiness IntelligenceSystemsystems
Chapter 1:hapter 1:Decision Support Systemsecision Support Systemsand Business Intell igencend Business Intell igence
-
8/3/2019 02 Decision Support Bi
2/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-2
Learning ObjectivesLearning Objectives
Understand today's turbulent businessenvironment and describe how organizationssurvive and even excel in such an environment
(solving problems and exploiting opportunities) Understand the need for computerized support
of managerial decision making
Understand an early framework for managerialdecision making
Learn the conceptual foundations of thedecision support systems (DSS)
-
8/3/2019 02 Decision Support Bi
3/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-3
Learning Objectives cont.Learning Objectives cont.
Describe the business intelligence (BI)methodology and concepts and relate them toDSS
List the major tools of computerized decisionsupport
Understand the major issues in implementingcomputerized support systems
-
8/3/2019 02 Decision Support Bi
4/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-4
Opening Vignette:Opening Vignette:
Norfolk Southern Uses BI for DecisionSupport to Reach Success
Company background
Problem
Proposed solution
ResultsAnswer and discuss the case questions
-
8/3/2019 02 Decision Support Bi
5/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-5
Changing Business EnvironmentChanging Business Environment
Companies are moving aggressively tocomputerized support of theiroperations => Business Intelligence
Business PressuresResponsesSupportModel Business pressures result of today's
competitive business climate Responses to counter the pressures Support to better facilitate the process
-
8/3/2019 02 Decision Support Bi
6/46
-
8/3/2019 02 Decision Support Bi
7/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-7
The Business EnvironmentThe Business Environment
The environment in which organizationsoperate today is becoming more andmore complex, creating: opportunities, and problems Example: globalization
Business environment factors: markets, consumer demands, technology,
and societal
-
8/3/2019 02 Decision Support Bi
8/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-8
Business Environment FactorsBusiness Environment Factors
FACTOR DESCRIPTIONMarkets Strong competition
Expanding global markets
Blooming electronic markets on the Internet
Innovative marketing methods
Opportunities for outsourcing with IT support
Need for real-time, on-demand transactions
Consumer Desire for customization demand Desire for quality, diversity of products, and speed of delivery
Customers getting powerful and less loyal
Technology More innovations, new products, and new services
Increasing obsolescence rate
Increasing information overload
Social networking, Web 2.0 and beyondSocietal Growing government regulations and deregulation
Workforce more diversified, older, and composed of more women
Prime concerns of homeland security and terrorist attacks
Increasing social responsibility of companies
Greater emphasis on sustainability
-
8/3/2019 02 Decision Support Bi
9/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-9
Organizational ResponsesOrganizational Responses
Be Reactive, Anticipative, Adaptive, andProactive
Managers may take actions, such as Employ strategic planning Use new and innovative business models Restructure business processes
Participate in business alliances Improve corporate information systems Improve partnership relationships Encourage innovation and creativity cont>
-
8/3/2019 02 Decision Support Bi
10/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-10
Managers actions, continuedManagers actions, continued
Improve customer service and relationships Move to electronic commerce (e-commerce) Move to make-to-order production and on-demand
manufacturing and services Use new IT to improve communication, data access
(discovery of information), and collaboration Respond quickly to competitors' actions (e.g., in
pricing, promotions, new products and services) Automate many tasks of white-collar employees Automate certain decision processes Improve decision making by employing analytics
-
8/3/2019 02 Decision Support Bi
11/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-11
Closing the Strategy GapClosing the Strategy Gap
One of the major objectives ofcomputerized decision support is tofacilitate closing the gap between the
current performance of an organizationand its desired performance, asexpressed in its mission, objectives, and
goals, and the strategy to achieve them
-
8/3/2019 02 Decision Support Bi
12/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-12
Managerial Decision MakingManagerial Decision Making
Management is a process by whichorganizational goals are achieved byusing resources Inputs: resources Output: attainment of goals Measure of success: outputs / inputs
Management Decision Making Decision making: selecting the best
solution from two or more alternatives
-
8/3/2019 02 Decision Support Bi
13/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-13
Decision Making ProcessDecision Making Process
Managers usually make decisions byfollowing a four-step process (a.k.a. thescientific approach)
1. Define the problem (or opportunity)2. Construct a model that describes the real-
world problem
3. Identify possible solutions to the modeledproblem and evaluate the solutions
4. Compare, choose, and recommend apotential solution to the problem
-
8/3/2019 02 Decision Support Bi
14/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-14
Decision making is difficult, becauseDecision making is difficult, because
Technology, information systems, advanced searchengines, and globalization result in more and morealternatives from which to choose
Government regulations and the need for compliance,
political instability and terrorism, competition, andchanging consumer demands produce moreuncertainty, making it more difficult to predictconsequences and the future
Other factors are the need to make rapid decisions, thefrequent and unpredictable changes that make trial-and-error learning difficult, and the potential costs ofmaking mistakes
-
8/3/2019 02 Decision Support Bi
15/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-15
Why Use Computerized DSSWhy Use Computerized DSS
Computerized DSS can facilitatedecision via: Speedy computations Improved communication and collaboration Increased productivity of group members Improved data management
Overcoming cognitive limits Quality support; agility support Using Web; anywhere, anytime support
-
8/3/2019 02 Decision Support Bi
16/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-16
A Decision Support FrameworkA Decision Support Framework(by Gory and Scott-Morten, 1971)(by Gory and Scott-Morten, 1971)
-
8/3/2019 02 Decision Support Bi
17/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-17
A Decision Support Framework cont.A Decision Support Framework cont.
Degree of Structuredness (Simon, 1977) Decision are classified as
Highly structured (programmed)
Semi-structured Highly unstructured (i.e., non-programmed)
Types of Control (Anthony, 1965)
Strategic planning (top-level, long-range) Management control (tactical planning) Operational control
-
8/3/2019 02 Decision Support Bi
18/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-18
Simons Decision-Making ProcessSimons Decision-Making Process
-
8/3/2019 02 Decision Support Bi
19/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-19
Computer Support for StructuredComputer Support for Structured
DecisionsDecisions
Structured problems: encounteredrepeatedly, have a high level of structure
It is possible to abstract, analyze, and
classify them into specific categories e.g., make-or-buy decisions, capital
budgeting, resource allocation, distribution,
procurement, and inventory control For each category a solution approach is
developed => Management Science
-
8/3/2019 02 Decision Support Bi
20/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-20
Management Science ApproachManagement Science Approach
Also referred to as Operation Research
In solving problems, managers shouldfollow the five-step MS approach1. Define the problem
2. Classify the problem into a standard category (*)
3. Construct a model that describes the real-worldproblem
4. Identify possible solutions to the modeled problemand evaluate the solutions
5. Compare, choose, and recommend a potentialsolution to the problem
-
8/3/2019 02 Decision Support Bi
21/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-21
Automated Decision MakingAutomated Decision Making
A relatively new approach to supportingdecision making
Applies to highly structures decisions
Automated decision systems (ADS)
(or decision automation systems)
An ADS is a rule-based system thatprovides a solution to a repetitivemanagerial problem in a specific area e.g., simple-loan approval system
-
8/3/2019 02 Decision Support Bi
22/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-22
Automated Decision MakingAutomated Decision Making
ADS initially appeared in the airlineindustry called revenue (or yield)management (or revenue optimization)
systems dynamically price tickets based on actual
demand
Today, many service industries usesimilar pricing models
ADS are driven by business rules!
-
8/3/2019 02 Decision Support Bi
23/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-23
Computer Support forComputer Support for
Unstructured DecisionsUnstructured Decisions
Unstructured problems can be onlypartially supported by standardcomputerized quantitative methods
They often require customized solutions They benefit from data and information
Intuition and judgment may play a role
Computerized communication andcollaboration technologies along withknowledge management is often used
-
8/3/2019 02 Decision Support Bi
24/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-24
Computer Support forComputer Support for
Semi-structured ProblemsSemi-structured Problems
Solving semi-structured problems mayinvolve a combination of standardsolution procedures and human
judgment MS handles the structured parts while
DSS deals with the unstructured parts
With proper data and information, arange of alternative solutions, along withtheir potential impacts
-
8/3/2019 02 Decision Support Bi
25/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-25
Automated Decision-MakingAutomated Decision-Making
FrameworkFramework
-
8/3/2019 02 Decision Support Bi
26/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-26
Concept of Decision Support SystemsConcept of Decision Support Systems
Classical Definitions of DSSClassical Definitions of DSS
Interactive computer-based systems, which helpdecision makers utilize data and models to solve
unstructured problems" - Gorry and Scott-Morton, 1971
Decision support systems couple the intellectualresources of individuals with the capabilities of the
computer to improve the quality of decisions. It is acomputer-based support system for managementdecision makers who deal with semistructuredproblems - Keen and Scott-Morton, 1978
-
8/3/2019 02 Decision Support Bi
27/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-27
DSS as an Umbrella TermDSS as an Umbrella Term
The term DSS can be used as anumbrella term to describe anycomputerized system that supports
decision making in an organization E.g., an organization wide knowledge
management system; a decision support
system specific to an organizational function(marketing, finance, accounting,manufacturing, planning, SCM, etc.)
-
8/3/2019 02 Decision Support Bi
28/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-28
DSS as a Specific ApplicationDSS as a Specific Application
In a narrow sense DSS refers to aprocess for building customizedapplications for unstructured or semi-
structured problems Components of the DSS Architecture
Data, Model, Knowledge/Intelligence, User,
Interface (API and/or user interface) DSS often is created by putting together
loosely coupled instances of thesecomponents
-
8/3/2019 02 Decision Support Bi
29/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-29
High-Level Architecture of a DSSHigh-Level Architecture of a DSS
-
8/3/2019 02 Decision Support Bi
30/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-30
Types of DSSTypes of DSS
Two major types: Model-oriented DSS Data-oriented DSS
Evolution of DSS into Business Intelligence Use of DSS moved from specialist to managers, and
then whomever, whenever, wherever
Enabling tools like OLAP, data warehousing, datamining, intelligent systems, delivered via Webtechnology have collectively led to the termbusiness intelligence (BI) and business analytics
-
8/3/2019 02 Decision Support Bi
31/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-31
Business Intelligence (BI)Business Intelligence (BI)
BI is an umbrella term that combinesarchitectures, tools, databases, analyticaltools, applications, and methodologies
Like DSS, BI a content-free expression, so itmeans different things to different people
BI's major objective is to enable easy accessto data (and models) to provide business
managers with the ability to conduct analysis BI helps transformdata, to information (and
knowledge), to decisions and finally to action
-
8/3/2019 02 Decision Support Bi
32/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-32
A Brief History of BIA Brief History of BI
The term BI was coined by the GartnerGroup in the mid-1990s
However, the concept is much older 1970s - MIS reporting - static/periodic reports 1980s - Executive Information Systems (EIS) 1990s - OLAP, dynamic, multidimensional, ad-hoc
reporting -> coining of the term BI 2005+ Inclusion of AI and Data/Text Mining
capabilities; Web-based Portals/Dashboards 2010s - yet to be seen
-
8/3/2019 02 Decision Support Bi
33/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-33
The Evolution of BI CapabilitiesThe Evolution of BI Capabilities
-
8/3/2019 02 Decision Support Bi
34/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-34
The Architecture of BIThe Architecture of BI
A BI system has four major components a data warehouse, with its source data business analytics, a collection of tools for
manipulating, mining, and analyzing thedata in the data warehouse;
business performance management (BPM)
for monitoring and analyzing performance a user interface (e.g., dashboard)
-
8/3/2019 02 Decision Support Bi
35/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-35
A High-Level Architecture of BIA High-Level Architecture of BI
-
8/3/2019 02 Decision Support Bi
36/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-36
Components in a BI ArchitectureComponents in a BI Architecture
The data warehouse is a large repository ofwell-organized historical data
Business analytics are the tools that allow
transformation of data into information andknowledge
Business performance management (BPM)allows monitoring, measuring, and comparing
key performance indicators User interface (e.g., dashboards) allows access
and easy manipulation of other BI components
-
8/3/2019 02 Decision Support Bi
37/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-37
Styles of BIStyles of BI
MicroStrategy, Corp. distinguishes fivestyles of BI and offers tools for each
1. report delivery and alerting
2. enterprise reporting (using dashboardsand scorecards)
3. cube analysis (also known as slice-and-
dice analysis)4. ad-hoc queries
5. statistics and data mining
-
8/3/2019 02 Decision Support Bi
38/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-38
The Benefits of BIThe Benefits of BI
The ability to provide accurate informationwhen needed, including a real-time view ofthe corporate performance and its parts
A survey by Thompson (2004) Faster, more accurate reporting (81%) Improved decision making (78%) Improved customer service (56%)
Increased revenue (49%) See Table 1.3 for a list ofBI analytic
applications, the business questions they answerand the business value they bring
-
8/3/2019 02 Decision Support Bi
39/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-39
The DSSBI ConnectionThe DSSBI Connection
First, their architectures are very similarbecause BI evolved from DSS
Second, DSS directly support specific decision
making, while BI provides accurate and timelyinformation, and indirectly support decisionmaking
Third, BI has an executive and strategy
orientation, especially in its BPM anddashboard components, while DSS, incontrast, is oriented toward analysts
-
8/3/2019 02 Decision Support Bi
40/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-40
The DSSBI Connection cont.The DSSBI Connection cont.
Fourth, most BI systems are constructed withcommercially available tools and components,while DSS is often built from scratch
Fifth, DSS methodologies and even some toolswere developed mostly in the academic world,while BI methodologies and tools weredeveloped mostly by software companies
Sixth, many of the tools that BI uses are alsoconsidered DSS tools (e.g., data mining andpredictive analysis are core tools in both)
-
8/3/2019 02 Decision Support Bi
41/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-41
The DSSBI Connection cont.The DSSBI Connection cont.
Although some people equate DSS with BI,these systems are not, at present, the same some people believe that DSS is a part of BIone of
its analytical tools others think that BI is a special case of DSS that
deals mostly with reporting, communication, andcollaboration (a form of data-oriented DSS)
BI is a result of a continuous revolution and, as such,DSS is one of BI's original elements
In this book, we separate DSS from BI
MSS = BI and/or DSS
-
8/3/2019 02 Decision Support Bi
42/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-42
Major Tool Categories for MSSMajor Tool Categories for MSS
Source: Table 1.4Source: Table 1.4
TOOL CATEGORY TOOLS AND THEIR ACRONYMS
Data management Databases and database management system (DBMS)
Extraction, transformation, and load (ETL) systems
Data warehouses (DW), real-time DW, and data marts
Reporting status tracking Online analytical processing (OLAP)
Executive information systems (EIS)
Visualization Geographical information systems (GIS)
Dashboards, Information portals
Multidimensional presentations
Business analytics Optimization, Web analyticsData mining, Web mining, and text mining
Strategy and performance
management
Business performance management (BPM)/
Corporate performance management (CPM)
Business activity management (BAM)
Dashboards and Scorecards
Communication and
collaboration
Group decision support systems (GDSS)
Group support systems (GSS)
Collaborative information portals and systems
Social networking Web 2.0, Expert locating systems
Knowledge management Knowledge management systems (KMS)
Intelligent systems Expert systems (ES)
Artificial neural networks (ANN)
Fuzzy logic, Genetic algorithms, Intelligent agents
Enterprise systems Enterprise resource planning (ERP),
Customer Relationship Management (CRM), and
Supply-Chain Management (SCM)
-
8/3/2019 02 Decision Support Bi
43/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-43
Hybrid (Integrated) Support SystemsHybrid (Integrated) Support Systems
The objective of computerized decision support,regardless of its name or nature, is to assistmanagement in solving managerial or organizationalproblems (and assess opportunities and strategies)
faster and better than possible without computers Every type of tool has certain capabilities and
limitations. By integrating several tools, we can improvedecision support because one tool can provide
advantages where another is weak
The trend is therefore towards developing
hybrid (integrated) support system
-
8/3/2019 02 Decision Support Bi
44/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-44
Hybrid (Integrated) Support SystemsHybrid (Integrated) Support Systems
Type of integration Use each tool independently to solve different
aspects of the problem Use several loosely integrated tools. This mainly
involves transferring data from one tool to anotherfor further processing
Use several tightly integrated tools. From the user'sstandpoint, the tool appears as a unified system
In addition to performing different tasks in theproblem-solving process, tools can supporteach other
-
8/3/2019 02 Decision Support Bi
45/46
Copyright 2011 Pearson Education, Inc. Publishing as Prentice Hall-45
End of the ChapterEnd of the Chapter
Questions / Comments
-
8/3/2019 02 Decision Support Bi
46/46
All rights reserved. No part of this publication may be reproduced, stored in a
retrieval system, or transmitted, in any form or by any means, electronic,
mechanical, photocopying, recording, or otherwise, without the prior written
permission of the publisher. Printed in the United States of America.Copyright 2011 Pearson Education, Inc.Copyright 2011 Pearson Education, Inc.
Publishing as Prentice HallPublishing as Prentice Hall