Transcript DSS Chapter 1

Business Intelligence:
A Managerial Approach
(2nd Edition)
Chapter 1:
Introduction to Business
Intelligence
Learning Objectives




1-2
Understand today's turbulent business
environment and describe how organizations
survive and even excel in such an environment
(solving problems and exploiting opportunities)
Understand the need for computerized support
of managerial decision making
Describe the business intelligence (BI)
methodology and concepts and relate them to
decision support systems (DSS)
Understand the issues in implementing BI
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Opening Vignette…
“Norfolk Southern Uses BI for Decision
Support to Reach Success”
 Company background
 Problem
 Proposed solution
 Results
 Answer & discuss the case questions.
1-3
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Changing Business Environment &
Computerized Decision Support


Companies are moving aggressively to
computerized support of their
operations => Business Intelligence
Business Pressures–Responses–Support
Model



1-4
Business pressures result of today's
competitive business climate
Responses to counter the pressures
Support to better facilitate the process
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Business Pressures–Responses–
Support Model
1-5
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
The Business Environment

The environment in which organizations
operate today is becoming more and
more complex, creating:




Business environment factors:

1-6
opportunities, and
problems.
Example: globalization.
markets, consumer demands, technology,
and societal.
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Business Environment Factors
FACTOR
Markets
Consumer
demand
Technology
Societal
1-7
DESCRIPTION
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
Desire for customization
Desire for quality, diversity of products, and speed of delivery
Customers getting powerful and less loyal
More innovations, new products, and new services
Increasing obsolescence rate
Increasing information overload
Social networking, Web 2.0 and beyond
Growing government regulations and deregulation
Workforce more diversified, older, and composed of more women
Prime concerns of homeland security and terrorist attacks
Necessity of Sarbanes-Oxley Act and other reporting-related legislation
Increasing social responsibility of companies
Greater emphasis on sustainability
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Organizational Responses


Be Reactive, Anticipative, Adaptive, and
Proactive
Managers may take actions, such as:







1-8
Employing strategic planning.
Using new and innovative business models.
Restructuring business processes.
Participating in business alliances.
Improving corporate information systems.
Improving partnership relationships.
Encouraging innovation and creativity. …cont…>
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Organizational Responses, continued








1-9
Improving customer service and relationships.
Moving to electronic commerce (e-commerce).
Moving to make-to-order production and ondemand manufacturing and services.
Using new IT to improve communication, data
access (discovery of information), and
collaboration.
Responding quickly to competitors' actions (e.g., in
pricing, promotions, new products and services).
Automating many tasks of white-collar employees.
Automating certain decision processes.
Improving decision making by employing analytics.
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Closing the Strategy Gap

1-10
One of the major objectives of
computerized decision support is to
facilitate closing the gap between the
current performance of an organization
and its desired performance, as
expressed in its mission, objectives, and
goals, and the strategy to achieve
them.
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Business Intelligence (BI)

BI is an evolution of decision support
concepts over time.

Meaning of EIS/DSS…




1-11
Then: Executive Information System
Now: Everybody’s Information System (BI)
BI systems are enhanced with additional
visualizations, alerts, and performance
measurement capabilities.
The term BI emerged from industry
apps.
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Definition of BI




1-12
BI is an umbrella term that combines
architectures, tools, databases, analytical
tools, applications, and methodologies.
BI a content-free expression, so it means
different things to different people.
BI's major objective is to enable easy access
to data (and models) to provide business
managers with the ability to conduct analysis.
BI helps transform data, to information (and
knowledge), to decisions and finally to action.
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
A Brief History of BI


The term BI was coined by the Gartner
Group in the mid-1990s
However, the concept is much older





1-13
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
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
The Evolution of BI Capabilities
1-14
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
The Architecture of BI

A BI system has four major
components:




1-15
a data warehouse, with its source data
business analytics, a collection of tools for
manipulating, mining, and analyzing the
data in the data warehouse;
business performance management (BPM)
for monitoring and analyzing performance
a user interface (e.g., dashboard)
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
A High-level Architecture of BI
1-16
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Components in a BI Architecture

