My third data journalism ebook, Finding Stories With Spreadsheets, is now finished. It’s a book which covers a wide range of spreadsheet techniques from basic calculations like proportions through to techniques for merging datasets, looking for errors and working with dates.
I’ve tried to cover all the functions used most commonly within data journalism, including some specific to Google Sheets, but if you know of any that aren’t mentioned, or have a problem which isn’t solved by the book, I’d love to know.
Likewise, many chapters have sample datasets to try the techniques out, but I’m always on the lookout for particularly illustrative datasets or examples.
I’ll continue to add to and update the book (one of the reasons I publish with Leanpub) as I come across new techniques and examples. Let me know if you want me to add anything.
My ebook Data Journalism Heist is now available in a specially reduced Spanish translation.
Periodismo de datos: Un golpe rápido was translated by Cuban journalist Barbara Maseda, and is available in PDF, iPad and Kindle formats. The recommended price is $5.99 but a special minimum price of $1.19 is available for journalists working in countries where the full price would be too expensive.
The publication follows the release of the Spanish version of my book on Excel for journalists, Excel para periodistas, earlier this year.
A Spanish translation of my ebook ‘Finding Stories in Spreadsheets’ is now live. The book is available for an initial special discount price of $4.99 for ‘early adopters’.
Meanwhile, I’m continuing to add chapters to the English version, which you can download from here. The latest chapters deal with using query-based URLs in Google Sheets, and generating random numbers for mapping.
A Spanish version of Finding Stories in Spreadsheets – titled ‘Excel para periodistas’ (Excel for Journalists) – should be available in the next few weeks.
The translation is being done by Barbara Maseda. If you want to know when it’s going to be available you can register to be informed on the book page.
Cover design by Matt Buck/Drawnalism
My latest ebook – Finding Stories in Spreadsheets – is now live on Leanpub.
As with Scraping for Journalists, I’m publishing the book week-by-week so the book can be updated based on reader feedback, user suggestions and topical developments.
Each week you can download a new chapter covering a different technique for finding stories, from calculating proportions and changes, to combining data, cleaning it up, testing it, and extracting specific details.
There’s also a downloadable spreadsheet at the end of each chapter with a series of exercises to practise that chapter’s technique and find particular stories.
Along the way I tackle some other considerations in telling the story, such as context and background, and the importance of being specific in the language that you use.
If there’s anything you’d like covered in the book let me know. You can also buy the book in a ‘bundle’ with its sister title Data Journalism Heist, which covers quick-turnaround techniques for finding stories in spreadsheets using pivot tables and advanced filters.
In a few weeks I will begin publishing my new ebook: Finding Stories In Spreadsheets.
The book has been written in response to requests from journalists who need a book on Excel aimed at storytellers, not accountants.
Finding Stories In Spreadsheets will outline a range of techniques, including ways to find the ‘needle in the haystack’ in text data, number calculations to make stories clearer, and methods of cleaning and combining data to tell new stories, including getting data ready for maps and charts.
The book will be available for a discounted rate for the first couple of weeks. To be informed when it’s available, register your interest on the Leanpub page.
In the next couple of months I will begin publishing my next ebook: Data Journalism Heist.
Data Journalism Heist is designed to be a relatively short introduction to data journalism skills, demonstrating basic techniques for finding data, spotting possible stories and turning them around to a deadline.
Based on a workshop, the emphasis is on building confidence through speed and brevity, rather than headline-grabbing spectacular investigations or difficult datasets (I’m hoping to write a separate ebook on the latter at some point).
If you’re interested in finding out about the book, please sign up on the book’s Leanpub page.
Meanwhile, I’m looking for translators for Scraping for Journalists – get in touch if you’re interested.