data visualization 2012-09
DESCRIPTION
TRANSCRIPT
![Page 1: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/1.jpg)
David GiardMCTS, MCSD, MCSE, MCDBA
blog: DavidGiard.comtv: TechnologyAndFriends.comtwitter: @DavidGiarde-mail: [email protected]
Data VisualizationThe Ideas of Edward Tufte
![Page 2: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/2.jpg)
I II III IV
x y x y x y x y
10.0 8.04 10.0 9.14 10.0 7.46 8.0 6.58
8.0 6.95 8.0 8.14 8.0 6.77 8.0 5.76
13.0 7.58 13.0 8.74 13.0 12.74 8.0 7.71
9.0 8.81 9.0 8.77 9.0 7.11 8.0 8.84
11.0 8.33 11.0 9.26 11.0 7.81 8.0 8.47
14.0 9.96 14.0 8.10 14.0 8.84 8.0 7.04
6.0 7.24 6.0 6.13 6.0 6.08 8.0 5.25
4.0 4.26 4.0 3.10 4.0 5.39 19.0 12.50
12.0 10.84 12.0 9.13 12.0 8.15 8.0 5.59
7.0 4.82 7.0 7.26 7.0 6.42 8.0 7.91
5.0 5.68 5.0 4.74 5.0 5.72 8.0 6.89
![Page 3: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/3.jpg)
0 10 200
5
10I
0 10 200
5
10II
0 10 200
5
10
III
0 10 200
5
10
IV
![Page 4: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/4.jpg)
Dr. Edward Tufte
![Page 5: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/5.jpg)
Graphical Excellence
![Page 6: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/6.jpg)
![Page 7: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/7.jpg)
![Page 8: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/8.jpg)
![Page 9: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/9.jpg)
![Page 10: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/10.jpg)
500,000
100,000
10,000
![Page 11: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/11.jpg)
Graphical Integrity
![Page 12: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/12.jpg)
Blatant Lies
Source: Fox News, Dec 2011Reprinted by Washington Post
![Page 13: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/13.jpg)
$(11,014)$0 $(11,014)
![Page 14: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/14.jpg)
Lie
![Page 15: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/15.jpg)
Lie Factor
![Page 16: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/16.jpg)
Lie
Data Increase = 53%Graphical Increase = 783%
Lie Factor=14.8
![Page 17: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/17.jpg)
Truth
1978 1979 1980 1981 1982 1983 1984 19850
5
10
15
20
25
30
Required Fuel Economy Standards:New cars built from 1978 to 1985
![Page 18: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/18.jpg)
Data Change = 125%Graphical Change = 406%
Lie Factor=3.8
![Page 19: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/19.jpg)
Data Change = 554%Graphical Change = 27,000% Lie Factor=48.8
![Page 20: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/20.jpg)
![Page 21: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/21.jpg)
![Page 22: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/22.jpg)
Context
![Page 23: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/23.jpg)
1955 1956275
300
325 Connecticut Traffic Deaths,Before (1955) and After(1956)
Stricter Enforcement by the PoliceAgainst Cars Exceeding Speed Limit
Before stricterenforcement
After stricterenforcement
![Page 24: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/24.jpg)
![Page 25: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/25.jpg)
1951 1952 1953 1954 1955 1956 1957 1958 1959225
250
275
300
325
Connecticut Traffic Deaths1951-1959
![Page 26: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/26.jpg)
1951 1952 1953 1954 1955 1956 1957 1958 19596
8
10
12
14
16 Traffic Deaths per 100,000Persons in Connecticut, Massachusetts,
Rhode Island, and New York1951-1959
NY
MA
CTRI
![Page 27: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/27.jpg)
Principles of Graphical Integrity
• Data Representations proportional to Data• #Dimensions in graph = #Dimensions in data• Real dollars, instead of deflated dollars• Provide context
![Page 28: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/28.jpg)
Data-Ink
![Page 29: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/29.jpg)
Data-Ink Ratio
=
![Page 30: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/30.jpg)
35.9
![Page 31: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/31.jpg)
35.9
![Page 32: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/32.jpg)
0 1 2 3 4 5 60
20
40
60
80
100
120
140
160
![Page 33: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/33.jpg)
0 1 2 3 4 5 60
20
40
60
80
100
120
140
160
![Page 34: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/34.jpg)
0 1 2 3 4 5 60
20
40
60
80
100
120
140
160
![Page 35: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/35.jpg)
0 2 4 60
40
80
120
160
![Page 36: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/36.jpg)
0 2 4 60
40
80
120
160
![Page 37: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/37.jpg)
0 2 4 60
40
80
120
160
![Page 38: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/38.jpg)
![Page 39: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/39.jpg)
![Page 40: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/40.jpg)
![Page 41: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/41.jpg)
![Page 42: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/42.jpg)
![Page 43: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/43.jpg)
Principles
• Above all else, show the data• Maximize the Data-Ink ratio, within reason• Erase non-data-ink• Erase redundant data-ink• Revise and edit
![Page 44: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/44.jpg)
Vibrations
![Page 45: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/45.jpg)
Vibrations
![Page 46: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/46.jpg)
![Page 47: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/47.jpg)
![Page 48: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/48.jpg)
Series105
1015202530354045505560
INFLATIONUNEMPLOYMENTSHORTAGESRACELinear (RACE)CRIMEGOVT. POWERCONFIDENCEWATERGATECOMPETENCE
ISSUE AREAS
PERC
ENT
CRIT
ICA
L A
RTIC
LES
![Page 49: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/49.jpg)
Series105
1015202530354045505560
INFL
ATI
ON
UN
EM-
PLO
YMEN
T
SHO
RTA
GES
RA
CE
CR
IME
GO
VT.
PO
WER
CO
NFI
DEN
CE
WA
TER
GA
TE
CO
MPE
TEN
CE
ISSUE AREAS
PER
CEN
T C
RIT
ICA
L A
RTI
CLE
S
![Page 50: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/50.jpg)
Chart Junk and Ducks
![Page 51: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/51.jpg)
![Page 52: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/52.jpg)
![Page 53: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/53.jpg)
![Page 54: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/54.jpg)
Worst. Graph. Ever.
![Page 55: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/55.jpg)
Year % Students < 25
1972 28.0
1973 29.2
1974 32.8
1975 33.6
1976 33.0
![Page 56: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/56.jpg)
Multifunctioning Graphical Elements
![Page 57: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/57.jpg)
![Page 58: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/58.jpg)
![Page 59: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/59.jpg)
![Page 60: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/60.jpg)
Data Density
![Page 61: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/61.jpg)
Data Density
![Page 62: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/62.jpg)
Low Data Density
![Page 63: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/63.jpg)
Low Data Density
Number of entries = 4Graph Area = 26.5 square inchesData Density = =.15 data entries per sq. in.
![Page 64: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/64.jpg)
High Data Density
181 Numbers per square inch
![Page 65: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/65.jpg)
High Data Density
1,000 Numbers per square inch
![Page 66: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/66.jpg)
Small Multiples
![Page 67: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/67.jpg)
Small Multiples
![Page 68: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/68.jpg)
Small Multiples
![Page 69: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/69.jpg)
Tufte’s Graphs
• Sparkline• Slope Graph
![Page 70: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/70.jpg)
Sparklines
![Page 71: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/71.jpg)
Sparklines
![Page 72: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/72.jpg)
Slope Graph
![Page 73: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/73.jpg)
Slope Graph
Source: The Atlantic, June 30, 2012
![Page 74: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/74.jpg)
Takeaways
• Maintain Graphical Integrity• Maximize Data-Ink Ratio, within reason• Avoid Chartjunk and Ducks• Use Multifunctioning Graphical Elements, if
possible• Keep Labels with data• Maximize Data Density
![Page 75: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/75.jpg)
![Page 76: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/76.jpg)
-5-9
-21
-11
-20
-24
-30
-26
Temperature ( C )
10/10/201210/18/201210/24/201211/09/201211/14/201211/20/201211/28/201212/01/201212/06/201212/07/2012
100,000
96,000
55,000
37,000
24,000
50,000
25,00020,00012,00010,000
# Troops
10/10/201210/18/201210/24/201211/09/201211/14/201211/20/201211/28/201212/01/201212/06/201212/07/201240 90
145
180
250
275300
320
365
Distance Traveled (km)
10/10/201210/18/201210/24/201211/09/201211/14/201211/20/201211/28/201212/01/201212/06/201212/07/2012
![Page 77: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/77.jpg)
10/1010/1
210/1
410/1
610/1
810/2
010/2
210/2
410/2
610/2
810/3
011/1
11/311/5
11/711/9
11/1111/1
311/1
511/1
711/1
911/2
111/2
311/2
511/2
711/2
912/1
12/312/5
12/70
20,000
40,000
60,000
80,000
100,000
120,000
Troops
Troops
Date
# Tr
oops
![Page 78: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/78.jpg)
10/1010/1
210/1
410/1
610/1
810/2
010/2
210/2
410/2
610/2
810/3
011/1
11/311/5
11/711/9
11/1111/1
311/1
511/1
711/1
911/2
111/2
311/2
511/2
711/2
912/1
12/312/5
12/70
20,000
40,000
60,000
80,000
100,000
120,000
Troops
Troops
Date
# Tr
oops
![Page 79: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/79.jpg)
10/1010/1
210/1
410/1
610/1
810/2
010/2
210/2
410/2
610/2
810/3
011/1
11/311/5
11/711/9
11/1111/1
311/1
511/1
711/1
911/2
111/2
311/2
511/2
711/2
912/1
12/312/5
12/70
20,000
40,000
60,000
80,000
100,000
120,000
Troops
Date
# Tr
oops
![Page 80: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/80.jpg)
10/1010/1
210/1
410/1
610/1
810/2
010/2
210/2
410/2
610/2
810/3
011/1
11/311/5
11/711/9
11/1111/1
311/1
511/1
711/1
911/2
111/2
311/2
511/2
711/2
912/1
12/312/5
12/70
20,000
40,000
60,000
80,000
100,000
120,000
Date
# Tr
oops
![Page 81: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/81.jpg)
10/10 10/17 10/24 10/31 11/7 11/14 11/21 11/28 12/50
20,000
40,000
60,000
80,000
100,000
120,000
Date
# Tr
oops
![Page 82: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/82.jpg)
10/10 10/17 10/24 10/31 11/7 11/14 11/21 11/28 12/50
20,000
40,000
60,000
80,000
100,000
120,000
-35
-30
-25
-20
-15
-10
-5
0
Date
# Tr
oops
Tem
pera
ture
(Cel
sius)
Troops
Temperature
![Page 83: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/83.jpg)
David GiardMCTS, MCSD, MCSE, MCDBA
blog: DavidGiard.comtv: TechnologyAndFriends.comtwitter: @DavidGiarde-mail: [email protected]
![Page 84: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/84.jpg)
David’s Speaking ScheduleDate Event Location Topic(s)
Sep 15 Code Camp NYC New York, NY Effective Data Visualization
Sep 22 SQL Saturday Kalamazoo, MI Effective Data Visualization
Sep 25 SoftwareGR Grand Rapids, MI TBA
Oct 13 Tampa Code Camp
Tampa, FL TBA
Nov 7 Ann Arbor Computing Society
Ann Arbor, MI How I Learned to Stop Worrying and Love jQuery
Feb 21 Greater Lansing .NET User Group
Okemos, MI How To Use Azure Storage
![Page 85: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/85.jpg)
![Page 86: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/86.jpg)
![Page 87: Data visualization 2012-09](https://reader031.vdocuments.us/reader031/viewer/2022013003/54623454b1af9fba388b4d13/html5/thumbnails/87.jpg)