Transcript Slides - Zhangxi Lin - Texas Tech University

ISQS 3358, Business Intelligence
Anatomy of Business Intelligence
Zhangxi Lin
Texas Tech University
1
Learning Objectives
Understand the general ideas in business
intelligence by cases
 Catch main BI concepts
 Get familiar with the most popular BI
applications and tools
 Know how to access your BI resources
for this course

ISQS 3358
2
Outline
BI cases
 BI framework
 BI applications
 BI tools

ISQS 3358
3
BI in US 2016 President Election

Note: there is no tendency to the candidates, but a
pure BI case for study purposes. Candidates here
◦ How, 2:14, July 28, 2016
◦ Analysis: 2016 Presidential Elections Breakdown,
10:09, Aug 10, 2016
◦ Analysis: 2016 US Elections Campaign Financing
Breakdown Report, 3:00, Jan 29, 2016
◦ Prediction, 11:26, July 14, 2016
◦ Analysis: What Happens If A Presidential Election Ends
In A Tie?, 3:38, Feb 14, 2016
ISQS 3358
4
Questions
How to understand the status of presidential
election?
 Could the outcome of presidential election be
predicted?

◦ Mining Presidential Campaign Speeches Romney vs. Obama
◦ http://www.youtube.com/watch?v=2Znairz-hvU,
16’31”

How to conduct BI analysis for the presidential
election?
◦ Check UC Berkeley’s effort
ISQS 3358
5

Congress is split into two chambers—the
House of Representatives and Senate.
◦ Congress writes national legislation by dividing work
into separate committees which specialize in different
areas.
◦ The disparity between the most and least populous
states has grown since the Connecticut Compromise,
which granted each state two members of the Senate
and at least one member of the House of
Representatives, for a total minimum of three
presidential Electors, regardless of population.
ISQS 3358
6
Control of Dems vs. Reps
Presidency data
Primary results
ISQS 3358
7
More applications
Premier Bank Card 3’46”
 Mobile Business Intelligence with iPhone
2’58”
 Business intelligence with iPad 2’29”

ISQS 3358
8
Questions
What is the relationship between BI and
MIS?
 What are main applications in BI?
 What are main BI technologies?
 How should we start with?

◦
◦
◦
◦
Data collection. Dataset1, 2, 3, 4, 5, 6, 7, 8
Data warehousing
Data visualization
Data analysis
ISQS 3358
9
Different Users of Business Intelligence

There are many different users who can
benefit from business intelligence
◦ Executives – Those who focus on the
overall business
◦ Business Decision Makers – Usually
focused on single areas of the business
(finance, HR, manufacturing, and so forth)
◦ Information Workers – Typically managers
or staff working in the back office
◦ Line Workers – Employees who might use
BI without knowing it
◦ Analysts – Employees who will perform
extensive data analysis
10
ISQS 3358
10
Business Intelligence
BI Applications:
- Data warehousing
-Data mining
- BPM
- OLAP
- etc.
Data
Business
Analytics
Executives
Managers
Operators
BI Users
Data
Business
Environment
Decisions
ISQS 3358
11
BI vs. MIS
MIS were used by a select few in the organization, due
to the efforts involved in collecting data and preparation
of summaries from the same. Use of Computers in the
MIS process helped in speeding up the process and
increased its reach.
 Then came the phase of BI

◦ BI has been privilege of the TOP segment of the pyramid.
◦ The cost involved prohibited the expansion of BI to the Middle tier
Business users.
◦ Operational BI is expected to do the task of making it available to
masses, as they are the ones who need BI, more times in a day.
ISQS 3358
12
BI Framework
A Framework for
Business Intelligence (BI)

The Business Value of BI
◦ How BI Can Help
 Assess their readiness for meeting the challenges posed by
these new business realities
 Take a holistic approach to BI functionality
 Leverage best practices and anticipate hidden costs
