1 / 46

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 jpittges@radford.edu / 540-831-5175. Industry Background. Going Global. The following slides were presented by Paul Grossman at the

noreen
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Business Intelligence:Big Results with a Small Budget Jeff Pittges Assistant Professor Radford University www.radford.edu/~jpittgesjpittges@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. $109.5 9.5% $100 Quarter Q1 ‘05 Q1 ‘06 Sales by Quarter

  21. Drill Down into Department Department • Clothes • Electronics • Books Category Brand Product What Product Hierarchy

  22. 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

  23. 10.4% 10.3% 8.7% Q1 ‘06 Q1 ‘06 10% Q1 ‘06 Dept Clothes Electronics Books Sales By Department

  24. Category Drill Down into Books Product Hierarchy Department Brand Product

  25. Product Dimension

  26. 6.8% 10.6% Q1 ‘06 10% Q1 ‘06 Category Novels Textbooks Sales by Book Category

  27. Who Customer Dimension • Age group • Gender • Marital status • Occupation • Annual income

  28. 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

  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 GreenYellowRed

  33. Example Dashboard

  34. Inventory Level Alexandria Richmond Roanoke 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. GUI Reporting OLAP Production Systems Data Warehouse External Data Sources Extract Load Data Mining Transform Enterprise Architecture

  40. Pentaho MySQL JasperSoft Weka Reporting Data Integration (ETL) Warehouse Reporting Mining Data Warehouse Data Mining Extract Transform Load Open Source Technologies

  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. Computer Science Database Information Systems Software Engineering Networking Web Development RU Can Help You • Six Concentrations • Internships and Permanent positions • Small Project Support Center

  44. References • Attaain • JasperSoft • MySQL • Pentaho • Weka

  45. References

More Related