Business Intelligence

separatesnottyΛογισμικό & κατασκευή λογ/κού

25 Νοε 2013 (πριν από 3 χρόνια και 8 μήνες)

56 εμφανίσεις

William Cox

The State of Bus. Intelligence


Many choices among BI providers



Big 4 Providers


IBM (Cognos)


Oracle (Hyperion)


Microsoft (Office + SharePoint + SQL Server)


SAP (Business Objects)


Smaller Providers


MicroStrategy


Information Builders


QlikView

Major Vendors

The State of Bus. Intelligence (Cont.)


Architecture Choices


In house servers


Typically Enterprise Level


Ability to customize code


Usually requires IT staff


Software as a Service (Cloud Based)


Typically smaller businesses w/o IT Dept.


Lower total cost of ownership



Shorter deployment time


Bus. Intelligence in Action


Restaurant Industry


One of the most successful industries to
implement business intelligence


Have been using BI for over 10 years


Some of the most successful include


Hardee's


Wendy's


Ruby Tuesday


T.G.I
. Friday's

Bus. Intelligence in Action (Cont.)


Restaurant Industry
-

Uses


Business intelligence helps make key
decisions


Which new products to add


Which existing products to abandon


Which underperforming stores to close


Renegotiating contracts with food suppliers


Identifying inefficient processes

Bus. Intelligence in Action (Cont.)


Restaurant Industry


Actual Uses


Wendy's


Used BI information to decide to accept credit cards

-
Increased Sales

-
Average credit card customer spends 35% more



Hardee's


Decided to launch Monster Thickburger (Nov 15, 2004)

-
Despite increasing health awareness among consumers

-
Devoted $7M to advertising new burger

-
Use of BI and launch of new product helped CKE
(
H
ardee’s parent company avoid bankruptcy)

Bus. Intelligence in Action (Cont.)


Restaurant Industry


Actual Uses


Ruby Tuesday


BI identified underperforming Knoxville, TN location

-
Long wait times were identified as the problem

-
Restaurant was running at full capacity

-
Kitchen layout modified

-
Resulting in a 10% Increased table turnover rate


Bus. Intelligence & Small Bus.


Options


Microsoft BI


(VIDEO)


Familiar interface (Based around Excel)


Most of the infrastructure already exists in many
companies…reducing costs


QlikView
-

PRICING


Highly Customizable


Variety of delivery platforms


Desktop


Server

-
Supports mobile access (iPhone / Android /
Blackberry)


Bus. Intelligence & Small Bus. (Cont.)


Options


MicroStrategy


Highly Customizable


Variety of delivery platforms


Desktop


Server


Cloud (Supports iPhone / Android / Blackberry)


KPI
Dashboard
(VIDEO)

(SITE)


Very Affordable $50
-

$500 / Month


Cloud
Infrastructure


Quick Deployment


Scalable


Bus. Intelligence & Small Bus. (Cont.)


Options


Microsoft
Excel &
PowerPivot

(Free)


Familiar interface


No additional costs


Limited to relatively small businesses



Sources


What is Business Intelligence


http
://
www.cbpp.uaa.alaska.edu/afef/what_is
_bi.htm



History of Business Intelligence


http
://www.youtube.com/watch?v=_
1y5jBES
LPE


Sources (Cont.)


Brain Behind the Burger


http
://
www.cbpp.uaa.alaska.edu/afef/brain_b
ehind_the_burger.htm

(http://proquest.umi.com.proxy.consortiumlib
rary.org/pqdweb?did=810376221&sid=12&F
mt=3&clientId=23364&RQT=309&VName=P
QD
)


Microsoft Business Intelligence Solution


http
://
www.youtube.com/watch?v=KIBsXUO
hn0A