◦ Key Issues and Framework for BI Analysis
 How can enterprises maximize their BI investments?
 What BI functionality do enterprises need, and what are they
using today?
 What are some of the hidden costs associated with BI
initiatives?
ISQS 3358
14
A Framework for
Business Intelligence (BI)
The






Benefits of BI
Time savings
Single version of truth
Improved strategies and
plans
Improved tactical decisions
More efficient processes
Cost savings
Faster, more accurate reporting
 Improved decision making
 Improved customer service
 Increased revenue

ISQS 3358
15
Changing Business Environments
and Computerized Decision Support
ISQS 3358
16
A Framework for
Business Intelligence (BI)

BI’s Architecture and Components
◦ Data Warehouse
◦ Business Analytics
 Automated decision systems
◦ Performance and Strategy
ISQS 3358
17
A Framework for
Business Intelligence (BI)
ISQS 3358
18
BI Applications
Main BI Topics






20
Data warehousing – Making historical data available for analytics
Data preparation – Extraction, transformation and loading
Query - a collection of specifications that enables you to focus on a
particular set of data.
Online Analytical Processing (OLAP) - a capability of information
systems that supports interactive examination of large amounts of
data from many perspectives.
Reporting - generates aggregated views of data to keep the
management informed about the state of their business.
Data mining - extraction of knowledge by utilizing software that
can isolate and identify previously unknown patterns or trends in
large amounts of data.
ISQS 3358 Business Intelligence
ISQS 3358
20
20
BI Applications

Visualizations
◦ Scorecards
◦ Dashboard
◦ Reports

Analytic applications
◦ Data mining
◦ Predictions
◦ OLAP & OLTP
ISQS 3358
21
Visualization Cases
Stock market performance 1’15”
 Ocean Environment Animation 5’13”

ISQS 3358
22
Example
ISQS 3358
23
Business Scorecards
We see this
everyday
24
ISQS 3358
24
The Purpose of a Scorecard




A scorecard should give an executive a visual
representation of the health of an organization in a
single glance
The scorecard is of sufficiently high level to represent
major business operations and their goals
The data in a scorecard should be as recent as possible
to make them more actionable
Scorecards usually contain some or all of the following
elements:
◦
◦
Key Performance Indicators (KPIs): historical values (for trend
analysis) compared to a forecast or budget amount
Rankings of different departments, locations, products, and so
forth
25
ISQS 3358
25
Dashboards
26
ISQS 3358
26
The Purpose of a Dashboard





A dashboard is designed to allow decision makers
to see a variety of data that affects their divisions
or departments
This data may be in the form of scorecards, charts,
tables, and so forth
The dashboard is generally customized for each
user
More targeted and detailed than a scorecard
The data on Dashboard
◦ Generally KPIs consists of charts and tables, and
may include scorecard elements as well
27
ISQS 3358
27
Reports
28
ISQS 3358
28
The Purpose of Custom Application
Integration

An application used by line workers may include
business intelligence without the worker realizing
what is happening
◦ A sales clerk may get a list of targeted
recommendations to make based on what the
customer is buying
◦ A loan officer may be presented with the level of
risk associated with granting a loan to a particular
customer
29
ISQS 3358
29
Analytic Applications
30
ISQS 3358
30
OLTP vs. OLAP


Online transaction processing systems (OLTP)
Systems that handle a company’s routine ongoing
business
Online analytic processing (OLAP)
An information system that enables the user, while at a
PC, to query the system, conduct an analysis, and so on.
The result is generated in seconds
ISQS 3358 Business Intelligence
ISQS 3358
31
31
BI Tools
BI Products & Providers

Traditional Providers
◦
◦
◦
◦
◦
◦

33

Microsoft
SAS
IBM
Oracle
SyBase
Business Objects
Big Data solution
providers
◦
◦
◦
◦
◦
Cloudera
Yahoo!
IBM
Amazon
Google
BI Tools Survey
ISQS 3358 Business Intelligence
ISQS 3358
33
33