Mid Sweden bundle!
Mid Sweden bundle!
$37.08
Regular Price
$25.00
Bundle Price

Mid Sweden bundle!

Finding Stories in Spreadsheets
Data Journalism Heist
Scraping for Journalists (2nd edition)
The following 3 books are included in this bundle...

About the Bundle

A special bundle for students at Mid Sweden University

  • Share this bundle

About the Books

Finding Stories in Spreadsheets

Finding Stories in Spreadsheets

Recipes for interviewing data - and getting answers
  • 418

    Readers

  • 341

    Pages

  • 93,798

    Words

  • PDF

  • EPUB

  • MOBI

  • APP

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.

Data Journalism Heist

Data Journalism Heist

How to get in, get the data, and get the story out - and make sure nobody gets hurt
  • 573

    Readers

  • 43

    Pages

  • 10,030

    Words

  • PDF

  • EPUB

  • MOBI

  • APP

Data journalism is a key skill for journalists to differentiate themselves in a world where almost anyone can publish, and competition for journalism jobs is fierce.

Whether it's hard stories from government spending and MPs' expenses, or softer stories from sports data, fashion trends or music and social activity, our increasingly digital world is providing a rich range of potential new story sources - and new forms of storytelling too.

This short ebook introduces you quickly to key techniques in finding that data and turning it into stories - through a 'Data Journalism Heist'.

This isn't about the huge investigative projects that you hear about, but the everyday stories that you can do with speed and simplicity. It's about getting in, getting the data, and getting the story out safely. No one gets hurt.

In the process you'll learn about:

  • Sources of data - where to find data stories and leads
  • Typical data stories - how to find simple stories in data
  • Basic spreadsheet techniques - finding the biggest and smallest values; calculating averages and totals.
  • Top techniques for getting stories against a deadline - using filters and pivot tables to get to the story quickly
  • Making a clean getaway - avoiding mistakes in data journalism
  • Telling the story - basic techniques in visualising and humanising your data-led story

As the book is published you'll receive regular updates as you build on previous skills towards the final story. User feedback, examples and ideas will be incorporated as they come in.

Scraping for Journalists (2nd edition)

Scraping for Journalists (2nd edition)

How to grab information from hundreds of sources, put it in data you can interrogate - and still hit deadlines
  • 1,577

    Readers

  • 319

    Pages

  • 98,187

    Words

  • PDF

  • EPUB

  • MOBI

  • APP

Scraping - getting a computer to capture information from online sources - is one of the most powerful techniques for data-savvy journalists who want to get to the story first, or find exclusives that no one else has spotted. Faster than FOI and more detailed than advanced search techniques, scraping also allows you to grab data that organisations would rather you didn’t have - and put it into a form that allows you to get answers.

Scraping for Journalists introduces you to a range of scraping techniques - from very simple scraping techniques which are no more complicated than a spreadsheet formula, to more complex challenges such as scraping databases or hundreds of documents. At every stage you'll see results - but you'll also be building towards more ambitious and powerful tools.

You’ll be scraping within 5 minutes of reading the first chapter - but more importantly you'll be learning key principles and techniques for dealing with scraping problems.

Unlike general books about programming languages, everything in this book has a direct application for journalism, and each principle of programming is related to their application in scraping for newsgathering. And unlike standalone guides and blog posts that cover particular tools or techniques, this book aims to give you skills that you can apply in new situations and with new tools.

About the Author

Paul Bradshaw
Paul Bradshaw

Paul Bradshaw runs the MA in Online Journalism at Birmingham City University, and is a Visiting Professor at City University’s School of Journalism in London. He publishes the Online Journalism Blog, and is the founder of investigative journalism website HelpMeInvestigate. He has written for journalism.co.uk, Press Gazette, the Guardian and Telegraph’s data blogs, InPublishing, Nieman Reports and the Poynter Institute in the US. He is the co-author of the Online Journalism Handbook with former Financial Times web editor Liisa Rohumaa, 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.

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 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

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

Write and Publish on Leanpub

Authors and publishers use Leanpub to publish amazing in-progress and completed ebooks, just like this one. You can use Leanpub to write, publish and sell your book as well! Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks. Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. It really is that easy.

Learn more about writing on Leanpub