compare and contrast - data + science · compare and contrast •title format •three dimensional...
TRANSCRIPT
Presented by:
High Visibility: Using Data Visualization to Transform Data into Meaningful Information
Jeffrey A. Shaffer
Vice President, IT and Analytics, Unifund
Adjunct Professor, University of Cincinnati
www.DataPlusScience.com
@HighVizAbility
Compare and Contrast
• Title Format
• Three Dimensional
• Axis Labels on Angle
• Dark Gridelines
• No Data
• Can’t easily compare
• Color Choice
• Legend Space
Basic Proficient Advanced
1990 37 12 1
1992 41 16 2
1996 42 19 2
2000 21 3
2003 45 28 4
2005 44 31 5
2007 43 133 6
2009 43 33 6
2011 42 33 7
Bar Chart Issue
Visualization and Data Presentation
Hamilton County vs. Auditor’s Office
Same data but a completely different story
2008 2009 2010 2011
Hamilton County 6,080 5,404 4,717 4,638
Auditor's Office 97 98 89 84
97
84 6,080
4,638
-
20
40
60
80
100
120
140
-
2,000
4,000
6,000
8,000
Au
dito
r's Office
# of Em
plo
yee
s
Ham
ilto
n C
ou
nty
# o
f Em
plo
yee
s
Hamilton County vs. Auditor's Office(# of Employees)
23.7% Reduction in FTE's
13.4% Reduction in FTE's
Created by Jeffrey A. Shaffer
Since 2008, Hamilton County has reduced 1,442 full-time employees while the Auditor's Office has only eliminated 13.
Visualization and Data Presentation
Exercise:– Hamilton County has hired you to create an alternative
graph to argue the Auditor’s Position.
– Can you use this same data to tell a completely different story?
– Using the same data, design an alternative version for Hamilton County that tells a better looking story for them.
Visualization and Data Presentation
Alternative #1:
Use absolute # of employees instead of %
375 FTE vs. only 108 (nearly 3.5x more)
Graph total number reduced as comparison
Alternative #2:
Adjust time period
Maximizes reduction for Hamilton County
Since 2008 - 1,442 FTE reduced vs. only 13
Exercise:
Fonts and Design
Why does font style matter?
Calibri 32 Point Arial 32 Point
Verdana 32 Point
Georgia 32 Point
Garamond 32 Point Courier New 32 Point
Times New Roman 32 Point
Tahoma 32 Point
sans serif
serif
I Love You.
I Love You.
I Love You.
I Love You.I Love You.
I Love You.
I Love You.
I Love You.
I Love You.
i L o evU
I Love You.
I Love You!
I Love You.
Raster vs. Vector Graphics
Word Clouds(tag clouds)
www.Wordle.net
Bush State of the Union - 2002 Obama State of the Union - 2010
(left) Single-word phrases (unigrams) (right) Multiword phrases
Source: The Stanford Visualization Group (vis.stanford.edu)
"Without the Clutter of Unimportant Words“: Descriptive Keyphrases for Text Visualization
Jason Chuang, Christopher D. Manning, Jeffrey Heer
Tag cloud visualizations
online biography of the pop singer Lady Gaga
Word Clouds(let’s build one)
source: http://www.studentsreview.com/OH/UC_c.html
Tag cloud on Student Feedback of UC
Is this good or bad?
Geocoding
Longitude and Latitude
Longitude and Latitude Longitude and Latitude
Example Notation:
N 38° 41’ 7.8351” degrees, minutes, seconds decimal
N 38° 41.130586’ degrees, minutes decimal
38.68551° degrees decimal (use this # without ° for Tableau)
Batch Geocoding
http://www.Geocod.io2,500 free per day
Upload SpreadsheetGeocode via APIAdditional Data
=ACOS(COS(RADIANS(90-Lat1)) *COS(RADIANS(90-Lat2)) +SIN(RADIANS(90-Lat1)) *SIN(RADIANS(90-Lat2)) *COS(RADIANS(Long1-Long2))) *6371
To calculate distances in miles, substitute R (6371) with 3958.756 (and for nautical miles, use 3440.065)
Calculate Distancebetween latitude/longitude points
(problem - the world is not flat)
source: http://bluemm.blogspot.com/2007/01/excel-formula-to-calculate-distance.html
Make sure to connect online and stay in touch:
Follow on Twitter:@HighVizAbility
Connect with us on LinkedIn:www.linkedin.com/in/jeffreyshaffer/
Websites:www.dataplusscience.com/workshop.htmlwww.dataplusscience.com/http://makingdatameaningful.com/
Facebook:https://www.facebook.com/DataPlusScience
Email:[email protected]