Transcript Business Intelligence: Big Results with a Small Budget

Business Intelligence:
Big Results with a Small Budget
Jeff Pittges
Assistant Professor
Radford University
www.radford.edu/~jpittges
[email protected] / 540-831-5175
Industry Background
2
Going Global
The following slides were presented
by Paul Grossman at the
February 2009 NCTC Technology & Toast
ExportVirginia.org
3
THE REAL WORLD
POPULATION
4
Source: www.world mapper.org
THE REAL WORLD
CONTAINER PORTS
5
Source: www.world mapper.org
THE REAL WORLD
HIGH TECH EXPORTS1990
6
Source: www.world mapper.org
THE REAL WORLD
HIGH TECH EXPORTS 2002
7
Source: www.world mapper.org
What If
QuickTi me™ and a
T IFF (Uncompressed) decompressor
are needed to see thi s pi cture.
• 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?
8
Business Intelligence
A set of tools and techniques
that help people and companies
make better decisions
9
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
10
BI Technologies






Data Warehousing
OLAP
Executive Dashboards
Data Mining
Decision Support Systems (DSS)
Expert Systems
11
Drowning in Data
Starving for Information
12
Data Warehousing
13
Warehouses Report the Facts
• Who
• What
• When
• Where
• Why
14
OnLine Analytical Processing
OLAP
The process of slicing and dicing data:
– Drill Down
– Drill Up
– Drill Across
15
OLAP Example
Analyze quarterly sales
– Expected 10% increase in revenue
– Realized a 9.5% increase
– Why did quarterly revenue fall short
of expectations?
16
Investigate the Facts
• Why were sales short of expectations?
• When
– Compare sales in Q1 2005 to Q1 2006
• What -- Product hierarchy
• Who -- Customers
17
When
Time Dimension
Year
Quarter
Month
Week
Day
18
Time Dimension
2005
Q1
Time
Q2
Q3
Q4
2006
Q1
Q2
19
Sales by Quarter
$109.5
$100
Quarter
Q1 ‘05
 9.5%
Q1 ‘06
20
What
Product Hierarchy
Drill Down
into Department
Department
- Clothes
- Electronics
- Books
Category
Brand
Product
21
Product Dimension
2005
Q1
Time
Q2
Q3
Q4
2006
Q1
Q2
Clothes
Electronics
Books
Product
22
Sales By Department
Dept
10.3%
10.4%
Q1
‘06
Q1
‘06
Clothes
Electronics
8.7%
10%
Q1
‘06
Books
23
Drill Down into Books
Product Hierarchy
Department
Category
Brand
Product
24
2005
tb
o
Te
x
N
ov
el
s
ok
s
Product Dimension
Q1
Time
Q2
Q3
Q4
2006
Q1
Q2
Clothes
Electronics
Books
Product
25
Sales by Book Category
10.6%
6.8%
Q1
‘06
10%
Q1
‘06
Category
Novels
Textbooks
26
Who
Customer Dimension
• Age group
• Gender
• Marital status
• Occupation
• Annual income
27
Drill Down into Age Group
4.2%
10.9%
Q1
‘06
10.4%
Q1
‘06
11.1%
Q1
‘06
10%
Q1
‘06
Age
Under 25
25 - 45
46 - 65
Over 65
28
tb
o
Te
x
ov
N
om
er
el
s
ok
s
Customer Dimension
us
t
Over 65
C
46 - 65
25 - 45
Under 25
2005
Q1
Time
Q2
Q3
Q4
2006
Q1
Q2
Clothes
Electronics
Books
Product
29
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
30
Executive Dashboards
31
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
32
Example Dashboard
33
Clicking on Virginia drills down to
Inventory by City
Inventory
Level
Alexandria
Richmond
Roanoke
34
Data Mining
Knowledge Discovery
Identify patterns in your data
35
Market Basket Analysis
Identify items purchased together
36
Data Mining Tasks
• Predict
– Churn Analysis
– Increase response rate
• Estimate
– Customer satisfaction and renewal rate
• Classify
– Fraud Detection
37
Business Intelligence Tools
38
Enterprise Architecture
Reporting
OLAP
GUI
Production
Systems
Data
Warehouse
External
Data
Sources
Extract
Data
Mining
Load
Transform
39
Open Source Technologies
JasperSoft
Reporting
Reporting
MySQL
Data
Weka
Data
Warehouse
Warehouse
Mining
Mining
Pentaho
Extract
Transform
Load
Data Integration (ETL)
40
41
Service Providers
Software as a Service (SaaS)
On Demand
Hosted Applications
42
Attaain Inc.
Active Intelligence for Strategic Advantage™
Competitive Intelligence
 Real-time intelligence
 Companies, people and markets
 Easy to use, web-based system
 Customized tracking according to your
company’s lines of business
 Online dashboard
 Automated e-mail alerts
 Extensive web marketing analytics
 Cost-effective month-to-month subscription
43
RU Can Help You
• Six Concentrations
Computer Science
Software Engineering
Database
Networking
Information Systems
Web Development
• Internships and Permanent positions
• Small Project Support Center
44
References
•
•
•
•
•
Attaain
JasperSoft
MySQL
Pentaho
Weka
45
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/
46