Mastering Data Visualization for Effective Presentations

1. Data Visualization Matt Heusman Ben Baumfalk Nebraska Department of Education 2012 Data Visualization

2. Vision is our most dominant sense. It takes up 50% of our brain’s resources. And despite the visual nature of text, pictures are actually a superior and more efficient delivery mechanism for information. In neurology, this is called the ‘pictorial superiority effect’ [...] If I present information to you orally, you’ll probably only remember about 10% 72 hours after exposure, but if I add a picture, recall soars to 65%. So we are hard-wired to find visualization more compelling than a spreadsheet, a speech of a memo.

4. Get Your Data • Data Quality • NSSRS Submissions • Test Results (NeSA, NAI, Dibels, etc.) • Keeping SIS up-to-date • Local Data Warehouse

6. Ask a Question • Anecdotal • Direct Observation • School Improvement/Evaluation Framework • Question from Media/Stakeholders

8. Choose Your Tools • Business Intelligence Tools • “R”, SPSS, SAS, SQL Reporting Services • Data Mining • NSSRS Validation • DRS • Spreadsheets (Excel, Acess) • merging files • pivot tables

10. Explore • Trends, Patterns, Differences? • Across categories, space, time?

11. Cohort Example

15. Got Your Story? • What does the data say? • How confident are you? • Is there anything you’re missing? • Building a narrative

17. Design Your Visual • What is your story? • Who is your audience? • Is it accurate? • Biases?

22. Bias and Interpretation • Appropriate Scale • Appropriate Visualization Type

23. Reporting Information Accurately Without Bias (Data is Emotional)

27. 4 7 8 3 1 5 5 6 2 7 9 8 4 1 5 1 6 8 0 2 7 6 3 9 2 7 3 0 1 4 9 0 1 4 8 5 3 2 7 0 1 4 6 8 5 7 2 1 9 0 3 2 6 9 1 8 4 3 6 7 3 1 6 8 9 2 6 2 9 0 7 4 9 9 1 0 2 3 0 2 1 2 3 4 5 6 7 8 9 0 2 4 6 8 0 1 3 5 7 9 9 0 7 8 5 6 3 4 1 2

28. 4 7 8 3 1 5 5 6 2 7 9 8 4 1 5 1 6 8 0 2 7 6 3 9 2 7 3 0 1 4 9 0 1 4 8 5 3 2 7 0 1 4 6 8 5 7 2 1 9 0 3 2 6 9 1 8 4 3 6 7 3 1 6 8 9 2 6 2 9 0 7 4 9 9 1 0 2 3 0 2 1 2 3 4 5 6 7 8 9 0 2 4 6 8 0 1 3 5 7 9 9 0 7 8 5 6 3 4 1 2

29. 7 7 4 8 3 1 5 5 6 2 9 8 4 1 5 1 6 8 0 2 7 7 6 3 9 2 3 0 1 4 7 9 0 1 4 8 5 3 2 0 7 1 4 6 8 5 2 1 9 0 7 3 2 6 9 1 8 4 3 6 3 1 6 8 9 2 6 2 9 0 7 4 9 9 1 0 2 3 0 2 7 1 2 3 4 5 6 8 9 0 7 2 4 6 8 0 1 3 5 9 7 9 0 8 5 6 3 4 1 2

30. 7 7 4 8 3 1 5 5 6 2 9 8 4 1 5 1 6 8 0 2 7 7 6 3 9 2 3 0 1 4 7 9 0 1 4 8 5 3 2 0 7 1 4 6 8 5 2 1 9 0 7 3 2 6 9 1 8 4 3 6 3 1 6 8 9 2 6 2 9 0 7 4 9 9 1 0 2 3 0 2 7 1 2 3 4 5 6 8 9 0 7 2 4 6 8 0 1 3 5 9 7 9 0 8 5 6 3 4 1 2

31. 4 7 8 3 1 5 5 6 2 7 9 8 4 1 5 1 6 8 0 2 7 6 3 9 2 7 3 0 1 4 9 0 1 4 8 5 3 2 7 0 1 4 6 8 5 7 2 1 9 0 3 2 6 9 1 8 4 3 6 7 3 1 6 8 9 2 6 2 9 0 7 4 9 9 1 0 2 3 0 2 1 2 3 4 5 6 7 8 9 0 2 4 6 8 0 1 3 5 7 9 9 0 7 8 5 6 3 4 1 2

32. Video

33. Resources • Videos • http://www.youtube.com/watch?feature=player_embedded&v=mkEXx7sDXAI • http://blip.tv/ignitedc/alex-lundry-chart-wars-the-political-power-of-data-visualization-3021845 • http://www.ted.com/talks/lang/en/david_mccandless_the_beauty_of_data_visualization.html • http://www.youtube.com/watch?v=jbkSRLYSojo • http://www.youtube.com/watch?v=Q9wcvFkWpsM • Tools • http://www.google.com/publicdata/directory • http://visual.ly/ • http://code.google.com/apis/chart/ • http://www.wordle.net/ • Sites • http://www.designspectre.com/tools/data-visualization-tools/ • http://www.designspectre.com/design/data-visualization-examples/ • http://www.brainpickings.org/index.php/2011/10/25/visual-storytelling-gestalten/