Explainers are one of the most widely used forms of ‘evergreen’ content. In this unpublished extract from the latest edition of the Online Journalism Handbook, removed due to word limit, I explore why they are so popular, what types of subject are suitable, and how explainers are structured.
Continue readingA few months ago I delivered a webinar for the European Data Journalism Network and DataNinja about the range of ways that journalists can use ChatGPT and other generative AI tools — from idea generation and mapping systems to help with spelling and coding — and what issues they need to be aware of.
The video is now available online and you can watch it below.
In this latest post in the FAQ series, I’ve been asked to help answer a question on the “ethical dilemmas faced by news organisations when considering the use of AI in reporting stories“.
Continue readingPlanning an investigation, or any larger editorial project, raises its own particular challenges — but if you know where to look, you can find resources that are especially useful in anticipating and tackling those.
This video, made for students on the MA in Data Journalism at Birmingham City University, introduces and explores two such resources: Mark Lee Hunter‘s story-based inquiry method; and breaking down an investigation into five roles; . It also touches on issues to consider in undercover reporting or the use of subterfuge.
Further video clips of Mark Lee Hunter and Luuk Sengers are embedded below:
Continue reading
It’s over a decade since I published the Inverted Pyramid of Data Journalism. The model has been translated into multiple languages, taught all over the world, and included in a number of books and research papers. But in that time the model has also developed and changed through discussion and teaching, so here’s a round up of everything I’ve written or recommended on the different stages — along with a revised model in English (shown above; versions have been published before in German, Russian and Ukrainian!).
The most basic change to the Inverted Pyramid of Data Journalism is the recognition of a stage that precedes all others — idea generation — labelled ‘Conceive’ in the diagram above.
This is often a major stumbling block to people starting out with data journalism, and I’ve written a lot about it in recent years (see below for a full list).
The second major change is to make questioning more explicit as a process that (should) take place through all stages — not just in data analysis but in the way we question our sources, our ideas, and the reliability of the data itself.
Alongside the updated pyramid I’ve been using for the past few years I also wanted to round up links to a number of resources that relate to each stage. Here they are…
Continue reading
One of the most common challenges in a data-driven story is combining two sets of data — such as events and populations — to put a story into context. In an extract from the ebook Finding Stories in Spreadsheets, I explain how to use lookup functions to combine two tables. The longer ebook version of this tutorial includes a dataset and exercise to employ these techniques.
Combining data is often a great way of telling new stories about spreadsheets. For example: you may have one table showing pass rates for each school in an area, and another table showing their addresses. Combining these would allow you to identify geographical patterns, or to place them on a map.
You could also combine the addresses with poverty rates for different locations, or unemployment to see if there’s a possible relationship (remembering that correlation does not equal causation), or to identify the schools performing particularly well despite local conditions. In the video below, for example, I walk through an example of combining data on different sports teams’ attendances with data on their rankings, allowing you to see who’s attracting large crowds despite their poor performance.
The VLOOKUP function is one of the most widely-used tools in combining data in this way. It stands for Vertical lookup, and means that the spreadsheet will look up and down a column (i.e. vertically) for whatever you ask it. In more recent versions of Excel the XLOOKUP function has been introduced to make the process easier — but the process is similar for both.
Continue readingIn this latest post in the FAQ series, I’ve been asked to help answer a question on “the distribution of work between journalist, data analyst and designer” in data journalism.
Continue readingAutomation was key to the work of data journalism pioneers such as Adrian Holovaty — and it’s becoming increasingly central once again. This video, made for students on the MA in Data Journalism at Birmingham City University, explores the variety of roles that automation plays in data journalism; new concepts such as robot journalism, natural language generation (NLG) and structured journalism; and how data journalists’ editorial role becomes “delegated to the future” through the creation of algorithms.
You can find the video about Poligraft, and the FT on robot journalism at those links.
This video is shared as part of a series of video posts.
A new, third, edition of the Online Journalism Handbook is now out.
A comprehensive update to the 2017 second edition, it sees the addition of a new chapter on writing for email and chat.
There are new sections on formats from scrollytelling and charticles to threads, vertical Stories, social audio and audiograms, plus advice on how to use gifs, memes and emoji professionally as a journalist.
One notable development of the last few years reflected in the book is the improvement in accessibility provision — which is covered alongside techniques for better inclusivity and diversity in journalism practice.
Developments around harassment and online abuse, misinformation, news avoidance, and trust are all covered — and, of course, the impact of the pandemic on journalistic practices, including remote interviewing tips.
I’ll be publishing extracts and the material I had to leave out (it’s 20,000 words longer than the last edition) in the coming months.
Está disponível em língua portuguesa meu e-book ‘Jornalismo de dados: um guia rápido.’
Traduzido pela jornalista brasileira Amanda Maia, a publicação segue a linha de raciocínio de meu outro livro ‘Excel for journalists’ ou ‘Excel para periodistas’ (tradução espanhola). E está disponível nos formatos PDF, Kindle e para iPad.
Online Journalism Blog 