Transcript Slide 1

Chapter 1
DECISION SUPPORT
SYSTEMS AND
BUSINESS
INTELLIGENCE
Learning Objectives
• Understand today’s turbulent business
environment and describe how organizations
survive and even excel in such an environment
• Understand the need for computerized support of
managerial decision making
• Understand an early framework for managerial
decision making
• Learn the conceptual foundations of the decision
support systems (DSS) methodology
Learning Objectives
• Describe the business intelligence (BI)
methodology and concepts and relate them to
DSS
• Describe the concept of work systems and its
relationship to decision support
• List the major tools of computerized decision
support
• Understand the major issues in implementing
computerized support systems
Changing Business Environments and
Computerized Decision Support
• The business pressures-responses-support
model
– The business environment
– Organizational responses: be reactive,
anticipative, adaptive, and proactive
– Computerized support
Managerial Decision Making
• The nature of managers’ work
– Interpersonal
– Informational
– Decisional
Managerial Decision Making
Managerial Decision Making
•
The process of decision making
1. Defining the problem (a decision situation that may
deal with some difficulty or with an opportunity)
2. Constructing a model that describes the real-world
problem
3. Identifying possible solutions to the modeled
problem and evaluating the solutions
4. Comparing, choosing, and recommending a potential
solution to the problem
Managerial Decision Making
• Decision support systems (DSS)
A conceptual framework for a process of
supporting managerial decision- making,
usually by modeling problems and
employing quantitative models for solution
analysis
Computerized Support for Decision
Making
• Why use computerized decision support
systems
–
–
–
–
–
Speedy computations
Improved communication and collaboration
Increased productivity of group members
Improved data management
Managing giant data warehouses
Computerized Support for Decision
Making
• Why use computerized decision support
systems
– Quality support
– Agility support
– Overcoming cognitive limits in processing and
storing information
– Using the Web
– Anywhere, anytime support
Computerized Support for Decision
Making
• Cognitive limits
The limitations of the human mind related
to processing information
An Early Framework for Computerized
Decision Support
An Early Framework for Computerized
Decision Support
– Degree of structuredness
• Four-phase decision making process
–
–
–
–
Intelligence
Design
Choice
Implementation
An Early Framework for Computerized
Decision Support
An Early Framework for Computerized
Decision Support
– Types of control in all managerial activities
• Strategic planning
• Management control
• Operational control
– The decision support matrix
• For semistructured decisions and unstructured
decisions, conventional MIS and MS tools are
insufficient
• Decision support systems (DSS) are used
An Early Framework for Computerized
Decision Support
• Computer support for structured decisions
– Management science (MS) or operations
research (OR)
The application of a scientific approach and
mathematical models to the analysis and
solution of managerial decision situations (e.g.,
problems, opportunities)
Example of OR problems (Hamdy A. Taha book)
*simple two variables LP model
• A company owns a small paint factory that produces both interior
and exterior house paints. Two basic raw materials, A and B, are used
to manufacture the paints.
• The maximum availability of A is 6 tons a day; that of B is 8 tons a
day. The daily requirements of the raw materials per ton of interior
and exterior paints are summarized in the following table.
Tons of Raw Material per Ton of Paint
Exterior
Interior
Maximum Availability (tons)
Raw Material A
1
2
6
Raw Material B
2
1
8
• A market survey has established that the daily demand for the
interior paint cannot exceed that of exterior paint by more than 1 ton.
The survey also showed that the maximum demand for the interior
paint is limited to 2 tons daily.
• The wholesale price per ton is $3000 for exterior paint and $2000 per
interior paint. How much interior and exterior paint should the
company produce daily to maximize gross income?
Cont. OR Example
Define:
XE = Tons of exterior paint to be produced
XI = Tons of interior paint to be produced
Thus, the LP formulation of the Reddy-Mikks Company is as follows:
Maximize z = 3XE + 2XI
Subject to:
XE + 2XI  6 (1) (availability of raw material A)
2XE + XI  8 (2) (availability of raw material B)
-XE + XI  1 (3) (Restriction in production)
XI  2 (4) (Demand Restriction)
XE , XI  0
An Early Framework for Computerized
Decision Support
• Computer support for structured decisions
– Automated decision systems (ADS)
A business rules-based system that uses
intelligence to recommend solutions to
repetitive decisions (such as pricing)
Ex: in airline industry.
Airline companies use ADS to dynamically price
tickets based on actual demand.
An Early Framework for Computerized
Decision Support
• Computer support for unstructured
decisions
– Customized solutions
– intuition and judgment
– Computerized communication and
collaboration technologies
– Knowledge management
An Early Framework for Computerized
Decision Support
• Computer support for semistructured problems
– A combination of both standard solution procedures
and human judgment
– Management Science can provide models for the
structured portion
– For the unstructured portion, a DSS can improve the
quality of the information on which the decision is
based by providing a range of alternative solutions
along with their potential impacts
The Concept of Decision Support
Systems (DSS)
• DSS as an Umbrella term: Describes any
computerized system that supports decision
making in an organization
– DSS as a specific application
– The architecture of DSS
•
•
•
•
•
Data
Models manipulate data as related to a specific situation
Knowledge component
Users
User interface
The Concept of Decision Support
Systems (DSS)
The Concept of Decision Support
Systems (DSS)
– Types of DSS
• model-oriented DSS:
– quantitative models used to generate a recommended
solution to a problem .
– store the model software on a server and distribute the
user interface software to clients.
• data-oriented DSS:
– support ad-hoc reporting and queries .
– emphasizes database performance and scalability.
The DSS-BI connection
1. The architecture is very similar since BI
evolved from DSS.
- BI implies the use of a data warehouse while DSS may
or may not have such a feature.
- BI is more appropriate for large organizations. But
DSS is appropriate to any type of organizations.
2. DSS directly support specific decision making,
while BI provides accurate and timely
information, and indirectly support decision
making
3. BI has an executive and strategy orientation
while DSS has been oriented toward analysts
•
The DSS-BI connection
4. BI systems are constructed with commercially
available tools and components that are fitted
to the needs of organizations; DSS more
programming is used to construct custom
solutions to very unstructured problems
5. DSS were developed mostly in the academic
world; BI were developed mostly by software
companies
6. Many tools used by BI are also considered DSS
tools (e.g., data mining and predictive analysis )
The Major Tools and Techniques
of Managerial Decision Support
Computerized Tools for Decision Support
• Data management
• Reporting status
tracking
• Visualization
• Business analytics
• Strategy and
performance
management
• Communication and
collaboration
• Knowledge
management
• Intelligent systems
• Enterprise systems
The Major Tools and Techniques
of Managerial Decision Support
• Tools-Web connection
– All of these tools are available in both webbased and non web-based formats
• Hybrid (integrated) support systems
A support system that uses several tools
and techniques to assist management in
solving managerial or organizational
problems and assess opportunities and
strategies