Business Intelligence: Big Results with a Small Budget

1
Business IntelligenceBig Results with a Small
Budget

• Jeff Pittges
• Assistant Professor
• Radford University
• www.radford.edu/jpittgesjpittges_at_radford.edu /
  540-831-5175

2
Industry Background
3
Going Global
The following slides were presented by Paul
Grossman at the February 2009 NCTC Technology
Toast
ExportVirginia.org
4
THE REAL WORLD
POPULATION
Source www.world mapper.org
5
THE REAL WORLD
CONTAINER PORTS
Source www.world mapper.org
6
THE REAL WORLD
HIGH TECH EXPORTS1990
Source www.world mapper.org
7
THE REAL WORLD
HIGH TECH EXPORTS 2002
Source www.world mapper.org
8
What If

• You could view your business like these maps of
  the world?
• You could identify trends and compare your
  business to your competitors with respect to the
  market?
• You could see opportunities?

9
Business Intelligence
A set of tools and techniques that help people
and companies make better decisions
10
2009 Gartner Prediction
Because of lack of information, processes, and
tools, through 2012, more than 35 per- cent of
the top 5000 global companies will regularly
fail to make insightful decisions about
significant changes in their business and
markets.
http//en.wikipedia.org/wiki/Business_intelligence

11
BI Technologies

• Data Warehousing
• OLAP
• Executive Dashboards
• Data Mining
• Decision Support Systems (DSS)
• Expert Systems

12
Drowning in DataStarving for Information
13
Data Warehousing
14
Warehouses Report the Facts

• Who
• What
• When
• Where
• Why

15
OnLine Analytical Processing
OnLine Analytical Processing
OLAP

• The process of slicing and dicing data
• Drill Down
• Drill Up
• Drill Across

16
OLAP Example

• Analyze quarterly sales
• Expected 10 increase in revenue
• Realized a 9.5 increase
• Why did quarterly revenue fall short of
  expectations?

17
Investigate the Facts

• Why were sales short of expectations?
• When
• Compare sales in Q1 2005 to Q1 2006
• What -- Product hierarchy
• Who -- Customers

18
When
Time Dimension
Year
Quarter
Month
Week
Day
19
Time Dimension
20
Sales by Quarter
21
What
Product Hierarchy
22
Product Dimension
2
0
0
5
Q
1
Q
2
e
m
i
Q
3
T
Q
4
Q
1
2
0
0
6
Q
2
B
o
o
k
s
E
l
e
c
t
r
o
n
i
c
s
C
l
o
t
h
e
s
P
r
o
d
u
c
t
23
Sales By Department
24
Drill Down into Books
Product Hierarchy
Department
Brand
Product
25
Product Dimension
26
Sales by Book Category
27
Who
Customer Dimension

• Age group
• Gender
• Marital status
• Occupation
• Annual income

28
Drill Down into Age Group
29
Customer Dimension
30
Analysis

• Sales of textbooks to customers under 25
  (students) fell well short of expectations
• What should the company do?
• Increase advertisements and incentives for
  textbooks to students

31
Executive Dashboards
32
Monitoring Your Business

• Management by Objective (MBO)
• Sales -- revenue targets
• Customer Support -- customer satisfaction
• Key Performance Indicators (KPI)
• Measure performance
• Dashboard Displays KPIs
• Color coded Green Yellow Red

33
Example Dashboard
34
Clicking on Virginia drills down to Inventory by
City
35
Data Mining
Knowledge Discovery
Identify patterns in your data
36
Market Basket Analysis
Identify items purchased together
37
Data Mining Tasks

• Predict
• Churn Analysis
• Increase response rate
• Estimate
• Customer satisfaction and renewal rate
• Classify
• Fraud Detection

38
Business Intelligence Tools
39
Enterprise Architecture
40
Open Source Technologies
41
(No Transcript)
42
Service Providers
Software as a Service (SaaS)
On Demand
Hosted Applications
43
Competitive Intelligence

• Real-time intelligence
• Companies, people and markets
• Easy to use, web-based system
• Customized tracking according to your
• companys lines of business
• Online dashboard
• Automated e-mail alerts
• Extensive web marketing analytics
• Cost-effective month-to-month subscription

44
RU Can Help You

• Six Concentrations
• Internships and Permanent positions
• Small Project Support Center

45
References

• Attaain
• JasperSoft
• MySQL
• Pentaho
• Weka

46
References
Attaain http//www.attaain.com/
JasperSoft http//www.jaspersoft.com/
MySQL http//www.mysql.com/
Pentaho http//www.pentaho.com/
Weka http//www.cs.waikato.ac.nz/ml/weka/