Archives

The best podcasts about data journalism

Image by Carla Pedret© Podcasts are a great way to find stories and to be entertained. However, have you ever thought about using them to learn data journalism? In this list, I have collected some of the best podcasts about data. Some are specifically about data journalism, whereas others approach data from an innovative perspective. ProPublica Podcast ProPublica interviews every week …

How to: open a CSV file with Excel

(Image by r2hox/Flickr) CSV – comma separated values  – is a common format for datasets. Excel or the free spreadsheet software Google Sheets can open them easily and, in some cases, automatically. Open your CSV file with Excel. You will get a messy data set without format, but don’t panic: that is how a CSV should look like. Select …

Basic maths for data journalists to find stories in spreadsheets

Image by Tom Brown/Flick

Image by Tom Brown/Flickr Data journalists should know how to use Excel or the free spreadsheet software Google sheets to clean and process data. Some data sets will tell us a story with only some sorting or creating a pivot table while others require some maths. In this post, you will find some examples of basic formulas to analyse data and find stories …

15 Twitter accounts every data journalist should follow

Image by Carla Pedret© Anyone interested in data journalism – also called data-driven journalism or #ddj – should know who are the experts in the field. Twitter is a good place to follow them and also to find training, tips and inspiration. The following list compiles 15 Twitter accounts from all over the world that every data …