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

data visualization for m e
SMART_READER_LITE
LIVE PREVIEW

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 |


slide-1
SLIDE 1

Data Visualization for M&E

BRIDGE M&E Colloquium Jerusha Govender 8 August 2017

slide-2
SLIDE 2

About Us

We help organizations tell their story through innovative analysis, data visualization & strategic communication

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-3
SLIDE 3

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-4
SLIDE 4

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

slide-5
SLIDE 5
  • 1. Background to Data Viz

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-6
SLIDE 6

What is Data Visualization?

Graphical representation of quantitative and qualitative data, such as chart, map, diagram, etc

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-7
SLIDE 7

The value of Data Viz in M&E

Simplify Complexity Digest Detail Beautify Information

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-8
SLIDE 8

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

slide-9
SLIDE 9

Source: http://www.wikipremed.com/mcat_course_psychology.php?module=2&section=7

“Perceptual Organization”

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-10
SLIDE 10

“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

slide-11
SLIDE 11

Interest over time 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

popular as the peak.

2012 2017 “Data Visualization” – Discipline – Google Trends Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-12
SLIDE 12

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

slide-13
SLIDE 13
  • 2. Components of Data Viz

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-14
SLIDE 14

Quantitative Qualitative Telling a story

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-15
SLIDE 15

Quantitative Data Viz

Simple Graphical Solutions

  • Chart Tactics
  • Maps
  • Static Dashboards

Advanced Analytics

  • Dynamic Dashboards
  • Social Network Analysis
  • R – based tools

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-16
SLIDE 16

|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

slide-17
SLIDE 17

|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

slide-18
SLIDE 18
slide-19
SLIDE 19

F 69% M 31%

Series1 1000 2000 3000 4000 5000 F M U

F, 454 8 M, 203 3

||Proportion

Pie chart – with caution Icon Matrix Inappropriate chart Poor font size

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-20
SLIDE 20

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-21
SLIDE 21

||Change

10 20 30 10 12 50 60 30 50 30 10 20 30 40 50 60 70 80 90 1 2 3 4 5 Before After 40 40 40 18 John Mary Lisa Ann Peter

Change in test scores

Bar Chart Incorrect choice

  • f chart

No labels or heading Do we need data labels and axis?

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-22
SLIDE 22

||Change

Bar Chart

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-23
SLIDE 23

0% 20% 40% 60% 80% 100%

55 35 68 59 58 42 55 34 53 25 52 37 49 23 46 33 42 22 39 17 15 13 36 27 22

Confident that I can achieve my plans Have a clear idea of what steps to achieve my life plans A mentor to other people Part of a network that helps me access opportunities Have ideas on how to solve SA’s challenges Know how to make my voice heard on challenges facing SA If I want to start my own project, I know someone who can support me Know someone who can help me further my education Know someone who can help me find a job in the sector I can make a difference in SA Clear plan for my future People around me that can help my achieve my plans Helped other people get access to opportunities

||Change

Dumbel plot

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-24
SLIDE 24

||Trend over time

Line Chart

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-25
SLIDE 25

|| Trend in scale

Sorted Bar chart

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-26
SLIDE 26

|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

slide-27
SLIDE 27

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

slide-28
SLIDE 28

Chart Overlays

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-29
SLIDE 29

|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

slide-30
SLIDE 30

|Indicator performance

Line chart Conditional formatting

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-31
SLIDE 31

|Excel-based Interactive Dashboards

  • Functions:
  • Pivot Charts & Tables
  • Slicers
  • Hyperlinks

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-32
SLIDE 32

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-33
SLIDE 33

Toolkit

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-34
SLIDE 34

|Advanced Quant Data Viz

  • Dynamic

Dashboards

  • Social Network

Analysis

  • R – based tools

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-35
SLIDE 35

Toolkit

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-36
SLIDE 36

Qualitative Data Viz

  • Icons
  • Timelines
  • Photographic overlay

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-37
SLIDE 37

|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

slide-38
SLIDE 38

"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

slide-39
SLIDE 39

|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

slide-40
SLIDE 40

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-41
SLIDE 41

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-42
SLIDE 42

|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

slide-43
SLIDE 43

Only 10% of South Africa’s 28 000 schools have access to one or more computers

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-44
SLIDE 44

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-45
SLIDE 45

Toolkit

slide-46
SLIDE 46

Telling the Story

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-47
SLIDE 47

Telling the Story

  • Understand your audience
  • Compelling Narrative - Flow
  • Font
  • Colour

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-48
SLIDE 48

Telling the Story

  • White space

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-49
SLIDE 49

Telling the Story

  • Narrative - Flow
  • Font
  • Colour
  • White space
  • Layout

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-50
SLIDE 50

Telling the Story

  • Understand your audience
  • Compelling Narrative - Flow
  • Font
  • Colour
  • White space
  • Layout

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-51
SLIDE 51

Summary

  • Chart Tactics
  • Maps
  • Static Dashboards
  • Icons
  • Timelines
  • Photographic overlay
slide-52
SLIDE 52

Conceptualize this…

  • “Tracking the decades-long fight to eradicate Polio”
  • Information and data for period 1985-2016
  • Number of polio cases by year
  • Outbreaks by country and year
  • Key events and efforts in eradicating polio
  • Regions declared polio-free
  • Americas 1994
  • Europe 2001
  • South East Asia 2014
  • Ethiopia 2015

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-53
SLIDE 53

Q&A

slide-54
SLIDE 54
  • Attend the SAMEA 2017 Conference

– Data viz and analytics stream

  • Contact Kate for more information:

info@samea.org.za

  • Participate in the SAMEATalk

conversations and Eval Cafés

Jerusha Govender | jerusha@thedatainnovator.com | @datainnovator

slide-55
SLIDE 55
  • Follow us on @DataInnovator
  • Attend our upcoming Visual Story-

telling training in November 2017

  • Request details on our Infographic

packages, data viz and other services

  • Contact

jerusha@thedatainnovator.com