Download - Tmag preso, mar 2012 v1.2
![Page 1: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/1.jpg)
Success Through Data VisualizationBuilding an analytics practice
Kevin Hill, Market Intelligence
March 2012
![Page 2: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/2.jpg)
Agenda
1) About me
2) Market Intelligence at Autodesk
3) Best Practices: Data visualization
2
![Page 3: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/3.jpg)
Cleveland, OH
3
![Page 4: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/4.jpg)
Equity Research
• Market research
• Quantitative analysis
• Qualitative analysis
• Technology trends
4
2000 – 2005
![Page 5: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/5.jpg)
5
![Page 6: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/6.jpg)
“The company that makes AutoCAD”
Design Software for:
Engineering
Architecture
Construction
Manufacturing
Film, TV, Games
6
![Page 7: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/7.jpg)
7
![Page 8: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/8.jpg)
8
![Page 9: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/9.jpg)
9
![Page 10: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/10.jpg)
10
![Page 11: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/11.jpg)
11
![Page 12: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/12.jpg)
12
![Page 13: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/13.jpg)
13
![Page 14: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/14.jpg)
Agenda
1) About me
2) Market Intelligence at Autodesk
3) Best Practices: Data visualization
14
![Page 15: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/15.jpg)
Early Analytics Practice: 2006 – 2008Immature
15
MBA Internship
Market Sizing
Ad-hoc analysisMarketing
Benchmarking
5
![Page 16: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/16.jpg)
16
A pessimist sees the difficulty
in every opportunity.An optimist sees the opportunity in every
difficulty.Winston Churchill
![Page 17: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/17.jpg)
Analytics Priorities: 2009 – 2010Early growth
CustomerSegmentation
17
Divested• Marketing benchmarking• Syndicated research
Strategic Questions
10
Data Structure
![Page 18: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/18.jpg)
Strategic Business Questions
1) How large is each vertical market we serve?
2) What verticals bring in what % of revenue?
3) What % of revenue comes from large, medium, small businesses?
4) How concentrated is our revenue?
5) Which customers are the best targets?
18
![Page 19: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/19.jpg)
Key Challenges
1) Poor data
2) Poor management support
3) Status quo
19
![Page 20: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/20.jpg)
Current Priorities: 2011 – 2013Maturing practice
20
25
Business PartnerModel
OperationalPartnerships
Predictive Analytics
![Page 21: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/21.jpg)
Segmentationframeworks
My RoleSr. Manager, Account Intelligence
Stakeholders
• Sales
• Marketing
• Industry strategy
• CEO & CFO
21
Channel Partner Value
Strategic Analysis
Investment planning
$
![Page 22: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/22.jpg)
Overcoming Challenges
1) Poor dataa. Entrepreneurial spiritb. Improved resources
2) Poor management supporta. Answer their business questions
3) Status quoa. Challenge it. Be a leader!
22
![Page 23: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/23.jpg)
Eas
yD
iffic
ult
More
Less
Less
Sta
keh
old
er I
mp
lem
enta
tio
n
More
Potential for Wrong Decisions
AVOIDANCEI’d rather make decisions on
gut feel
BI Adoption
DENIALAre people really using this data
stuff?
ACCEPTANCEI know I should be using data,
but I don’t know how
LEARNINGWow, there is a ton of data available. Now
I’m even more confused
OPERATIONALI wouldn’t make a big decision without data-
driven insights
ENGAGEMENTI’ve seen others use
compelling analysis. Now I see how I could use it to make better decisions
ADOPTIONI’ve used data
analysis to plan or set goals
23
Adoption of Business IntelligencePersona evolution
![Page 24: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/24.jpg)
Agenda
1) About me
2) Market Intelligence at Autodesk
3) Best Practices: Data visualization
24
![Page 25: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/25.jpg)
25
Edward Tufte• The Visual Display of Quantitative Information• Visual Explanations• Envisioning Information• Beautiful Evidence
Resources
Dan Roam• Back of the Napkin
Cliff Atkinson• Beyond Bullet Points
![Page 26: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/26.jpg)
26
Know your audience!• What is important to them?
• What is their appetite for detail?
Ask beforehand
The Most Important Thing
![Page 27: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/27.jpg)
27
Who• Who did the work?• Who did I work with? (Partners, stakeholders)
What• What did I learn (Analysis)• What did I do? (Methodology)
When• When is the presentation given?• When is the data from? (Time period it covers)
Where• What Geo or country are we talking about?
How• How was this analysis performed? (Methodology)
Why• Why is this important? (Business driver)• Why should the audience care? (Functional)C
on
tex
t
![Page 28: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/28.jpg)
28
Determine your goal & role• Communicate message / findings? (Talk)
• Get feedback / input?(Listen)
• Conversation starter / brainstorming?(Facilitate)
Allocate time accordingly
The Most Important Thing^Second
![Page 29: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/29.jpg)
29
Short attention spans
Key Challenge / Dilemma
Should my presentation be visual?
Should it be a reference document?
Short memories
YES
![Page 30: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/30.jpg)
30
Three Learning StylesPeople learn in different ways. Leverage each effectively
Visual
Reading
Verbal
![Page 31: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/31.jpg)
31
Everything should be madeas simple as possible,
but not simpler Albert Einstein
![Page 32: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/32.jpg)
32
Maximize white space• The eye focuses on what is not blank• Use animations to set tempo
Try your best to eliminate any extraneous words• Keep bullet points concise• Shift + F7 for thesaurus
Less is moreLimit slide to one key idea
The appendix is your friend• Use appendix for extra detail
Try your best to eliminate any extraneous words
![Page 33: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/33.jpg)
33
Common MistakeSmart art isn’t always smart
Smart Art• Seems like a
great idea
Unfortunately• Doesn’t help to
get your point across
Distracts• From your
message
![Page 34: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/34.jpg)
ENT
SMB
PRO
Very large business
Size Segment3 size segments
Small to Medium Businesses
Very small businesses or individuals
5,000+ employees
Qualitative Definition
Quantitative Definition
1-9 employees
10-4,999 employees
34
![Page 35: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/35.jpg)
Commercial only. Education is outside of scope.
Customer Size SegmentsOutside-in view gives us a proxy for potential
35
Enterprise
SMB
Professional
Consumers
5,000+ employees
10 – 4,999 employees
1-9 employees
Individuals
![Page 36: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/36.jpg)
Most Granular
More Granular
Use Boxes to Represent CategoriesUse color & size to illustrate your point
36
Most Granular
Most Granular
Most Granular
More Granular More Granular
High-level category
Most Granular
Most Granular
Most Granular
Most Granular
Most Granular
Most Granular
Most Granular
Most Granular
![Page 37: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/37.jpg)
37
Size• The eye sees larger items as more important
Color• Maintain consistency between slides• Grey out less important or neutral categories
Use Visual Levers IntentionallyEmphasize your key points with size, color & shape
Shape• Can provoke differences visually
Group1Group 2
Group 3
![Page 38: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/38.jpg)
Pie Charts are Rarely the Best ChoiceEx: Comparing account migration across three groups
38
• The eye is drawn to the wrong thing
• Audience can’t compare categories easily
• Time period is unclear
![Page 39: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/39.jpg)
100% Stack Bar Works Better Shows proportions across categories
Group 1 Group 2 Group 3
17% 17% 16%
59% 64% 69%
24% 18% 15%
2010 2011 Account Migration
Moved Up
Constant
Moved Down
Source: Include in every slide containing data39
Group 1 had the highest % of accounts move up in 2011
![Page 40: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/40.jpg)
Horizontal Bars for Many CategoriesHelps the eye focus on relative size
Bananas
Apples
Oranges
Grapes
Melons
Lemons
Strawberries
Blueberries
Mangos
Pears
All Others
$511,424,397
$351,309,812
$275,716,318
$213,754,012
$167,763,165
$165,719,985
$144,611,510
$125,605,079
$124,730,617
$109,279,232
$224,919,996
Revenue by Fruit, FY09-11 ($K USD)
40
Use one color to avoid a rainbow effect
Group smaller categories together
Source: Include in every slide containing data
![Page 41: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/41.jpg)
Bananas
Apples
Oranges
Grapes
Melons
Lemons
Strawberries
Blueberries
Mangos
Pears
All Others
$511,424,397
$351,309,812 $275,716,
318 $213,754,012
$167,763,165
$165,719,985
$144,611,510
$125,605,079
$124,730,617
$109,279,232
$224,919,996
Revenue by Fruit, FY09-11 ($K USD)
Source: Include in every slide containing data
41
Highlight one category with color & size
Revenue by Fruit Type, FY09-11Oranges are the #3 contributor
![Page 42: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/42.jpg)
Sometimes Tables are the Best Choice% and growth help to tell the story
42
Abbreviate numbers
Source: Include in every slide containing data
![Page 43: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/43.jpg)
Only region with
positive CAGR
Fruit Revenue, FY08-11South America is driving growth
43
Largest region lagging FY08 & FY09
levels
Despite strong FY11
growth
Source: Include in every slide containing data
![Page 44: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/44.jpg)
Chart TemplateGuidelines for clear communication
44
• Use color, size, shape very intentionally
• Abbreviate numbers where possible
Chart Title, Date
Guide audience to supporting datapoints
Always provide data sources
Make title clear. “What am I looking at?”
Key point / conclusion / recommendation
Always include
date
Source: Include in every slide containing data
![Page 45: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/45.jpg)
Technical Tips & Tricks
45
MSFT Office is all you need• xls + ppt• Paste as picture
Use quick access toolbar• Ex: Align, Distribute
Don’t fear animations• Use entrance to set pace
Dedicate yourself!• Effective presentations take time• Don’t reinvent the wheel
![Page 46: Tmag preso, mar 2012 v1.2](https://reader030.vdocuments.us/reader030/viewer/2022032619/55c2c795bb61eb9d768b4597/html5/thumbnails/46.jpg)
Source your charts!46
SizeColorShape
Maximize white space(Use Appendix)
Goal
Role
Interesting
Informative
Dedicate timeGuide audience to supporting
datapoints