The Centre for Investigative Journalism
The Centre for Investigative Journalism
Menu

Pamela Duncan

Pamela Duncan is the editor of the Guardian’s Data Project team, an occasional award-winning journalist (#humblebrag) and a self-confessed data nerd. She can usually be found at her desk poring over spreadsheets and using her coding skills – usually a combination of scraping, regex and pandas/Python – to build and analyse datasets to produce high quality and exclusive data stories. She has worked on a number of international collaborations including the Pandora Papers, Russian asset tracker and The Uber Files.

Pamela is a very popular data journalism trainer at the #CIJSummer Conference despite being an insufferable data evangelist who forces her love of data upon others. She has taught as a visiting lecturer in data journalism at City, University of London and trained journalists at conferences including DataHarvest, GIJC and NICAR as well as Summer School. She has also written a bespoke data curriculum to teach journalists in developing countries.

Summer Conference Event
 — Course

Data Journalism – Google Sheets – Hands-On

This three-part hands-on express data journalism course will introduce you to the basics of data analysis in Google Sheets. Suitable for beginners.
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
 — Course

Web Scraping Without Code

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

Data Journalism – Google Sheets

Googlesheets 1 Data journalism introduction: an overview of the seven building blocks behind data stories. The basics: using Googlesheets to carry out basic calculations and percentage increases. Googlesheets 2 Finding your top line: sorting and filtering in Googlesheets/Excel.
Data Project Editor at The Guardian
@guardian
@PorcelinaD