I N T R O D U C T I O N T O D A T A V I S U A L I Z A T I O N June 18, 2020 2 - 3 : 3 0 p m
I N T R O D U C T I O N S Hillary Blevins Martha Larkin, PhD Center for Faculty Excellence Riley College of Education & Leadership 18 years in nonprofit field before joining Walden in 2019 Over 40 years’ experience in public and higher education, Self-taught in data visualization, starting with Excel and research, and consulting. Joined Walden in 2009. learning Tableau Background in home economics, special education, and Background in historical research, strategic planning, educational assessment. Has numerous publications and program design and evaluation, survey design and presentations on data visualization, assessment, special analysis, and data visualization education pedagogy, and reading. Lives in Morrison, IL with husband and 2 kids (age 12 Lives in Miramar Beach, FL with her husband and co- and 8) presenter, Dick. Jim Lenio, PhD Dick Larkin, PhD Office of Institutional Research & Assessment School of Public Policy & Administration Coming up on 14-year Walden work anniversary Over 40 years’ experience in higher education, research, and consulting. Joined Walden in 2009. Produced too many data visualizations to count…many of them were not good. Background in urban & regional planning, public admin/public affairs, geographic information systems, Background in applied psychology, program evaluation, and mgmt training. Has published and presented on data research methods, survey design, statistics, and visualization and innovative research methodologies. assessment. https://www.bizarro.com/ Lives in Miramar Beach, FL with his wife and co- Live in Eagan, MN with wife and 3 kids (age 8, 6, and 4) presenter, Martha.
Data guides the visualization type P R I N C I P L E S Design matters F O R D A T A Focus on your audience V I S U A L I Z A T I O N Words can be visualized Avoid deception
DATA GUIDES THE VISUALIZATION CHOICE C O M P A R I S O N S C H A N G E O V E R T I M E P R O G R E S S T O A G O A L
C O M P A R I S O N S The pilot program served a total of Service fees provide the greatest 50 students. income stream, but community support makes up nearly two-thirds of all income. 15 Service Fees 35% 12 11 United Way 25% 8 Grants 17% Fundraising 15% 4 Campaigns Donations 8% Grade 8 Grade 9 Grade 10 Grade 11 Grade 12
C O M P A R I S O N S The majority of clients had previous Most participants agree or strongly experience with our services. agreed with the key performance indicators for participant Returning Clients New Clients satisfaction. Strongly Agree Agree Disagree Strongly Disagree 22% I am satisfied with the program. I plan to continue with the program. I will recommend the program to 78% others. 0% 20% 40% 60% 80% 100%
C H A N G E O V E R T I M E After a dip in 2016, membership has Achievement increased during rebounded over the last three years. the program for most outcomes. 1000 Outcome 1 Outcome 2 Outcome 3 Outcome 4 975 90% 950 925 80% 80% 900 76% 74% 70% 875 66% 850 60% 825 800 2015 2016 2017 2018 2019 Pre-Test Post-Test
P R O G R E S S T O A G O A L Most elementary school sites Fundraising campaigns have been most have greater market share than successful at securing donations for last year's average of 9%. scholarships. 14% 7000 11% 10% 6204 5000 8% 3000 3461 1149 Washington Adams Jefferson Madison Scholarships Technology Program Equipment
DESIGN MATTERS P R E - A T T E N T I V E A T T R I B U T E S U S E C O L O R P U R P O S E F U L L Y L E S S I S M O R E
D E S I G N M A T T E R S : P R E - A T T E N T I V E A T T R I B U T E S Few, 2004, p. 5
D E S I G N M A T T E R S : U S E C O L O R P U R P O S E F U L L Y Actual chart from the state of Georgia’s COVID-19 tracker.
D E S I G N M A T T E R S : U S E C O L O R P U R P O S E F U L L Y https://color.review/ Color Palettes & Accessibility
D E S I G N M A T T E R S : U S E C O L O R P U R P O S E F U L L Y Choose Contrasts Wisely Participant Age Participant Age Participant Age Age 25 or Older 75% Age 25 or Older 75% Age 25 or Older 75% Age 24 or Under 25% Age 24 or Under 25% Age 24 or Under 25% 0% 20% 40% 60% 80% 100% 0% 20% 40% 60% 80% 100% 0% 20% 40% 60% 80% 100% (Data label font changed to white) (Excel default) (Dark outline, shaded chart area) Participant Age Participant Age Participant Age Age 25 or Older 75% Age 25 or Older 75% Age 25 or Older 75% Age 24 or Under 25% Age 24 or Under Age 24 or Under 25% 25% 0% 20% 40% 60% 80% 100% 0% 20% 40% 60% 80% 100% 0% 20% 40% 60% 80% 100% (Shaded chart in total) (Black bars, font changed to black, removed lines) (Color aligned to palette)
D E S I G N M A T T E R S : U S E C O L O R P U R P O S E F U L L Y Walden Examples of Color Palette Use
D E S I G N M A T T E R S : L E S S I S M O R E Strategies to make data easier to interpret Avg Number of Minutes to say Goodbyes by Region 50 Sort data from largest to smallest so reader doesn’t have to. 40 30 20 10 0 Midwest Southwest West Southeast Northeast
D E S I G N M A T T E R S : L E S S I S M O R E Avg Number of Minutes to say Goodbyes by Region 50 40 Minutes 30 20 10 0 Midwest Southwest West Southeast Northeast U.S. Region Avg Number of Minutes to say Goodbyes by Region Consider removing gridlines and axis labels. 45 Data labels can be a useful addition in many cases. 13 10 7 3 Midwest Southwest West Southeast Northeast
D E S I G N M A T T E R S : L E S S I S M O R E Avoid more than 4 lines in a chart. Line charts are typically used to show trend over time. If possible, put labels near line rather than use a legend.
FOCUS ON YOUR AUDIENCE
V I S U A L I Z A T I O N F O R D I F F E R E N T A U D I E N C E S Summer Program Attendance by Neighborhood Neighborhood 2015 2016 2017 2018 2019 Erickson 88 85 60 80 94 Minnehaha 102 90 70 75 101 Hiawatha 31 64 70 80 92 Total 221 239 200 235 287 Highlights of successes, points of pride, little to no detail Clients & General Community Summary of accomplishments & challenges, trend data Board, Leadership, Funders Decision making data, granular, detailed Operational Decision Makers
A U D I E N C E : C L I E N T S & G E N E R A L C O M M U N I T Y 287 Single Large Number Participants in 2019 https://www.aqua.org/blog/2013/october/happy-world-octopus-day https://foodgrainsbank.ca/wp-content/uploads/2015/08/Screen-Shot-2015-08-13-at-1.59.14-PM.png 287 Number & Icon elementary aged participants in 2019
A U D I E N C E : B O A R D , L E A D E R S H I P , F U N D E R S Trend data’s go-to chart: the line chart Program attendance is at its highest in 5 years Enrollment goals met for 3 of past 5 years 287 287 239 235 239 235 221 200 Target: 230 221 200 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019
A U D I E N C E : O P E R A T I O N A L D E C I S I O N M A K E R S Summer Program Attendance by Neighborhood Neighborhood 2015 2016 2017 2018 2019 Erickson 88 85 60 80 94 Same data table used to create visuals for different audiences. Minnehaha 102 90 70 75 101 Hiawatha 31 64 70 80 92 Total 221 239 200 235 287 Attendance by Neighborhood Hiawatha neighborhood attendance increase 120 120 Minnehaha 92 100 100 80 70 80 80 Erickson 64 60 60 31 40 40 Hiawatha Hiawatha 20 20 0 0 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019
WORDS CAN BE VISUALIZED S T R A T E G I E S F O R S H O W I N G Q U A L I T A T I V E D A T A
W O R D S C A N B E V I S U A L I Z E D
W O R D S C A N B E V I S U A L I Z E D “I just love to visualize data and tell our story!” 90% of client emails were answered within 24 hours
AVOID DECEPTION I N A P P R O P R I A T E S I Z E C O M P A R I S O N S Y A X I S M A N I P U L A T I O N U S I N G 3 D C H A R T S
R E C E N T N E W S H E A D L I N E S Most deception is unintentional, which means individuals must be very intentional in the data they are displaying.
R E C E N T N E W S H E A D L I N E S When displaying data to be used to make significant decisions…be very explicit. In this case the data was used to make decisions about reopening the state.
I N A P P R O P R I A T E S I Z E C O M P A R I S O N S High School Graduation Rate 84% 82% 80% 78% 76% 74% 72% 70% 2007-08 2008-09 2009-10 2010-11 2011-12 2012-13 2013-14 High School Graduation Rate https://twitter.com/ObamaWhiteHouse/status/677242822920151045/photo/1 82% 81% 80% 79% 78% 75% 75% 75% = 5 books 78% = 10 books 79% = 14 books 80% = 15 books 81% = 16 books 2007-08 2008-09 2009-10 2010-11 2011-12 2012-13 2013-14 82% = 16 books
More recommend
