160 likes | 264 Views
Slides for JackBe. Wayne Eckerson Principal Consultant, BI Leader Consulting. NetApp – Enterprise BI Framework. Graphical Data . Dimensional Data. Detailed Data. Transactional Data. Enterprise Analytics. Functional Analytics. Sales, Marketing, Product Ops, Finance, Global Services ….
E N D
Slides for JackBe Wayne Eckerson Principal Consultant, BI Leader Consulting
NetApp– Enterprise BI Framework Graphical Data Dimensional Data Detailed Data Transactional Data Enterprise Analytics Functional Analytics Sales, Marketing, Product Ops, Finance, Global Services … Measure Performance Improve Accountability Role-Based Analytics Sales Rep, Account Manager, DM, RM, SE, Marketing analytics, Financial analytics, Security Admin, IT Admin, Audit, Usage Tracking… Subject Area Analytics Cross-sell, Up Sell, Account Performance, end customer, Period Close performance, Hourly Projected Booking Analytics… 360 Degree Views Customer, Partner, Product, Service, Sales Rep, employee, user… Increase Productivity Unified BI platform: Build once, deploy multiple instances Slide courtesy of NetApp 2
Functionality Monitor Analyze Drill thru MAD Framework Users Executives/ Managers Graphical Metrics Data Analysts Summarized Dimensional Data Workers Detailed Data Detailed Transactional Data
“Drive the business” Analytics CEO,CFO, CMO, etc. Enterprise BI vendors Oracle, SAP, IBM, SAS “BI as foundation technology” Low cost BI vendors Microsoft, QlikTech, Open Source, Cloud BI (SaaS) “BI for the mid-market” Market Evolution Cloud “Improve the business” Performance Management Mobile “Use the data” SOA/Web Services Business Intelligence “Get the data” Web Data Warehousing 2007 Mega M&A: OracleHyperion SAPBusiness Objects IBM Cognos Client/Server 1990s 2000s 2010
“What will happen?” “What’s happening?” “Why did it happen?” “What happened?” Waves of BI = Reporting High = Analytics Business Value Prediction Monitoring Analysis Reporting Dashboards, Scorecards Statistics, data mining, optimization Static & Interactive Reports Query, Excel, OLAP, Visual discovery Low 1980s 2000s 2010s (mainstream) 1990s
Pros: -Alignment -Consistency Cons: -Hard to build -Politically charged -Hard to change - Expensive -“Schema Heavy” TOP DOWN- “Business Intelligence” Corporate Objectives and Strategy Reporting & Monitoring (Casual Users) Non-volatile data DW Architecture Predefined metrics Reports Beget Analysis Analysis Begets Reports Pros: -Quick to build - Politically uncharged - Easy to change - Low cost Cons: -Alignment -Consistency --“Schema Light” Volatile data Ad hoc queries And data Analytics Architecture Analysis and Prediction (Power Users) Processes and Projects BOTTOM UP – “Analytics Intelligence”
Pros: -Alignment -Consistency Cons: -Hard to build -Politically charged -Hard to change - Expensive -“Schema Heavy” TOP DOWN- “Business Intelligence” Corporate Objectives and Strategy Reporting & Monitoring (Casual Users) Non-volatile data DW Architecture Predefined metrics Super Users Self-Service BI Pros: -Quick to build - Politically uncharged - Easy to change - Low cost Cons: -Alignment -Consistency --“Schema Light” Volatile data Ad hoc queries And data Analytics Architecture Analysis and Prediction (Power Users) Processes and Projects BOTTOM UP – “Analytics Intelligence”
Pros: -Alignment -Consistency Cons: -Hard to build -Politically charged -Hard to change - Expensive -“Schema Heavy” TOP DOWN- “Business Intelligence” Corporate Objectives and Strategy Reporting & Monitoring (Casual Users) Non-volatile data DW Architecture Predefined metrics Semantic Layer/Mashboards Visual Analysis/Direct Connect Dashboards Pros: -Quick to build - Politically uncharged - Easy to change - Low cost Cons: -Alignment -Consistency --“Schema Light” Volatile data Ad hoc queries And data Analytics Architecture Analysis and Prediction (Power Users) Processes and Projects BOTTOM UP – “Analytics Intelligence”
Strategic Dashboard Executives Tactical Dashboard Managers/Analysts Operational Dashboard Operations Staff Mapping Users to Dashboards
Dashboard Usage by Type (Deployed) Based on 685 respondents, 2009
To what degree has the dashboard had a positive impact on the business? Based on 685 respondents, 2009