how to unlock value in analytics using data visualization?
DESCRIPTION
Conveying meaning in data quickly is the focal point of analytics. Visual analytics helps you discover new relationships in data, prompts you to ask new questions, and helps you convey what you see to others. • Understand how to make sense of vast data quickly • Elicit questions you did not ask before • Using visualizations to discover new data relationships • Learn how data visualization can help identify hidden insights in data • Explore various visualizations hand-picked by expertsTRANSCRIPT
How to Unlock Value in Data Using Data Visualizations[#VIZ]
Chaitanya Sagar “CS”[email protected]
Data Analytics Spreadsheet Solutions|
2
New York HyderabadSan Bruno Boston
3
AnalyticsSpreadsheetSolutions
Data Visualizations Marketing Marketing Mix Modeling Price Promotion Analysis Catalogue Optimization Segmentation Web Analytics Churn Analysis
Risk Management Credit Risk Management Liquidity Risk Management Capital Allocation Analysis Collateral Management Fraud Detection Supply Chain Inventory Optimization Demand Analytics Distribution Network Optimization Sourcing Analytics Freight Lane Analytics
Verticals Consumer Packaged Goods Retail Healthcare
Our Services
4
AnalyticsSpreadsheetSolutions
Our Services
Spreadsheet ApplicationsContract NegotiationLitigation ModelingDecision Support Tools
DashboardsReporting SimulationsFinancial Modeling
Location Strategy to Improve Effectiveness of a Branch Network
perceptive-analytics.com/tag/case-study/
Reinventing Coupons: Strategies for Successful Coupon Campaign
perceptive-analytics.com/tag/case-study/
Which industry do you work in?• Retail and Consumer Packaged
Goods • Health Care• Banking, Financial Services and
Insurance• Information Technology /
Consulting/Others
[email protected] 646.583.0001 #VIZ 9
Which Function Do You Work In?• Analytics• BI• Sales and Marketing • IT• Finance/Operations / Human
Resources
[email protected] 646.583.0001 #VIZ 10
Overview
Pic
y Ho
ria V
arla
n
[email protected] 646.583.0001 #VIZ 11
The need for visualizationsHow visualizations help unlock valueHow to build visualizations
-Purpose-Design
Tools Q&A
The Need for Visualizations
[email protected] 646.583.0001 #VIZ
Humans are Visual
Brain can absorb large amounts of information and find patterns (and deviations!) Pi
c by
Dan
Foy
[email protected] 646.583.0001 #VIZ
●
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
X X X X X X X X X
“Mind is a Pattern-Matching Machine”
Edward De BonoMechanism of the Mind (1969)
[email protected] 646.583.0001 #VIZ
[email protected] 646.583.0001 #VIZ
x y x y x y x y10 8.04 10 9.14 10 7.46 8 6.588 6.95 8 8.14 8 6.77 8 5.7613 7.58 13 8.74 13 12.74 8 7.719 8.81 9 8.77 9 7.11 8 8.8411 8.33 11 9.26 11 7.81 8 8.4714 9.96 14 8.1 14 8.84 8 7.046 7.24 6 6.13 6 6.08 8 5.254 4.26 4 3.1 4 5.39 19 12.512 10.84 12 9.13 12 8.15 8 5.567 4.82 7 7.26 7 6.42 8 7.915 5.68 5 4.74 5 5.73 8 6.89
Mean 9 7.5 9 7.5 9 7.5 9 7.5Variance 11 4.122 11 4.122 11 4.122 11 4.122
CorrelationLinear Regression y = 3.00 + 0.500x y = 3.00 + 0.500x y = 3.00 + 0.500x y = 3.00 + 0.500x
Anscombe's QuartetI II III IV
0.816 0.816 0.816 0.816
Anscombe’s Quartet
How are the Data Sets Different?
• All four data sets are identical• Distribution is different• Median and Mode could be different• Not Sure
[email protected] 646.583.0001 #VIZ
Statistics May Hide Something
[email protected] 646.583.0001 #VIZ
Statistics and bikinis show a lot, but not everything.
- Toby HarrahAmerican baseball player
[email protected] 646.583.0001 #VIZ
Where do Data Visualizations Fit in Data Analytics Process?
[email protected] 646.583.0001 #VIZ
Acquire Data
Clean Data
Explore Data
DataModeling
Insights
Communicate
Where does Data Visualization Fit in Data Analytics Process?
[email protected] 646.583.0001 #VIZ
How Visualizations Help Unlock Value
[email protected] 646.583.0001 #VIZ
Make Sense of Vast Data Quickly
[email protected] 646.583.0001 #VIZ
Make Sense of Vast Data Quickly
[email protected] 646.583.0001 #VIZ
Elicit Questions You Did Not Ask Before
[email protected] 646.583.0001 #VIZ
What should we do to make India a land of equal opportunity for all, free of prejudice and discrimination?
- Ratan Tata
[email protected] 646.583.0001 #VIZ
Sample Responses• @RNTata2000 in all democracies there is a gap on what ple want and
what politicians r delivering,they r not doing the right thing, lobbying?• @bangaarm @RNTata2000 Budget 2012: This year is Tax Holiday. No
income tax on your earnings. This is to bring back all the black money to India
• @sri_v22 @RNTata2000 1. Kill corruption 2. Electoral reforms so that honest ple can get into politics 3. Media & activists should increase their role
• @joseaaa @RNTata2000 Can't be articulated with 140 characters. Quality education for the masses is magic potion that can address most of the problem.
• @dharmeshsharma8 @RNTata2000 Could we have your view on this topic?
[email protected] 646.583.0001 #VIZ
Elicit Questions You Did Not Ask Before
[email protected] 646.583.0001 #VIZ
Discover New Data Relationships
[email protected] 646.583.0001 #VIZ
Discover New Data Relationships
[email protected] 646.583.0001 #VIZ
Show Others What You See
[email protected] 646.583.0001 #VIZ
Show Others What You See
http://guns.periscopic.com
How to Create Visualizations
[email protected] 646.583.0001 #VIZ
Purpose Design
[email protected] 646.583.0001 #VIZ 45
Guidelines
• Understand your goals• Determine the most important dimensions of your
data• Determine key data relationships• Show data close to reality e.g. maps, time lines
etc.• Choose encoding wisely “Function first, suave
next”• What questions do you want answered?
[email protected] 646.583.0001 #VIZ
Visual Encoding
[email protected] 646.583.0001 #VIZ
[email protected] 646.583.0001 #VIZ
What Do You Think About This Chart?
[email protected] 646.583.0001 #VIZ
What’s Wrong with this Chart?• Too Big• Poor colors• Nothing wrong, looks good• It’s just wrong• No comment
[email protected] 646.583.0001 #VIZ 53
39.0%
19.5%
9.8%
7.4%
3.1%
21.2%
U.S. SmartPhone Marketshare
RIM
Apple
Palm
Motorola
Nokia
Other
Edward Tufte
[email protected] 646.583.0001 #VIZ
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec$450
$650
$850Monthly Revenue
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec$0
$200
$400
$600
$800
$1,000
470
900
700
550
800
600473
610 600
300
500 450
Monthly Revenue
Thou
sand
sTh
ousa
nds
Avoid Chart Junk
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec$0
$200
$400
$600
$800
$1,000
Monthly Revenue
Month
Thou
sand
s
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec$0
$200
$400
$600
$800
$1,000
400
900
700
550
800
500
780
610 600
450500
300
Monthly Revenue
Month
Avoid Chart JunkTh
ousa
nds
Maximize Data Ink RatioData-ink/Total ink used
Maximize Data Density(# entries in data matrix)/(area of graphic)
Colors
[email protected] 646.583.0001 #VIZ 60
ColorBrewer2.org
Tools
[email protected] 646.583.0001 #VIZ
[email protected] 646.583.0001 #VIZ
[email protected] 646.583.0001 #VIZ
ResourcesDesigning Data Visualizations (Noah Iliinsky, Julie Steele)Visual Encoding
complexdiagrams.com/properties richardbrath.wordpress.com
Edward Tufteedwardtufte.com
D3JS.org Processing.orgPrinciples of Visualization DesignD3 Visualizations
[email protected] 646.583.0001 #VIZ
Q&A
[email protected] 646.583.0001 #VIZ
Your Feedback on this Webinar
• Below Expectations• Met Expectations• Above Expectations
[email protected] 646.583.0001 #VIZ 70