Did you find this page helpful?

Thanks for letting us know!

Your feedback has been received! Take our 2-minute survey to give more detailed feedback
Oops! Something went wrong while submitting the form.
The Fundamentals of Data Journalism
Training module

Spreadsheets: How to “interview” data?

Live training:

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

 attendee limit

Register now

Registration closed

As a journalist, you interview a lot of people for your stories. Now, just because you have data, it doesn’t mean that your approach should be any different. Interview it like you would a person!

Created & Presented by:

Media Hack Collective

Attendee limit:

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

Data shouldn’t be taken at face value and is a source of information to be interrogated. In this second module from The fundamentals of data journalism course, you will learn several essential techniques on how to “interview” data.

Module videos

This module contains short videos with accompanying presentations and resources.

Structured data

In a perfect world, data would come in a neatly organised package. Unfortunately, this is not always the case. In this video, you will learn two ways to structure your data ... and how to turn it into a neater, more organised package.

Filtering

Does it feel like you’re searching for a needle in a haystack with your data? "Filtering" is a technique that can help you narrow the focus and find what you’re looking for. We will show you how to use and apply filtering in this video.

Sorting

In this video, we’ll show you how to use a technique called “sorting” to see the largest or smallest values in your dataset in a flash.

Summarising

Summarising data helps you to simplify large amounts of information so that you can see patterns and trends quickly. In this video, we’ll show you two methods that you can use to do this.

Pivot Tables

Pivot Tables is a powerful tool in Google Sheets that can help you use your data to answer questions quickly and easily. Don’t believe us? Watch this video.

Module resources

Download and explore all the resources that are used in this module

Module documents and resources

Sign up for our newsletter