SSWUG Expo Part 4 Power Up Your Pivots
Beyond the desktop PowerPivot in your business infrastructure
[email protected] Twitter: donalddotfarmer
The BI Continuum
Personal
Team
Corporate
Personal Flexible
Team
Corporate Formal
Personal Self-Service
Team
Corporate Corporate
Business intelligence & decision support
Strategic Value
Number of Decisions
Strategic Value
Number of Decisions
Strategic Value
Decision Flow
Number of Decisions
Tactical
Strategic Value
Number of Decisions
Strategic
Tactical
Strategic Value
Number of Decisions
Strategic
Tactical
Strategic Value
Number of Decisions
Operational
Strategic
Strategic Value
Dashboards Scorecards
Number of Decisions
Strategic
Strategic Value
Tactical
Dashboards Reports, Excel, Scorecards PowerPivot
Number of Decisions
Strategic
Strategic Value
Tactical
Dashboards Reports, Excel, Scorecards PowerPivot
Operational
Embedded reports, analytic APIs
Number of Decisions
FY1
FY2
FY3
FY4
FY5
FY1
FY2
FY3
FY4
FY5
FY1
FY2
FY3
FY4
FY5
Classic Business Intelligence
FY1
FY2
FY3
FY4
FY5
Classic Business Intelligence
Self-Service Business Intelligence FY1
FY2
FY3
FY4
FY5
FY1
FY2 CY1
FY3 CY2
FY4 CY3
FY5 CY4
FY1
FY2 CY1
FY3 CY2
FY4 CY3
FY5 CY4
FY1
FY2 CY1
FY3 CY2
FY4 CY3
FY5 CY4
Classic Business Intelligence
Self-Service Business Intelligence FY1
FY2 CY1
FY3 CY2
FY4 CY3
FY5 CY4
Business intelligence & data governance
IT Oversight
Organizational Alignment
IT Owned Data Warehouse & Reports
IT Oversight
Organizational Alignment
IT Owned Data Warehouse & Reports
IT Oversight
Spreadsheets & Desktop Databases
Organizational Alignment
IT Owned Data Warehouse & Reports
IT Oversight
PowerPivot
Spreadsheets & Desktop Databases
Organizational Alignment
IT Owned Data Warehouse & Reports Departmental Data Marts
IT Oversight
PowerPivot
Spreadsheets & Desktop Databases
Organizational Alignment
Master Data & Data Quality IT Owned Data Warehouse & Reports Departmental Data Marts
IT Oversight
PowerPivot
Spreadsheets & Desktop Databases
Organizational Alignment
Collaboration
IT Oversight
Organizational Alignment
Business intelligence & analysis
Softwarederived Insight
Strong
Hypothesis
Weak
Softwarederived Insight
Reporting
Strong
Hypothesis
Weak
Softwarederived Insight
Ad-hoc Reporting
Reporting
Strong
Hypothesis
Weak
Softwarederived Insight
OLAP Ad-hoc Reporting
Reporting
Strong
Hypothesis
Weak
Softwarederived Insight
OLAP Ad-hoc Reporting
Reporting
Strong
Spreadsheet
Hypothesis
Weak
Data Mining
Softwarederived Insight
OLAP Ad-hoc Reporting
Reporting
Strong
Spreadsheet
Hypothesis
Weak
Monitoring
Softwarederived Insight
Data Mining
OLAP Ad-hoc Reporting
Reporting
Strong
Spreadsheet
Hypothesis
Weak
Monitoring
Data Mining
Analytics Softwarederived Insight
OLAP Ad-hoc Reporting
Reporting
Strong
Spreadsheet
Hypothesis
Weak
Monitoring
Data Mining
Performance Point Monitoring & Analytics
Analytics
Softwarederived Insight
OLAP Ad-hoc Reporting
Reporting
Strong
Spreadsheet
Hypothesis
Weak
Monitoring
Data Mining
Analytics Softwarederived Insight
OLAP
Report Ad-hoc Builder Reporting Reporting
Strong
Spreadsheet
Hypothesis
Weak
Monitoring
Data Mining
Analytics Softwarederived Insight
OLAP
Data Mining Add-ins
Ad-hoc Reporting
Reporting
Strong
Spreadsheet
Hypothesis
Weak
Monitoring
Data Mining
Analytics Softwarederived Insight
OLAP
PowerPivot Ad-hoc Reporting
Reporting
Strong
Spreadsheet
Hypothesis
Weak
How are decisions made? How is data governed? How is data analysed?
PowerPivot Adoption IW-led • • • •
Business users outgrow Excel Discover PowerPivot Attracted by powerful analytics Need server for collaboration
IT-led • • • • •
Pressure for analytics Resource-constrained Provision server for collaboration Provision data Roll out PowerPivot
Contact
[email protected]
[email protected] Twitter: donalddotfarmer
The BI Continuum
Personal
Team
Corporate
Personal Flexible
Team
Corporate Formal
Personal Self-Service
Team
Corporate Corporate
Business intelligence & decision support
Strategic Value
Number of Decisions
Strategic Value
Number of Decisions
Strategic Value
Decision Flow
Number of Decisions
Tactical
Strategic Value
Number of Decisions
Strategic
Tactical
Strategic Value
Number of Decisions
Strategic
Tactical
Strategic Value
Number of Decisions
Operational
Strategic
Strategic Value
Dashboards Scorecards
Number of Decisions
Strategic
Strategic Value
Tactical
Dashboards Reports, Excel, Scorecards PowerPivot
Number of Decisions
Strategic
Strategic Value
Tactical
Dashboards Reports, Excel, Scorecards PowerPivot
Operational
Embedded reports, analytic APIs
Number of Decisions
FY1
FY2
FY3
FY4
FY5
FY1
FY2
FY3
FY4
FY5
FY1
FY2
FY3
FY4
FY5
Classic Business Intelligence
FY1
FY2
FY3
FY4
FY5
Classic Business Intelligence
Self-Service Business Intelligence FY1
FY2
FY3
FY4
FY5
FY1
FY2 CY1
FY3 CY2
FY4 CY3
FY5 CY4
FY1
FY2 CY1
FY3 CY2
FY4 CY3
FY5 CY4
FY1
FY2 CY1
FY3 CY2
FY4 CY3
FY5 CY4
Classic Business Intelligence
Self-Service Business Intelligence FY1
FY2 CY1
FY3 CY2
FY4 CY3
FY5 CY4
Business intelligence & data governance
IT Oversight
Organizational Alignment
IT Owned Data Warehouse & Reports
IT Oversight
Organizational Alignment
IT Owned Data Warehouse & Reports
IT Oversight
Spreadsheets & Desktop Databases
Organizational Alignment
IT Owned Data Warehouse & Reports
IT Oversight
PowerPivot
Spreadsheets & Desktop Databases
Organizational Alignment
IT Owned Data Warehouse & Reports Departmental Data Marts
IT Oversight
PowerPivot
Spreadsheets & Desktop Databases
Organizational Alignment
Master Data & Data Quality IT Owned Data Warehouse & Reports Departmental Data Marts
IT Oversight
PowerPivot
Spreadsheets & Desktop Databases
Organizational Alignment
Collaboration
IT Oversight
Organizational Alignment
Business intelligence & analysis
Softwarederived Insight
Strong
Hypothesis
Weak
Softwarederived Insight
Reporting
Strong
Hypothesis
Weak
Softwarederived Insight
Ad-hoc Reporting
Reporting
Strong
Hypothesis
Weak
Softwarederived Insight
OLAP Ad-hoc Reporting
Reporting
Strong
Hypothesis
Weak
Softwarederived Insight
OLAP Ad-hoc Reporting
Reporting
Strong
Spreadsheet
Hypothesis
Weak
Data Mining
Softwarederived Insight
OLAP Ad-hoc Reporting
Reporting
Strong
Spreadsheet
Hypothesis
Weak
Monitoring
Softwarederived Insight
Data Mining
OLAP Ad-hoc Reporting
Reporting
Strong
Spreadsheet
Hypothesis
Weak
Monitoring
Data Mining
Analytics Softwarederived Insight
OLAP Ad-hoc Reporting
Reporting
Strong
Spreadsheet
Hypothesis
Weak
Monitoring
Data Mining
Performance Point Monitoring & Analytics
Analytics
Softwarederived Insight
OLAP Ad-hoc Reporting
Reporting
Strong
Spreadsheet
Hypothesis
Weak
Monitoring
Data Mining
Analytics Softwarederived Insight
OLAP
Report Ad-hoc Builder Reporting Reporting
Strong
Spreadsheet
Hypothesis
Weak
Monitoring
Data Mining
Analytics Softwarederived Insight
OLAP
Data Mining Add-ins
Ad-hoc Reporting
Reporting
Strong
Spreadsheet
Hypothesis
Weak
Monitoring
Data Mining
Analytics Softwarederived Insight
OLAP
PowerPivot Ad-hoc Reporting
Reporting
Strong
Spreadsheet
Hypothesis
Weak
How are decisions made? How is data governed? How is data analysed?
PowerPivot Adoption IW-led • • • •
Business users outgrow Excel Discover PowerPivot Attracted by powerful analytics Need server for collaboration
IT-led • • • • •
Pressure for analytics Resource-constrained Provision server for collaboration Provision data Roll out PowerPivot
Contact
[email protected]
