Business intelligence big results with a small budget
This presentation is the property of its rightful owner.
Sponsored Links
1 / 46

Business Intelligence: Big Results with a Small Budget PowerPoint PPT Presentation


  • 57 Views
  • Uploaded on
  • Presentation posted in: General

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. Going Global. The following slides were presented by Paul Grossman at the

Download Presentation

Business Intelligence: Big Results with a Small Budget

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Business Intelligence:Big Results with a Small Budget

Jeff Pittges

Assistant Professor

Radford University

[email protected]/ 540-831-5175


Industry Background


Going Global

The following slides were presented

by Paul Grossman at the

February 2009 NCTC Technology & Toast

ExportVirginia.org


THE REAL WORLD

POPULATION

Source: www.world mapper.org


THE REAL WORLD

CONTAINER PORTS

Source: www.world mapper.org


THE REAL WORLD

HIGH TECH EXPORTS1990

Source: www.world mapper.org


THE REAL WORLD

HIGH TECH EXPORTS 2002

Source: www.world mapper.org


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?


Business Intelligence

A set of tools and techniques

that help people and companies

make better decisions


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


BI Technologies

  • Data Warehousing

  • OLAP

  • Executive Dashboards

  • Data Mining

  • Decision Support Systems (DSS)

  • Expert Systems


Drowning in DataStarving for Information


Data Warehousing


Warehouses Report the Facts

  • Who

  • What

  • When

  • Where

  • Why


OnLine Analytical Processing

OnLine Analytical Processing

OLAP

The process of slicing and dicing data:

  • Drill Down

  • Drill Up

  • Drill Across


OLAP Example

Analyze quarterly sales

  • Expected 10% increase in revenue

  • Realized a 9.5% increase

  • Why did quarterly revenue fall short of expectations?


Investigate the Facts

  • Why were sales short of expectations?

  • When

    • Compare sales in Q1 2005 to Q1 2006

  • What -- Product hierarchy

  • Who -- Customers


When

Time Dimension

Year

Quarter

Month

Week

Day


Time Dimension


$109.5

9.5%

$100

Quarter

Q1 ‘05

Q1 ‘06

Sales by Quarter


Drill Down

into Department

Department

  • Clothes

  • Electronics

  • Books

Category

Brand

Product

What

Product Hierarchy


Product Dimension

2

0

0

5

Q

1

Q

2

e

m

i

Q

3

T

Q

4

2

0

0

6

Q

1

Q

2

C

l

o

t

h

e

s

E

l

e

c

t

r

o

n

i

c

s

B

o

o

k

s

P

r

o

d

u

c

t


10.4%

10.3%

8.7%

Q1

‘06

Q1

‘06

10%

Q1

‘06

Dept

Clothes

Electronics

Books

Sales By Department


Category

Drill Down into Books

Product Hierarchy

Department

Brand

Product


Product Dimension


6.8%

10.6%

Q1

‘06

10%

Q1

‘06

Category

Novels

Textbooks

Sales by Book Category


Who

Customer Dimension

  • Age group

  • Gender

  • Marital status

  • Occupation

  • Annual income


4.2%

10.9%

10.4%

11.1%

Q1

‘06

Q1

‘06

Q1

‘06

10%

Q1

‘06

Age

Under 25

25 - 45

46 - 65

Over 65

Drill Down into Age Group


Customer Dimension


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


Executive Dashboards


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 GreenYellowRed


Example Dashboard


Inventory

Level

Alexandria

Richmond

Roanoke

Clicking on Virginia drills down to

Inventory by City


Data Mining

Knowledge Discovery

Identify patterns in your data


Market Basket Analysis

Identify items purchased together


Data Mining Tasks

  • Predict

    • Churn Analysis

    • Increase response rate

  • Estimate

    • Customer satisfaction and renewal rate

  • Classify

    • Fraud Detection


Business Intelligence Tools


GUI

Reporting

OLAP

Production

Systems

Data

Warehouse

External

Data

Sources

Extract

Load

Data

Mining

Transform

Enterprise Architecture


Pentaho

MySQL

JasperSoft

Weka

Reporting

Data Integration (ETL)

Warehouse

Reporting

Mining

Data

Warehouse

Data

Mining

Extract

Transform

Load

Open Source Technologies


Service Providers

Software as a Service (SaaS)

On Demand

Hosted Applications


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


Computer Science

Database

Information Systems

Software Engineering

Networking

Web Development

RU Can Help You

  • Six Concentrations

  • Internships and Permanent positions

  • Small Project Support Center


References

  • Attaain

  • JasperSoft

  • MySQL

  • Pentaho

  • Weka


References


  • Login