Business Intelligence Big Results with a Small Budget - Roanoke 商业智能大结果和一个小的预算-罗诺克.pptVIP

Business Intelligence:Big Results with a Small Budget Jeff Pittges Assistant Professor Radford University /~jpittgesjpittges@ / 540-831-5175 Industry Background Going Global 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 2009 Gartner Prediction 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 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 Sales by Quarter What Product Dimension Sales By Department Drill Down into Books Product Dimension Sales by Book Category Who Age group Gender Marital status Occupation Annual income 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 Green Yellow Red Example Dashboard Data Mining Market Basket Analysis Data Mining Tasks Predict Churn Analysis Increase response rate Estimate Customer satisfaction and renewal rate Classify Fraud Detection Bus