The data warehouse is the cornerstone of any
medium-to-large BI system.



Originally, the data warehouse included only
historical data that was organized and summarized,
so end users could easily view or manipulate it.
Today, some data warehouses include access to
current data as well, so they can provide real-time
decision support (for details see Chapter 2).
Business analytics are the tools that help
users transform data into knowledge (e.g.,
queries, data/text mining tools, etc.).
1-17
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
BI Examples



1-18
Epagogix is an analytics based BI system
that specializes in predicting success of
movies based on a detailed analysis of
movie scripts.
National Australia Bank uses data mining
to aid its marketing initiatives.
Hoyt Highland Partners, a marketing
intelligence firm, assists health care
providers with growing their businesses.
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Components in a BI Architecture


1-19
Business Performance Management (BPM),
which is also referred to as corporate
performance management (CPM), is an
emerging portfolio of applications within the BI
framework that provides enterprises tools they
need to better manage their operations (for
details see Chapter 3).
User Interface (i.e., dashboards) provides a
comprehensive graphical/pictorial view of
corporate performance measures, trends, and
exceptions.
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Styles of BI

MicroStrategy, Corp. distinguishes five
styles of BI and offers tools for each:
1.
2.
3.
4.
5.
1-20
report delivery and alerting
enterprise reporting (using dashboards
and scorecards)
cube analysis (also known as slice-anddice analysis)
ad-hoc queries
statistics and data mining
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
The Benefits of BI


The ability to provide accurate information
when needed, including a real-time view of
the corporate performance and its parts
A survey by Thompson (2004)





1-21
Faster, more accurate reporting (81%)
Improved decision making (78%)
Improved customer service (56%)
Increased revenue (49%)
See Table 1.2 for a list of BI analytic
applications, the business questions they
answer and the business value they bring.
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Automated Decision Making




A relatively new approach to supporting
decision making
Applies to highly structured decisions
Automated decision systems (ADS)
(or decision automation systems)
An ADS is a rule-based system that
provides a solution to a repetitive
managerial problem in a specific area.

1-22
e.g., simple-loan approval system
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Automated Decision-Making
Framework
1-23
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Automated Decision Making

ADS initially appeared in the airline
industry called revenue (or yield)
management (or revenue optimization)
systems.



1-24
dynamically price tickets based on actual
demand
Today, many service industries use
similar pricing models.
ADS are driven by business rules!
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Intelligence Creation and Use
A Cyclical Process
of Intelligence
Creation And Use
 BI practitioners
often follow the
national security
model depicted in
this figure.
1-25
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Intelligence Creation and Use

Steps Involved


Data warehouse deployment
Creation of intelligence

Identification and prioritization of BI projects



BI Governance

Who should do the prioritization?


1-26
By using ROI and TCO (cost-benefit analysis)
This process is also called BI governance
Partnership between functional area heads
Partnership between customers and providers
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
BI Governance Issues/Tasks
1.
2.
3.
4.
5.
1-27
Create categories of projects (investment,
business opportunity, strategic, mandatory,
etc.)
Define criteria for project selection
Determine and set a framework for
managing project risk
Manage and leverage project
interdependencies
Continuously monitor and adjust the
composition of the portfolio
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Intelligence and Espionage

Stealing corporate secrets, CIA, …


Intelligence vs. Espionage
Intelligence
The way that modern companies ethically and
legally organize themselves to glean as much as
they can from their customers, their business
environment, their stakeholders, their business
processes, their competitors, and other such
sources of potentially valuable information

Problem – too much data, very little value

1-28
Use of data/text/Web mining (see Chapter 4, 5)
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Transaction Processing Versus
Analytic Processing

Transaction processing systems are
constantly involved in handling updates
(add/edit/delete) to what we might call
operational databases.




