Finding Stories in Spreadsheets
Last updated on 2016-04-16
About the Book
One spreadsheet can tell many stories. You just have to know the right questions to ask.
Based on a decade of training journalists and working with news organisations on data-driven stories, Finding Stories In Spreadsheets outlines the techniques for asking the right questions of data using tools like Excel and Google spreadsheets.
These aren't just questions about numbers: you'll find out how spreadsheet techniques can help you find the 'needle in the haystack' in text data. You'll learn how to clean up and modify your data so that you can ask it different questions, or get it ready for maps or charts, how to create new data from raw materials, and how to combine datasets to look for connections and trends.
With regular examples from journalism and real life data to work with, Finding Stories In Spreadsheets is *full* of those questions, in the language that spreadsheets understand.
Cover image concept by @CarolineBeavon. Illustration by Matt Buck at Drawnalism.
Bundles that include this book
About the Author
Paul Bradshaw runs the MA in Data Journalism and the MA in Multiplatform and Mobile Journalism at Birmingham City University, where he is an associate professor. He publishes the Online Journalism Blog, and is the founder of investigative journalism website HelpMeInvestigate. He has written for the Guardian and Telegraph’s data blogs, journalism.co.uk, Press Gazette, InPublishing, Nieman Reports and the Poynter Institute in the US. Formerly Visiting Professor at City University’s School of Journalism in London, He is the author of the Online Journalism Handbook, now in its second edition, and of Magazine Editing (3rd Edition) with John Morrish. Other books which Bradshaw has contributed to include Investigative Journalism (second edition), Web Journalism: A New Form of Citizenship; and Citizen Journalism: Global Perspectives.
His books on Leanpub include Scraping for Journalists, Finding Stories in Spreadsheets, the Data Journalism Heist, Snapchat for Journalists, and 8000 Holes: How the 2012 Olympic Torch Relay Lost its Way.
Bradshaw has been listed in Journalism.co.uk’s list of the leading innovators in journalism and media and Poynter’s most influential people in social media. In 2010, he was shortlisted for Multimedia Publisher of the Year. In 2016 he was part of a team that won the CNN MultiChoice African Journalist Awards.
In addition to teaching and writing, Paul acts as a consultant and trainer to a number of organisations on social media and data journalism. You can find him on Twitter @paulbradshaw
Other books by this author
The Leanpub 45-day 100% Happiness Guarantee
Within 45 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms...
