The Centre for Investigative Journalism
The Centre for Investigative Journalism
Menu

Pamela Duncan

Pamela Duncan is an award winning journalist, working for the Guardian’s Data Projects team. During the Coronavirus pandemic she’s been specialising in providing in-depth analysis of Covid-19 data in the UK including excess deaths happening in people’s homes/care homes and calling out gaps in the data and delayed or misleading data.

She also writes on a range of topics including health stories, among them an award-winning piece on an NHS data loss, consumer stories on the proportion of betting adverts carried during the World Cup and revelations of Russian trolls’ tweets cited by UK media outlets. She also contributes to the Guardian’s gender pay gap reporting. More recently she has turned her hand to coding, using Python to help create stories around the people affected by Trump’s Zero Tolerance Policy.

Pamela is a very popular data journalism trainer the #CIJSummer Conference. She also taught data journalism skills at some of the world’s leading journalism training events for many years.

Summer Conference Event
 — Talk

Covid-19: A Data Story. UK and Sweden.

Leading data journalists Helena Bengtsson of STV (Sweden), John Burn-Murdoch of the Financial Times (UK), and Pamela Duncan of the Guardian (UK), explain how data analysis plays a crucial part in the coverage of the Covid-19 pandemic.
Summer Conference Event
 — Class

Web Scraping Without Code

How to use the import functions for scraping data into Googlesheets, building a basic scraper with websraper.io and OCR 3 ways.
Summer Conference Event
 — Workshop

Covert Filming

This session on covert filming has evolved over the years into a state-of-the-art technical workshop looking at methods to acquire evidence for public interest investigations. It is taught by a leading undercover technician and an experienced television reporter who discuss the process and ethics of going undercover and look at the latest high-quality equipment.
Summer Conference Event
 — Class

Googlesheets 3

Quick-smart data summary/analysis using pivot tables Merging datasets (VLookUps) Basic scraping using Google’s Import tools
Summer Conference Event
 — Class

Googlesheets 2

Finding your top line: sorting and filtering in Googlesheets/Excel Handy/fun tools: (split, concatenate, currency conversion, translate)
Summer Conference Event
 — Class

Googlesheets 1

Data journalism introduction: overview of the seven building blocks behind data stories The basics: use Googlesheets to carry out basic calculations and percentage increases