1-29
ATM withdrawal transaction, sales order entry via
an ecommerce site – updates DBs
Online analytic processing (OLTP) handles routine
on-going business
ERP, SCM, CRM systems generate and store data
in OLTP systems
The main goal is to have high efficiency
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Transaction Processing Versus
Analytic Processing

Online analytic processing (OLAP) systems
are involved in extracting information from
data stored by OLTP systems




1-30
Routine sales reports by product, by region, by
sales person, etc.
Often built on top of a data warehouse where the
data is not transactional
Main goal is effectiveness (and then, efficiency) –
provide correct information in a timely manner
More on OLAP will be covered in Chapter 2
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Successful BI Implementation



Implementing and deploying a BI initiative is
a lengthy, expensive and risky endeavor!
Success of a BI system is measured by its
widespread usage for better decision making.
The typical BI user community includes

All levels of the management hierarchy (not just
the top executives, as was for EIS)


1-31
Provide what is needed to whom he/she needs it
A successful BI system must be of benefit to
the enterprise as a whole.
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
BI and Business Strategy

To be successful, BI must be aligned with the
company’s business strategy.


BI changes the way a company conducts
business by



1-32
BI cannot/should not be a technical exercise for
the information systems department.
improving business processes, and
transforming decision making to a more
data/fact/information driven activity.
BI should help execute the business strategy
and not be an impediment for it!
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
BI for Business Strategy

Strategy should be aligned with BI/DW – has the
capability to execute the initiative by establishing
a BI Competency Center (BICC) which can:


Demonstrate linkage – BI to strategy.
Encourage interaction between the potential business
users and the IS organization.




1-33
Both sides have a lot to learn from each other
Serve as a repository and disseminator of best BI
practices among the different lines of business.
Advocate and encourage standards of excellence.
Help stakeholders understand the crucial role of BI.
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Real-time, On-demand BI



The demand for “real-time” BI is growing!
Is “real-time” BI attainable?
Technology is getting there…





1-34
Automated, faster data collection (RFID, sensors,… )
Database and other software technologies (agent,
SOA, …) are advancing
Telecommunication infrastructure is improving
Computational power is increasing while the cost
for these technologies is decreasing
Trent -> Business Activity Management
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Issues for Successful BI

Developing vs. Acquiring BI systems





Developing everything from scratch
Buying/leasing a complete system
Using a shell BI system and customizing it
Use of outside consultants?
Justifying via cost-benefit analysis


It is easier to quantify costs
Harder to quantify benefits

1-35
Most of them are intangibles
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Issues for Successful BI

Security and Privacy



Still an important research topic in BI
How much security/privacy?
Integration of Systems and Applications

BI must integrate into the existing IS


Integration to outside (partners of the
extended enterprise) via internet –

1-36
Often sits on top of ERP, SCM, CRM systems
customers, vendors, government agencies, etc.
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Major BI Tools and Techniques

Tool categories







1-37
Data management
Reporting, status tracking
Visualization
Strategy and performance management
Business analytics
Social networking & Web 2.0
New/advanced tools/techniques to handle
massive data sets for knowledge discovery
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Major BI Vendors

In recent years, the landscape of BI vendors
has changed

Cognos acquired by IBM in 2008




1-38
Hyperion acquired by Oracle in 2008
Business Objects acquired by SAP in 2009
Microstrategy


IBM also acquired SPSS in 2009
May be the only independent large BI vendor
Others include Microsoft, SAS, Teradata
(mostly considered a DW vendor)
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
BI Resources

Teradata University Network







1-39
A great and free academic resource for BI (the available
resources include cases, articles, tools including
Microstrategy, datasets, exercises, etc.
The Data Warehousing Institute (tdwi.org)
The OLAP Report (olapreport.com)
DSS Resources (dssresources.com)
Business Intelligence Network (b-eye-network.com)
AIS World (isworld.org)
Microsoft Enterprise Consortium
(enterprise.waltoncollege.uark.edu/mec)
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
End of the Chapter

1-40
Questions / Comments…
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
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.
Publishing as Prentice Hall
1-41
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall