Accessibility Settings

color options

monochrome muted color dark

reading tools

isolation ruler

Tag

excel

2 posts

Data Journalism

Data Journalism Top 10: A Stunning COVID Data Blunder, Beautiful News, Arctic Fires, Eviction Abuses, Isolating Students

The advancement of technology and availability of complex data tools has been a real boon to society, but utilizing the wrong tools for the job can have dire consequences. Our NodeXL #ddj mapping from October 5 to 11 finds British media organizations the BBC and the Guardian reporting on a blunder by the English national health authority: it used the wrong Excel file format to store data, resulting in the loss of thousands of COVID-19 test data results. Meanwhile, German television news program ZDF heute highlighted how the Arctic has reached record high temperatures this year, DCist and Spotlight DC examined problems in the process of evictions, and we find Information is Beautiful offering a daily feed of uplifting news among the gloom of 2020’s news cycle.

Data Journalism Methodology Reporting Tools & Tips

My Data Is Dirty! Basic Spreadsheet Cleaning Functions

In an extract from his book Finding Stories with Spreadsheets Paul Bradshaw explains how to use basic cleaning functions in spreadsheets to make it easier to combine data, including a case study where the same functions were used to speed up a research process for a story.