140 likes | 262 Views
William Cox. Business Intelligence. 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.
E N D
William Cox Business Intelligence
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
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 (Hardee’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=_1y5jBESLPE
Sources (Cont.) • Brain Behind the Burger • http://www.cbpp.uaa.alaska.edu/afef/brain_behind_the_burger.htm (http://proquest.umi.com.proxy.consortiumlibrary.org/pqdweb?did=810376221&sid=12&Fmt=3&clientId=23364&RQT=309&VName=PQD ) • Microsoft Business Intelligence Solution • http://www.youtube.com/watch?v=KIBsXUOhn0A