Data Visualization for M&E BRIDGE M&E Colloquium Jerusha - PowerPoint PPT Presentation

Data Visualization for M&E BRIDGE M&E Colloquium Jerusha Govender 8 August 2017

About Us We help organizations tell their story through innovative analysis, data visualization & strategic communication Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Data Visualization for M&E 1. Background to Data Visualization 2. Components of Data Visualization 3. Types of Data Visualization 4. Conceptualizing a Data Visualization Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

1. Background to Data Viz Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

What is Data Visualization? Graphical representation of quantitative and qualitative data, such as chart, map, diagram, etc Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

The value of Data Viz in M&E Beautify Simplify Digest Detail Information Complexity Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Origins of Data Viz – Visual perception Source: Few, S. 2nd Ed. Data Visualization for Human Perception. (in) The Encyclopedia of Human-Computer Interaction, 2nd Ed. by Mads Soegaard, Rikke Friis Dam Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

“Perceptual Organization” Source: http://www.wikipremed.com/mcat_course_psychology.php?module=2&section=7 Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

“map by Charles Joseph Minard portrays the losses suffered by Napoleon’s army in the Russian campaign of 1812” Source: https://sites.psu.edu/julieludeman/2016/02/22/edward-tufte-the-da-vinci-of-data/ Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Interest over time “Data Visualization” – Discipline – Google Trends Numbers represent search interest relative to the highest point on the chart for the given region and time. A value of 100 is the peak popularity for the term. A value of 50 means that the term is half as popular. Likewise a score of 0 means the term was less than 1% as 2012 2017 popular as the peak. Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Data Journalism M&E Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

2. Components of Data Viz Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Quantitative Qualitative Telling a story Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Quantitative Data Viz Simple Graphical Solutions Advanced Analytics • Chart Tactics • Dynamic Dashboards • Maps • Social Network Analysis • Static Dashboards • R – based tools Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

|Chart Tactics The process of creating well researched and aesthetically pleasing infographics, charts, diagrams, and/ or maps to summaries data in a way that is quick and easy for the reader or audience to understand Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

|Chart Tactics • Based on comprehensive, and quality assured data • Correct or appropriate to convey their message accurately and effectively. I.e. ensure that the chart, graph, map or diagram chosen is appropriate • Ask: "What is your point?" - Stephanie Evergreen • Clear and high quality with minimal clutter and with appropriate use of colour • Similar throughout the document to create a strong visual theme throughout, using text size, font, style, icons and colour

||Proportion Poor font size F, 5000 454 M 4000 8 M, 31% 3000 203 2000 1000 3 F 0 Series1 F M 69% U Pie chart – with Icon Matrix Inappropriate caution chart Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

||Change No labels or Change in test scores heading 5 12 30 40 40 40 4 10 50 3 30 30 18 2 20 60 1 10 50 0 John Mary Lisa Ann Peter 0 10 20 30 40 50 60 70 80 90 Before After Bar Chart Do we need Incorrect choice data labels and of chart axis? Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

||Change Bar Chart Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

||Change 55 68 Confident that I can achieve my plans 35 59 Helped other people get access to opportunities 58 I can make a difference in SA 55 42 Clear plan for my future 34 53 People around me that can help my achieve my plans 25 52 Have a clear idea of what steps to achieve my life plans 37 49 A mentor to other people 23 46 Part of a network that helps me access opportunities 33 42 Have ideas on how to solve SA’s challenges 22 39 Know how to make my voice heard on challenges facing SA 36 17 If I want to start my own project, I know someone who can support me 15 27 Know someone who can help me further my education 13 22 Know someone who can help me find a job in the sector 0% 20% 40% 60% 80% 100% Dumbel plot Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

||Trend over time Line Chart Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

|| Trend in scale Sorted Bar chart Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

|Maps Describing location and scale in words can be challenging. Even graphs alone do not provide a clear spatial picture, i.e. how far one location is from another or how big it is compared to another. Maps allow us to condense and present spacial variation. Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

South Africa, Zimbabwe, Zambia, Malawi, Uganda, Somalia, Chad, Togo and Tunisia have the highest levels of indicator X Heat Map Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Chart Overlays Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

|Static Dashboards • “display a dense array of information in small amount of space and in a manner that communicates clearly and immediately .” Few, S. 2013. Information Dashboard Design. Analytics Press. Burlingame • Types: • Operational dashboards tell you what is happening now • Strategic dashboards track key performance indicators • Analytical dashboards process data to identify trends Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

|Indicator performance Conditional Line chart formatting Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

|Excel-based Interactive Dashboards • Functions: • Pivot Charts & Tables • Slicers • Hyperlinks Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Toolkit Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

|Advanced Quant Data Viz • Dynamic Dashboards • Social Network Analysis • R – based tools Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Toolkit Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Qualitative Data Viz • Icons • Timelines • Photographic overlay Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

|Icons Based on the themes and key points identified use symbols to emphasize enclosure and similarity. This reduces reading time as icon represents a statement or category. Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

"The key factors inhibiting schools from acquiring computers are: absence of electricity, lack of funding, insufficient building, lack of available and trained staff, poor security" Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

|Timelines In long term projects the series of key events or even the complex stages of an evaluation can be hard to condense. Timelines allow us to tell the story of the sequence and complexity of events. Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

|Photographic overlay Using photographs allows the reader a more detailed understanding of a context or perspective. It also arouses emotions and engagement. This is particularly useful when a writing style is not emotive, but there is a need to convey severity, or contextual detail. Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Only 10% of South Africa’s 28 000 schools have access to one or more computers Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Toolkit

Telling the Story Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Telling the Story • Understand your audience • Compelling Narrative - Flow • Font • Colour Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Telling the Story • White space Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

Telling the Story • Narrative - Flow • Font • Colour • White space • Layout Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator