Upgrade to Pro — share decks privately, control downloads, hide ads and more …

30 minutes of data-visualization

ffunction
November 19, 2011

30 minutes of data-visualization

A hands-on introduction to data visualization using Google Docs

ffunction

November 19, 2011
Tweet

Other Decks in Design

Transcript

  1. ffunction inc. © FFUNCTION INC, 2011 WORKSHOP 30 MINUTES OF

    DATA VISUALIZATION Sébastien Pierre, FFunction inc. @MontréalOuvert Hackathon, November 19th 2011 www.ffctn.com
  2. ffunction inc. © FFUNCTION INC, 2011 THE GOALS ➔ CRASH

    COURSE TO BASIC DATA VISUALIZATION – Using free, publicly available tools (Google Docs) – Learn the core principles of “dataviz” – Learn how to understand a dataset – Learn how to tell a visual story
  3. ffunction inc. © FFUNCTION INC, 2011 IT STARTS WITH DATA

    ➔ DATA IS YOUR RAW MATERIAL Select it with care, respect it, understand it. Always prefer raw data to already arranged/aggregated data.
  4. ffunction inc. © FFUNCTION INC, 2011 BE HUMBLE ➔ DATA

    COMES BEFORE YOUR IDEA You might already think of a great visual for your data, but it might just not work with the specific data that you have!
  5. ffunction inc. © FFUNCTION INC, 2011 BE TRUE ➔ DATA

    MIGHT NOT SAY WHAT YOU'D EXPECT You might already have an opinion on what the data should show/say... but it might very well tell a very different story from the one you had in mind!
  6. ffunction inc. © FFUNCTION INC, 2011 BE PREPARED TO FAIL

    ➔ DATA MIGHT NOT HAVE ANYTHING TO TELL Sometimes the data doesn't tell anything, however you present it, however you process it. It's OK, you've just trained your ability to visualize data fast!
  7. ffunction inc. © FFUNCTION INC, 2011 STEP 1: GET THE

    DATA ➔ SPENDING BY THE GLOBAL MIDDLE CLASS Dataset created by Prof. Homi Kharas at the Brooking Institution in New-York and kindly provided by the Redwood Group http://www.redwoodgroup.net ➔ Get the data http://goo.gl/KxciV
  8. ffunction inc. © FFUNCTION INC, 2011 The data represents the

    projected spending of the middle class in major regions worldwide, from 2009 to 2030
  9. ffunction inc. © FFUNCTION INC, 2011 STEP 2: GET TO

    KNOW THE DATA ➔ WHAT IS REPRESENTED? Identify the variables used in the data ➔ WHAT ARE THE DIMENSIONS? Measure the span of the variables ➔ CAN WE SPOT TRENDS? Try to spot interesting changes or patterns
  10. ffunction inc. © FFUNCTION INC, 2011 REGIONS YEARS SPENDING ($)

    DATA ELEMENTS 9 regions 4 in Asia 9 regions 4 in Asia
  11. ffunction inc. © FFUNCTION INC, 2011 REGIONS YEARS SPENDING ($)

    DATA ELEMENTS 30 years 3 actual 27 projected 30 years 3 actual 27 projected
  12. ffunction inc. © FFUNCTION INC, 2011 MIN/MAX/AVERAGE help you understand

    the data MIN/MAX/AVERAGE help you understand the data
  13. ffunction inc. © FFUNCTION INC, 2011 But the numbers are

    too big to be relatable But the numbers are too big to be relatable
  14. ffunction inc. © FFUNCTION INC, 2011 So we just display

    the rounded numbers in billion dollars So we just display the rounded numbers in billion dollars
  15. ffunction inc. © FFUNCTION INC, 2011 And can already see

    that the average is below the max And can already see that the average is below the max
  16. ffunction inc. © FFUNCTION INC, 2011 A visualization could help

    understand the trends A visualization could help understand the trends
  17. ffunction inc. © FFUNCTION INC, 2011 REMARK #1: There is

    a big increase to the max around the end of the timeline REMARK #1: There is a big increase to the max around the end of the timeline
  18. ffunction inc. © FFUNCTION INC, 2011 REMARK #2: Average grows

    seems regular, with a slight inflexion around the middle of the timeline REMARK #2: Average grows seems regular, with a slight inflexion around the middle of the timeline
  19. ffunction inc. © FFUNCTION INC, 2011 REMARK #3: The min

    doesn't really take off REMARK #3: The min doesn't really take off
  20. ffunction inc. © FFUNCTION INC, 2011 A visualization of the

    whole data gives more explanation about what we've noticed A visualization of the whole data gives more explanation about what we've noticed
  21. ffunction inc. © FFUNCTION INC, 2011 INSIGHT #1: India is

    going to do better than the #1 in 2029 INSIGHT #1: India is going to do better than the #1 in 2029
  22. ffunction inc. © FFUNCTION INC, 2011 INSIGHT #2: Somewhere around

    2023, India, China and the rest of Asia are each going to outperform the US INSIGHT #2: Somewhere around 2023, India, China and the rest of Asia are each going to outperform the US
  23. ffunction inc. © FFUNCTION INC, 2011 INSIGHT #3: South America,

    Middle East and Africa are not really taking off INSIGHT #3: South America, Middle East and Africa are not really taking off
  24. ffunction inc. © FFUNCTION INC, 2011 We could have started

    by looking at the data directly, but sometimes it's too to easily spot interesting trends We could have started by looking at the data directly, but sometimes it's too to easily spot interesting trends
  25. ffunction inc. © FFUNCTION INC, 2011 STEP 3: WHAT'S THE

    STORY? ➔ TURN INSIGHTS INTO A STORY We've found three different interesting things, now how can we communicate them visually?
  26. ffunction inc. © FFUNCTION INC, 2011 This visualization actually doesn't

    tell a really different story from the original data itself, as North America was conveniently close to the X axis This visualization actually doesn't tell a really different story from the original data itself, as North America was conveniently close to the X axis
  27. ffunction inc. © FFUNCTION INC, 2011 Focusing on just Asia,

    we put the highlight on 2023, where India, China, and the rest of India lead the way Focusing on just Asia, we put the highlight on 2023, where India, China, and the rest of India lead the way
  28. ffunction inc. © FFUNCTION INC, 2011 While Japan stays stable

    and brings another perspective to the picture While Japan stays stable and brings another perspective to the picture
  29. ffunction inc. © FFUNCTION INC, 2011 We tell an alarming

    story of the decline of today's big economies (compared to India). The end of the world as we know it will be 2023 We tell an alarming story of the decline of today's big economies (compared to India). The end of the world as we know it will be 2023
  30. ffunction inc. © FFUNCTION INC, 2011 Looking at the growth,

    we tell the optimistic story of the growth and rise of Sub-Saharian Africa Looking at the growth, we tell the optimistic story of the growth and rise of Sub-Saharian Africa