Strata: Kathryn Hurley and Simon Rogers

Making it public (More than just Google spreadsheets) Open data journalism by Kathryn Hurley My week at the Guardian. How the Guardian Makes Data Useful Think Like a Data Journalist Data merging tools. Sometimes the data isn't enough.. Get the data. Tell the story. What I learned. Visualize. Company's sales figures Government websites World Bank Google's Public Data Explorer Supplement with other data Spreadsheet Relational database Google Fusion Tables Share the data. What you can learn. Clean the data. Helpful tools. Google Refine DataWrangler How we can help. Map tools. Chart tools. Google Fusion Tables Google Maps API CartoDB Google Spreadsheets DataWrapper Tableau source: OECD Accessible online. Tools. Google Spreadsheets Google Fusion Tables Google BigQuery *source: ONS Thanks! Simon Rogers @smfrogers +Kathryn Hurley News drives the stories Data journalism moves fast Quick & easy tools reign supreme Know what's important. In the Sales department Website metrics Global news "It was long ago in my life as a simple reporter that I decided that facts must never get in the way of truth" James Cameron Numbers need context Investigate Research Write and report Engage Reveal and expose What does a journalist do? Investigate Research Write and report Engage Reveal and expose What does a data journalist do? Expose the data behind every story Open the games Sharing the best Less code Single data format xxxxxx xxxxxxx xxxxxxx xxxxxxx a typical week New ways of telling a story source: UK Department of Educaion