The refugee crisis: six ways to visualise the UNHCR data

Image :The flow towards Europe by Lucify

More than a million refugees and migrants came to Europe in 2015, what is considered the worst refugee crisis since the World War II. Visualisations are a powerful way to contextualise the data and analyse the magnitude of the tragedy. In this list I have collected 6 data visualisations projects about the refugee crisis. All of them use …

5 charts you need to see before voting in the EU referendum

Brexit Scrabble (Picture: Jeff Djevdet/Flickr)

The words “Brexit”, “remain ” and “leave” are perhaps the most written and repeated these days in the countdown to the referendum on 23th June. Immigration, workers’ rights or the impact over the economy are some of the hot topics of the debate. Has the EU forced the UK to bring more rights to British …

Interactive map: Explore how gentrification is changing Birmingham’s Jewellery Quarter

Warstone Lane, the centre of Birmingham's Jewellery Quarter (Photo: Carla Pedret)

The Jewellery Quarter is currently undergoing a transformation. Trendy bars and restaurants share space with old factories in a process of gentrification that cause controversy within neighbours and business owners. The Jewellery Quarter Neighbourhood Plan (JQNP) has to lead the metamorphosis of the area and spread the seed for a thriving future. The immediate priorities of the plan are to fight …

How to: use maps effectively to explain stories

Image of the project BIG TIME BCN by 300.000 Km/s about Barcelona’s Heritage Catalogue.

Everybody loves maps, which makes them an attractive tool for journalists. Geography professors Sébastien Caquard and William Cartwright have analysed the relationship between maps and narratives, and they agree that maps are an extraordinary tool to explain stories. “The potential of maps to both decipher and tell stories is virtually unlimited. Maps can contribute to leaving cartographic …

Kumu.io, a data visualisation tool to shape complex relationships

Austin Social Entrepreneurship is one of the projects that has used Kumu.io

As journalists know, connections can be key when investigating a person, company or government. Kumu.io is a free tool to visualise easily relationships or organisational charts. These diagrams can be useful to illustrate a story or to organise notes and findings. How to use Kumu.io First of all, you need to create an account. Go to the main page of …

Common mistakes journalists make when using statistics

Book "How to lie with statistitcs"

Image by Carla Pedret© Statistics are everywhere, and journalists – especially data journalists – should know how to interpret them. Numbers are like any other source, and journalists should have the knowledge to find out when they are misleading. How can journalists improve their use of statistics? What are the most common mistakes? As statisticians are the best ones to answer …

How to: convert KML into other formats with Open Refine

Original image by GotCredit/Flickr

Original image by GotCredit/Flickr Maps are a powerful tool to visualise data because they can explain stories with a high level of detail. You can show the data within countries, regions or even electoral wards. The only thing you need to know is how to work with KML files. The open source data cleaning tool Open Refine can help …

The best podcasts about data journalism

Image by Carla Pedret

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: use Open Refine to open a rebel CSV file

Image by Craig Chew-Moulding/Flickr

Image by Craig Chew-Moulding/Flickr CSV files are a common format when working with spreadsheets. The process to open a CSV file is really easy and usually takes only a couple of minutes, as this tutorial shows. However, what can you do if the standard process fails? You can use Open Refine, a powerful tool that can help …

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 …