1 of 14

Catching Fire

Spreading data journalism through the newsroom.

Emma Carew Grovum / @emmacarew

Director, Digital Content Development

Foreign Policy magazine

​

2 of 14

We Can Do Better

Source: https://twitter.com/markles/status/453497435784884224/photo/1

3 of 14

Who Needs Data Training?

  • Reporters
  • Producers
  • Editors
  • Freelancers
  • Artists

​

(aka: everyone)

4 of 14

What Topics?

  • Good Chart, Bad Chart
  • 10 Tips for Excel / Spreadsheets
  • How to Interview Data
  • Which Chart When?
  • Spectrum of Dataviz
  • Data Tools

​

5 of 14

Bad Charts

6 of 14

Welcome to Spreadsheets

  • Total 101 / Step Zero tips
  • .xls > .xlsx > .csv > .tsv
  • Sort, copy/paste, cell formats
  • Formulas: sum, min-max, median, %chg
  • Flat cells (values only)
  • Freeze pane, filter

7 of 14

How to Work with Data

  • Finding datasets
  • Evaluating quality of the data source
  • Enough data / the right data?
  • How to identify dirty data
  • Look for outliers
  • Put the dataset in context with reporting

8 of 14

Different Tutorials

  • Reporters bringing data to producers
  • Producers contributing graphics only
  • Reporters doing their own data
  • Editors working with freelancers
  • Checks and balances for accuracy before publishing

9 of 14

Which Chart When?

Source: http://www.kuangkeng.com/2014/12/11/datan-enabling-small-newsroom-to-produce-data-journalism/

10 of 14

Which Chart When?

11 of 14

Spectrum of Dataviz

12 of 14

Data Tools

  • FP Chartbuilder (Papousek by way of Bowers)
  • FP Datawrapper (Keng from Studio 20)
  • Sankey diagram tool
  • VIS network tool
  • Trading View (stocks charts)

13 of 14

Progress in Baby Steps

14 of 14

Additional Resources

http://lenagroeger.s3.amazonaws.com/talks/nicar-2015/timelines-nicar/tmelines.html