wisdom of crowds webinar deck
TRANSCRIPT
Connect. Describe. Explore.
Wisdom of Crowds WebinarWisdom of Crowds Webinar
— This webinar will be recorded
— We will take questions at the end
Welcome & Webinar Overview
Russ GarnerData Analyst
Looker
Howard DresnerChief Research Officer
Dresner Advisory Services
Meet our Presenters
Dresner Advisory Services
Wisdom of Crowds®
Copyright 2016 Dresner Advisory Services, LLCwww.dresneradvisory.com
Agenda• Success with Business Intelligence• State of Data and Action on Insight• Targets, Objectives & Penetration• Prioritized Technologies and Initiatives • Industry Ratings
Copyright 2016 Dresner Advisory Services, LLC
Success with Business Intelligence
Copyright 2016 Dresner Advisory Services, LLC
Copyright 2016 Dresner Advisory Services, LLC
Successful Somewhat successful Somewhat unsuccessful Unsuccessful0%
10%
20%
30%
40%
50%
60%
35%
53%
10%
2%
38%
50%
9%
3%
Success with Business Intelligence 2015 - 2016
2015 2016
Why BI Succeeds
Copyright 2016 Dresner Advisory Services, LLC
Why BI Fails
Copyright 2016 Dresner Advisory Services, LLC
The State of Data
Copyright 2016 Dresner Advisory Services, LLC
Copyright 2016 Dresner Advisory Services, LLC
0%5%
10%15%20%25%30%35%40%45%
Business Intelligence and The State of Data 2015 to 2016
20152016
Copyright 2016 Dresner Advisory Services, LLC
Successful Somewhat successful Somewhat unsuccessful Unsuccessful0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
Business Intelligence and the State of Data_x000d_ by BI Success
Data as "truth" - A common view of enter-prise data is available with common appli-cation of data, filters, rules, and semanticsA common view of enterprise data is avail-able. However, parochial views and se-mantics are used to support specific posi-tionsConsistent data is available at a departmen-tal level. Conflicting, functional views of data causes confusion and disagreementWe have multiple, inconsistent data sources with conflicting semantics and data. Infor-mation is generally unreliable and distrusted
Action on Insight
Copyright 2016 Dresner Advisory Services, LLC
Copyright 2016 Dresner Advisory Services, LLC
“Closed-loop processes for action” - Information is shared, teams
work to process and act in a timely fashion. No formal boundaries
Ad hoc (informal) action on insights across functions
Uncoordinated/ parochial action (sometimes at the expense of
others)
Insights are rarely leveraged0%
10%
20%
30%
40%
50%
60%
70%
24%
62%
10%
4%
26%
60%
11%
4%
28%
55%
12%
5%
Business Intelligence and Action on Insight 2014 - 2016
201420152016
Copyright 2016 Dresner Advisory Services, LLC
Successful Somewhat successful Somewhat unsuccessful Unsuccessful0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
Business Intelligence and Action on Insight _x000d_ by BI Success
"Closed loop" - Information is shared, teams work to process and act in a timely fashion. No formal boundariesAd hoc (informal) action on insights across functionsUncoordinated/ parochial action (sometimes at the expense of others)Insights are rarely leveraged
User Targets for Business Intelligence
Copyright 2016 Dresner Advisory Services, LLC
Copyright 2016 Dresner Advisory Services, LLC
Execu
tives
Middle Managers
Line M
anagers
Individual C
ontributors
and Professionals
Customers
Supplie
rs0%
10%
20%
30%
40%
50%
60%
70%
80%
Targeted Users for Business Intelligence 2014 - 2016
201420152016
Copyright 2016 Dresner Advisory Services, LLC
Successful Somewhat successful Somewhat unsuccessful Unsuccessful0%
10%
20%
30%
40%
50%
60%
70%
80%
Success With Business Intelligence by Targeted Users
Executives Middle managers Line managers Individual contributors & professionals Customers Suppliers
Business Intelligence Objectives
Copyright 2016 Dresner Advisory Services, LLC
Copyright 2016 Dresner Advisory Services, LLC
Better decision-making
Improved operational efficiency
Growth in revenues
Increased competitive advantage
Enhanced customer service
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% Business Intelligence Objectives
Critical Very important Important Somewhat important Unimportant
Copyright 2016 Dresner Advisory Services, LLC
Better decision making
Improved operational efficiency
Growth in revenuesIncreased competitive advantage
Enhanced customer service
1
3
5
Success with Business Intelligence by BI Objectives
Successful Somewhat successful Somewhat unsuccessful Unsuccessful
Business Intelligence Penetration
Copyright 2016 Dresner Advisory Services, LLC
Copyright 2016 Dresner Advisory Services, LLC
Under 10% 11 - 20% 21 - 40% 41 - 60% 61 - 80% 81% or more0%
5%
10%
15%
20%
25%
30%
35%
40%
Business Intelligence Penetration 2015 to 2016
20152016
Copyright 2016 Dresner Advisory Services, LLC
In 36 months
In 24 months
In 12 months
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
Expansion Plans for Business Intelligence through 2019
81% or more 61 - 80% 41 - 60% 21 - 40% 11 - 20% Under 10%
Copyright 2016 Dresner Advisory Services, LLC
Succe
ssful
Somewhat su
ccessf
ul
Somewhat u
nsuccessf
ul
Unsucce
ssful
0%10%20%30%40%50%60%70%80%90%
100%
Penetration of Business Intelligence Solutions Today by BI Success
81% or more61 - 80%41 - 60%21 - 40%11 - 20%Under 10%
Prioritized Technology and Initiatives
Copyright 2016 Dresner Advisory Services, LLC
Copyright 2016 Dresner Advisory Services, LLC
ReportingDashboards
End user "self service"Advanced visualization
Data discoveryData warehousing
Data mining, advanced algorithms, predictiveIntegration with operational processes
Data story tellingEnterprise planning/budgeting
Mobile device supportEmbedded BI (contained within an application, portal, etc.)
GovernanceCollaborative support for group-based analysis
End user data preparation and blendingSearch-based interface
Software-as-a-service and cloud computingIn-memory analysis
Ability to write to transactional applicationsLocation intelligence/analytics
Big Data (e.g., Hadoop)Pre-packaged vertical/functional analytical applications
Text analyticsStreaming data analysis
Open source softwareSocial media analysis (SocialBI)
Cognitive BI (e.g., Artificial Intelligence-based BI)Complex event processing (CEP)
Internet of things (IoT)Edge computing
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% Technologies and Initiatives Strategic to Business Intelligence
Critical Very important Important Somewhat important Not important
Copyright 2016 Dresner Advisory Services, LLC
Critical; 40.1%
Very important; 36.4%
Important; 16.8%
Somewhat important; 5.6% Not important; 1.2%
Importance of Governing BI Content Creation and Sharing
Copyright 2016 Dresner Advisory Services, LLC
Completely successful Somewhat successful Somewhat unsuccessful Unsuccessful0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
Importance of Governing BI Content Creation and Sharing by Success with BI
CriticalVery importantImportantSomewhat importantNot important
Copyright 2016 Dresner Advisory Services, LLC
Define levels of access to shared documents, data, etc.
Integration with access/identity management systems
Ability to "certify" official versions of shared metadata, data, etc.
Ability to analyze and audit decision processes
APIs available to program functionality and data/metadata functions and data
Track usage of models, documents, etc. to streamline/optimize
Support for data lineage and impact analysis
Content check in/out with promote-ability
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
BI Content Governance Feature Requirements
Not important Somewhat important Important Very important Critical Don't know
Copyright 2016 Dresner Advisory Services, LLC
Yes. We use cloud-based BI/analytics
today; 25%
We are currently evaluating cloud-based BI/analytics software; 11%
We may use cloud-based BI/analytics in
the future; 26%
No. We have no plans to use cloud-based
BI/analytics at all; 38%
Plans to Use Cloud BI
Copyright 2016 Dresner Advisory Services, LLC
Successful Somewhat successful Somewhat unsuccessful Unsuccessful0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
Plans to Use Cloud BI by Success with BI
Yes. We use cloud-based BI/analytics today No. We have no plans to use cloud-based BI/analytics at all.We are currently evaluating cloud-based BI/analytics software We may use cloud-based BI/analytics in the future
Copyright 2016 Dresner Advisory Services, LLC
2012 2013 2014 2015 20160%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
13%17% 20%
24%29%7%
6%6%
9%9%
8%6%
6%
10%9%
73% 71% 68%
57%53%
Plans for Public Cloud BI 2012 to 2016
No plansNext yearThis yearToday
Copyright 2016 Dresner Advisory Services, LLC
Advanced visualizationAd-hoc query
Personalized dashboardsEnd-user "self service"
Data integration/data quality tools/ETLData discovery
Production reportingData mining and advanced algorithms
Search interfaceEnd-user data blending or "mashups"
Location intelligence/analyticsIn-memory support
Pre-packaged vertical/functional analytical applicationsCollaborative support for group-based analysis
Big data (e.g., Hadoop) SupportAbility to write to transactional applications
Complex event processing (CEP)Text analytics
Social media analysis (SocialBI)
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
Cloud BI Feature Requirements
Critical Very important Important Somewhat important Unimportant
Industry Ratings
Copyright 2016 Dresner Advisory Services, LLC
Sales: professionalismProduct knowledgeUnderstanding our business/needs
Responsiveness
Flexibility/accommodation
Business practices
Contractual terms and conditions
Follow up after the sale
Value
Product: robustness/ sophistication of technology
Completeness of functionality
Reliability of technology
Scalability
Integration of components within product
Integration with third-party technologiesOverall usability
Ease of installationEase of administrationCustomization and extensibility
Ease of upgrade/migration to new versions
Online training, forums and documentation
Support: professionalism
Product knowledge
Responsiveness
Continuity of personnel
Time to resolve problems
Consult: professionalism
Product knowledge
Experience
Continuity
ValueIntegrity
Recommend
0.00.51.01.52.02.53.03.54.04.55.0
Looker 2016 Performance
Looker 2016 Overall Sample
Copyright 2016 Dresner Advisory Services, LLC
BI Customer Experience Model
Copyright 2016 Dresner Advisory Services, LLC
BI Vendor Credibility Model
Copyright 2016 Dresner Advisory Services, LLC
Dresner Advisory Services
Wisdom of Crowds®
Copyright 2016 Dresner Advisory Services, LLCwww.dresneradvisory.com
Connect. Describe. Explore.
Wisdom of Crowds WebinarRuss GarnerData Analyst
Traditional Approach
SUMMARY
OLAP / Data Summaries
SILOEDRestricted Q&A
LIMITEDDIFFICULT & CUMBERSOMEETL - Heavy Transformation
END USERBI TEAMETL TEAM EDW TEAM
WANT TO ASK NEW QUESTIONS?
A B
?C
I
G
J
M
H
N
F
L
D
K
Q
BZ C
P
E
R
S
Q
F
X
EB
Z
A
X
EVENT DATA
TRANSACTIONAL DATA
% of Company Users
Technical Effort
Traditional BI Implementation Curve
Implementation
Adoption Maturity
Ideal BI Implementation Curve
Technical Effort
% of Company Users
Implementation
Adoption Maturity
A New Approach to BI
Transformation at Query
AGILE/SELF-SERVICE
3RD PARTY APP
API
ANY DEVICE
Anywhere for AnyoneWEB-BASEDCONSOLIDATED
Simple Extract & Load
MPP | REDSHIFT | MYSQL
Data Modeling LayerGOVERNED
DATA TEAM END USERSINNOVATION
I
G
M
H
N
FD
K
Q
A
C
P
E
R
S
Q
T
U W
X
G
H
Q Z
H U
S
A
Z
K
TRANSACTIONAL DATA
EVENTDATA
Z
B
QA A Z
LookML
The Looker Approach
Maturity
Ideal BI Implementation Curve
Technical Effort
% of Company Users
Implementation
Adoption Maturity
100% In Database
Leverage all your dataAvoid summarizing or
moving it
Modern Web Architecture
Access from anywhereShare and collaborate
Extend to anyone
LookML Intelligent Modeling Layer
Describe the dataCreate reusable and
shareable business logic
The Technical Pillars That Make It Possible
Let’s See The Demo!
Q&A
THANK YOU FOR JOINING
Recording and slides will be posted.
We will email you the links tomorrow.
See you next time!
Next from Looker Webinars: BigQuery +
Looker at Infectious Media
See how Looker works on your data.
Visit looker.com/free-trial or email
Connect. Describe. Explore.
Wisdom of Crowds WebinarThank You!