GIJC23 Resources
Here are the tipsheets and presentations shared by speakers at the Global Investigative Journalism Conference in 2023.
Session | Track | GIJN Resources | GIJN Tipsheets and Stories | Speakers’ Presentations & Tipsheets | Speakers |
|---|---|---|---|---|---|
Watchdog Journalism in the Age of Digital Subversion | Keynote Speech | Presentation by: Ron Deibert | Ron Deibert |
||
Best Practices in Teaching Data Journalism to Professionals and Students | Academic | Brant Houston; Jennifer LaFleur; Pinar Dag |
|||
Research on Cross-Border Collaborations and Hybrid Journalism | Academic | Presentations by: Edoardo Anziano | Edoardo Anziano; Jairo Alfonso Lugo-Ocando |
||
Academic Research on Investigative and Data Journalism | Academic | Gerry Lanosga; Jason Martin; Alessio Cornia; Dimitri Bettoni |
|||
Research on Challenges to Women in Investigative Journalism | Academic | Presentations by: Maria Konow Lund | Jay Black; Maria Konow Lund |
||
Research on Threats to Investigative Journalists in Africa and Globally | Academic | Presentations by: Gerry Lanosga | Gerry Lanosga; Ermias Mulugeta |
||
Best Practices in Teaching and Training of Investigative Reporting | Academic | Presentations by: Myungju Lee | Brant Houston; Anuška Delić; Myungju Lee; Mark Lee Hunter; Mark Horvit |
||
Research on the Challenges for Investigative Reporting in Africa | Academic | Sandra Pitcher; Olunifesi Suraj; Francis Nyonzo; Komi Aziadouvo; Nicola Jones |
|||
Research on Investigative Journalism Adapting to New Technologies | Academic | Presentations by: Richard Mensah Adonu & Nausheen Husain | Nausheen Husain; Richard Mensah Adonu; Redeemer Buatsi |
||
Research on Challenges for Investigative Reporting in the Arab World | Academic | Manasar Alharethi; Ahmed Makharesh |
|||
Research on Challenges for Investigative Journalism in Asia | Academic | Anton Harber; M. C. Rasmin |
|||
Tracking Assets Around the World | Business & Finance | Oleg Khomenok; Lara Dihmis; Ian Casewell |
|||
Following the Money, from Laundromats to Central Banks | Business & Finance | Paul Radu; Marty Steffens; Musikilu Mojeed; Alia Ibrahim |
|||
Reading Company Documents | Business & Finance | Nick Mathiason; Lara Dihmis; Ted Jeory |
|||
Digging into Government Contracting: Finding Patterns, Tracking Corruption, Telling Stories | Business & Finance | Presentations by: Adenike Aloba Geog Neumann Jamilya Maricheva Tatiana Velásquez Archibold Tipsheet: Georg Neumann | Georg Neumann; Adenike Aloba; Tatiana Velásquez Archibold; Jamilya Maricheva; |
||
The New Organized Crime | Crime & Corruption | Cecilia Anesi; Paul Radu; Giulio Rubino; Anabel Hernandez; Bertil Lintner |
|||
Investigating War Crimes | Crime & Corruption | Yanina Korniienko; Sophia Jones; Nick Waters; Sarah El Deeb; Denis Dzidic; Ron Haviv |
|||
Holding Algorithms Accountable Through Collaboration | Data | Boyoung Lim; Gabriel Geiger; Lam Thuy Vo; Garance Burke |
|||
R and Statistics | Data | Robert Gebeloff; Jennifer LaFleur; Luuk Sengers |
|||
Using Free Google Data Tools | Data | Marcus Lindemann |
|||
Using Social Network Analysis for Investigations | Data | Brant Houston |
|||
The Basics of Python | Data | Analyzing Data – Python Data Journalism: GIJN’s Global Guide to Resources, Visualization Tools | Pamela Duncan; Anna Leach |
||
Creating and Using Credible Surveys for Investigations | Data | Max Donheiser; Miriam Lenz |
|||
The Basics of Cleaning Data | Data | Nils Mulvad; Jeff Kelly Lowenstein |
|||
Environmental Investigations: Forensic Work with Geo Data | Data | Presentations by: Fernanda Wenzel | Kuek Ser Kuang Keng; Jelter Meers; Gustavo Faleiros; Fernanda Wenzel |
||
Doing Visualizations in R | Data | Robert Gebeloff; Luuk Sengers |
|||
Finding Stories in Documents: Text Analysis for Investigative Reporting | Data | Fer Aguirre |
|||
Using QGIS for mapping | Data | Kuek Ser Kuang Keng; Andrew Lehren |
|||
Moving Beyond Basic Python | Data | Pamela Duncan; Anna Leach |
|||
Summarizing Data in Google Sheets by Using Pivot Tables | Data | Tommy Kaas; Andrew Lehren; Mark Horvit |
|||
Using Pinpoint to Organize Unstructured Data | Data | Reinaldo Chaves; Alice de Souza; Eduardo Goulart |
|||
CTRL+F on steroids — A Simple Intro to Regex | Data | Sascha Granberg |
|||
Tips and Tricks on Navigating Cross-Border Corporate Data | Data | Presentations by: Karrie Kehoe | Christopher Guess; Karrie Kehoe |
||
Low-Code Tools for Data Journalism | Data | Juan Pablo Marin Diaz; Marta Ley |
|||
Datadriven Stories 2.0 from Excel to AI | Data | Rune Ytreberg; Liv-Jorunn Håker; Fabrizio Palumbo |
|||
The Basics of Using Google Sheets | Data | Tommy Kaas; Andrew Lehren; Mark Horvit |
|||
How to Create and Use Web Archives for Investigations | Data | Max Harlow |
|||
The Future of Data Journalism: New Analytical Tools, Data Visualization, and AI | Data | Presentations by: Jennifer LaFleur | Brant Houston; Emilia Diaz-Struck; Jennifer LaFleur; Boyoung Lim; Piyush Aggarwal; Mohammed Haddad; Jeff Kelly Lowenstein |
||
Joining Tables with Structured Query Language (SQL) | Data | Helena Bengtsson; Liz Lucas |
|||
Overview of Coding: Basic Principles | Data | Christopher Guess; Helena Bengtsson |
|||
Overview of Scraping (1): Basic Principles Using Python | Data | Nils Mulvad; Tommy Kaas |
|||
Introduction to Excel Spreadsheets | Data | Anuška Delić; John Bones |
|||
Intro to Database Managers: Using DB Browser | Data | Helena Bengtsson; Liz Lucas |
|||
Data-Driven Journalism: A Review of Recent Stories | Data | Brant Houston; Jennifer LaFleur |
|||
Finding Corporate Data for Global Stories | Data | Presentations by: Karrie Kehoe | Christopher Guess; Karrie Kehoe; Karina Shedrofsky |
||
Introduction to Scraping Websites Using Data Miner | Data | Pinar Dag |
|||
Introduction to Datawrapper | Data | Anuška Delić; Robert Gebeloff |
|||
The Power of R: Overview and First Steps | Data | Robert Gebeloff; Luuk Sengers |
|||
Basic Principles for Mapping Data Using QGIS | Data | Kuek Ser Kuang Keng; Andrew Lehren |
|||
Using Pivot Tables in Excel to Summarize Data | Data | Nils Mulvad; John Bones |
|||
Joining Tables with Structured Query Language in Database Managers | Data | Helena Bengtsson; Liz Lucas |
|||
Using Formulas and Data Transformation in Spreadsheets | Data | Liz Lucas |
|||
The Basics of Using R | Data | Robert Gebeloff; Luuk Sengers |
|||
When the Data Aren’t There: Building Your Own Datasets | Data | Helena Bengtsson; Jennifer LaFleur |
|||
The Number: Math You Need as a Journalist | Data | David Cay Johnston |
|||
Overview of Scraping (2): Intermediate Principles Using Python | Data | Nils Mulvad; Tommy Kaas |
|||
Using Flourish for Data Visualizations | Data | Pinar Dag |
|||
Exiled Media: Survival Strategies | Democracy | Olga Simanovych; Joseph Poliszuk; Polina Machold; Tasneem Khalil |
|||
Exiled Media: An Investigative Toolkit | Democracy | Presentations by: Charlotte Alfred | Carlos Dada; Charlotte Alfred; Mahtab Divsalar; Mohammad Bassiki |
||
Investigating Elections | Democracy | Presentations by: Juliana dal Piva | John-Allan Namu; Carole Cadwalladr; Juliana dal Piva; Priyanjana Bengani |
||
Investigations to Save Democracy | Democracy | Vinod Jose; Lina Attalah; Sheila Coronel; Edwy Plenel |
|||
Criminal States & Kleptocracies | Democracy | Presentations by: Peniley Ramirez | David E. Kaplan; Drew Sullivan; Maria Pevchikh; Peniley Ramirez |
||
Tracking Political Extremism | Democracy | Juliana dal Piva; David Baas; Michael Colborne; Hannah Gais |
|||
Investigating Environmental Crime | Environment | Khadija Sharife; Madeleine Ngeunga; Lara Bitar; Caroline Henshaw |
|||
GIJN’s Climate Change Workshop | Environment | Tipsheets: Dharshan Wignarajah Cecile Marchand Matthew Green Amy Westervelt Presentations: Jim Footner Cecile Marchand Matthew Green Madeleine Ngeunga Sunita Narain Leo Hickman Gustavo Faleiros and Jelter Meers Damian Carrington Peter Prengaman Hongqiao Liu Maria Isabel Torres Shamsuddin Illius and Rafiqul Montu Andrés Bermúdez Liévano Amy Westervelt | |||
Climate: Holding Government & Industry Accountable | Environment | Mark Schapiro; Deborah Nelson; Leo Hickman; Amy Westervelt; Damian Carrington |
|||
Investigations into Natural Resources | Environment | Andres Bermudez-Lievano; Joseph Poliszuk; Dianne Hawker; Maxime Domegni |
|||
Climate: Investigating Causes | Environment | Presentations by: Emilio Godoy | Elisangela Mendonça; Emilio Godoy; Gustavo Faleiros; Rhett Ayes Butler |
||
Natural and Human Disaster Investigations | Environment | Roberto Perez-Rocha; Esra Yalçınalp; Paisley Dodds; Iris Yang |
|||
Climate: Investigating Impacts | Environment | Ryan McNeill; Fredrick Mugira; Shamsuddin Illius |
|||
Open Source Reporting — Let’s Get Personal | General | Henk van Ess |
|||
Investigating Indigenous Issues: A Roundtable | General | Presenations by: Vanessa Teteye Mendoza | Bryan Pollard; Tristan Ahtone; Francine Compton; Dev Kumar Sunuwar; Brittany Guyot; Maria Saijets; Vanessa Teteye Mendoza |
||
All an Investigative Reporter Needs to Know about Toxic Narratives | General | Annelie Frank; Andreas Önnerfors; Lifaqane Nare |
|||
Visual Investigations: Reporting Techniques | General | Malachy Browne; Meg Kelly; Yousur Al-Hlou |
|||
Best Investigations on Russia’s War on Ukraine | General | Vivienne Walt; Masha Froliak; Valeriya Yegoshyna; Anna Myroniuk |
|||
Crowd-Driven Journalism: Using Communities to Investigate | General | Presentations by: Marcela Turati | Marcela Turati; Rozina Breen; Aidila Razak; Julia Hildebrand; Priyanka Raval |
||
Rewriting History: Investigations that Change Our Understanding of the Past | General | Presentations by: Kunda Dixit | Kunda Dixit; Catherine Porter; Jose Maria Irujo |
||
How to Use Satellite Images for Investigation | General | Benjamin Strick; Reade Levinson |
|||
Investigating Food & Agriculture | General | Mark Schapiro; Philip Jacobson; Rahma Al Behi |
|||
How to Recruit Secret Sources | General | Ulla Satereie; Axel Gordh Humlesjö; Bastian Obermayer |
|||
Cross-Border Reporting: The Next Steps | General | Miranda Patrucic; Emilia Diaz-Struck; Wahyu Dhyatmika; Laurent Richard; Frederik Obermaier; Margo Smit |
|||
Resources for Investigating the US | General | Martha Mendoza |
|||
Prize Winners: Global Shining Light Award Recipients | General | Carlos Eduardo Huertas |
|||
Masterclass: Mobile Journalism | General | Robb Montgomery; Ayoub Toumi |
|||
Investigative Editing: Best Practices | General | Drew Sullivan; Vinod Jose; Ron Nixon; Alejandra Xanic; Rachel Oldroyd |
|||
FOIA/RTI Investigations | General | Mats Amnell; Amanda Hickman; Luiz Fernando Toledo; Myungju Lee; Miraj Chowdhury |
|||
Lightning Round: Great Stories You’ve Never Heard Of | General | Minna Knus-Galan; Håkon Fostervold Høydal; Milagros Salazar; Inna Gadzynska; Dayo Aiyetan; Mustafa Khalili; Alexandre Brutelle; Apostolis Fotiadis; Feng Zhaoyin; Gaston Sawadogo Jessica Stolzmann |
|||
Paul Myers on Images for Investigations | General | Paul Myers |
|||
Special Interest Media and How To Get Stories Spread | General | Johan Sjöholm; Anneli Megner Arn; Blessing Oladunjoye |
|||
Video Show & Tell | General | Nils Hanson |
|||
Paul Myers on Finding & Investigating People | General | Paul Myers |
|||
Resources for Investigating Russia | General | Roman Anin; Marc Perkins; Maria Pevchikh |
|||
Indigenous Investigations | General | Brittany Guyot; Tristan Ahtone; Graham Lee Brewer; Jocelyn Ting-Hui Hung Chien; Moana Maniapoto |
|||
Masterclass: Investigative Photojournalism | General | Ron Haviv |
|||
Getting People to Talk | General | Jessica Ziegerer; Åsa Erlandsson |
|||
Undercover Investigations | General | Naipanoi Lepapa; Mamdouh Akbiek; Diana Cariboni |
|||
Working With Citizen Investigators | General | David Schraven; Aisha Dabo; César Vega; Maria Fernanda Cruz; George Katz |
|||
40 Years of Cross-Border Muckraking: Where It All Began | General | David E. Kaplan; Nils Mulvad; Brant Houston; Mark Schapiro; Maria Teresa Ronderos; Sheila Coronel |
|||
Presenting Investigations In Innovative Ways | General | Sven Bergman; Erik Palm; Michael Verdicchio; Anna Jaktén; Anna Bergenström |
|||
Podcasts: Producing the Investigative Podcast | General | Presentation: Citra Prastuti | Citra Prastuti; Jose Roberto de Toledo; Susanne Reber |
||
Health Care Investigations | General | Stéphane Horel; Fabiola Torres; Jesmin Papri; Madlen Davies |
|||
Migration & Human Trafficking | General | Presentations by: Pari Saikia | Sally Hayden Paavo Teittinen; Jack Sapoch; Pari Saikia |
||
Tracking Waste & Used Goods | General | Anuška Delić; Minna Knus-Galan; Joachim Dyfvermark; Kennia Velazquez |
|||
State of the Art Research Techniques | General | Syed Nazakat; Karina Shedrofsky; Jelena Cosic; Ude Albrecht |
|||
Investigating Sports – Why and How | General | Emelie Rosén; Annelie Frank; Olof Lundh; Jeppe Laursen |
|||
Lightning Round: Favorite Tools & Techniques | General | Mohamed Zidan; Alexander Abdelilah; Thanasis Troboukis; Manuel Daubenberger; Sanne Breimer; Delphine Reuter; Yevheniia Drozdova |
|||
Investigating Children’s Issues | General | Almudena Toral; Irene Caselli; Martha Mendoza Mariko Tsuji |
|||
Plane and Ship Tracking | General | Emmanuel Freudenthal; Bashar Deeb |
|||
Resources for Investigating China | General | Ying Chan; Alison Killing; Hui (Lulu) Ning; Liu Min |
|||
Putin’s Shadow War | General | Ali Fegan; Axel Gordh Humlesjö; Lisbeth Quass; Maria Georgieva; Niels Fastrup |
|||
Pandemics: Past & Future | General | Katherine Eban; Deborah Nelson; Fabiola Torres; Peter Doshi |
|||
Documentaries: Breaking In | General | Marc Perkins; John-Allan Namu; Phil Rees; Sky Dylan-Robbins |
|||
Help in Emergencies | Safety & Security | Jantine van Herwijnen; Mira Milosevic; Lucy Westcott; Elisabet Cantenys |
|||
Physical Security: Essential Tips for Protection | Safety & Security | Drew Sullivan; Stevan Dojčinović |
|||
Security: Source Protection & JSAT | Safety & Security | Marcela Turati; Jake Charles Rees; Harlo Holmes; Matt Hansen |
|||
Coping with Stress, Trauma, & Burnout (for Managers) | Safety & Security | Kate Porterfield |
|||
Fighting Back Against SLAPPs & Other Legal Threats | Safety & Security | Kunda Dixit; Alexander Papachristou; Bea Bodrogi; Carlos Gaio |
|||
Coping with Stress, Trauma, & Burnout: A Workshop | Safety & Security | Bruce Shapiro; Kate Porterfield |
|||
Dealing with Online Harassment | Safety & Security | Inga Springe; Kennia Velazquez; Melanie Walker |
|||
Don’t Get Stuck in Side Tracks – Get a Plan | Sustainability | Jessica Ziegerer; Emma Johansson; Sofia Hultqvist |
|||
Developing a Business Strategy (Part 1) | Sustainability | Presentations by: Yasmin Namini | Andras Petho; Bilal Randeree; Gina Chua; Yasmin Namini |
||
Freelancing Survival Tips | Sustainability | Sylke Gruhnwald; Mais Katt; Naipanoi Lepapa |
|||
Donor/Grantee Roundtable | Sustainability | Ides Debruyne; Anuška Delić; Bridget Gallagher; Lina Ejeilat; Liz Baker; Amina A. Salihu; Maria Teresa Ronderos; Alinda Vermeer |
|||
Developing a Business Strategy (Part 2) | Sustainability | Yasmin Namini |
|||
Fundraising: Prospecting | Sustainability | Presentations by: Bridget Gallagher | Bridget Gallagher; Karen Martin; Michael Randall |
||
Fundraising: The Craft of Proposal Writing | Sustainability | Bridget Gallagher; Karen Martin; Michael Randall |
|||
Measuring Impact | Sustainability | Anya Schiffrin; Wahyu Dhyatmika; Miriam Wells; Rosemary D’Amour |
|||
How to Spread Watchdog Journalism in Tough Places | Sustainability | Amina A. Salihu; Courtney Radsch; Hasibur Rahman |
|||
How Mainstream Media Profit from Investigative Journalism on Digital Platforms | Sustainability | Kersti Forsberg; Christofer Ahlqvist; Idris Akinbajo |
|||
Cryptocurrency | Tech | Presentation by: Federico Paesano | Paul Radu; Federico Paesano |
||
Masterclass: Digging into Digital Advertising | Tech | Craig Silverman |
|||
Facing AI, Big Tech, & What’s Ahead: How to Futureproof the Global Investigative Journalism Movement | Tech | Anya Schiffrin; Paul Radu; Courtney Radsch |
|||
Digital Threats: A Cyber Investigations Toolkit | Tech | Presentation: Luis Assardo | Craig Silverman; Luis Assardo; Andrea Arzaba; Jane Lytvynenko |
||
Investigating Social Media: Telegram, Twitter, & Whatsapp | Tech | Dinesh Balliah; Luis Assardo; Jane Lytvynenko; Priyanjana Bengani |
|||
Working with Hackers | Tech | Jan Strozyk; Lorax Horne; Alena Prykhodzka |
|||
GIJN Women Networking | Women | ||||
Investigating Femicide | Women | Nikolia Apostolou; Thanasis Troboukis; Fabiola Torres; Janine Louloudi; Laura Grant |
|||
Women in Investigative Journalism: Strategies for Thriving Together | Women | Presentation by: Gabi Manuli | Emilia Diaz-Struck; Jessica Ziegerer; Purity Mukami; Gina Chua; Hui (Lulu) Ning; Kamilla Marton; Zahra Nader; Sarah El Deeb; Oksana Brovko |
||
Data Lightning Talks | Brant Houston; Jennifer LaFleur; Eric Barrett; Claudia Baez; Pauliina Siniauer; Lam Thuy Vo; Mago Torres; Luiz Fernando Toledo; Eva Constantaras; Daiva Repeckaite; Piyush Aggarwal |
||||
AI as a Tool for Investigations | Presentations by: Inas Hamdan | Inas Hamdan; Jelena Cosic; Joseph Poliszuk; Hans Petersson Hammer |
|||
Investigating Asia | Andrea Ho; Sherry Lee; Citra Prastuti; Alison Killing |
This work is licensed under a Creative Commons Attribution-NoDerivatives 4.0 International License
Republish our articles for free, online or in print, under a Creative Commons license.
Republish this article
This work is licensed under a Creative Commons Attribution-NoDerivatives 4.0 International License
Material from GIJN’s website is generally available for republication under a Creative Commons Attribution-NonCommercial 4.0 International license. Images usually are published under a different license, so we advise you to use alternatives or contact us regarding permission.
Here are our full terms for republication. You must credit the author, link to the original story, and name GIJN as the first publisher. For any queries or to send us a courtesy republication note, write to hello@gijn.org.
Read Next
Data Journalism GIJC23 Reporting Tools & Tips
Tips to Guide Investigative Journalists in Document Text Analysis
Investigative journalists often face the challenge of reviewing and combining large documents or data in text forms. This can be very exhausting and labor intensive.
GIJC23 Reporting Tools & Tips
Who’s Behind That Internet Ad?: Tips for Investigating Online Advertising
Global internet advertising revenue is forecast to reach $723.6 billion in 2026. Who makes this money and how they go about it is fertile ground for investigative journalists.
GIJC23 Reporting Tools & Tips
Waste, Fraud, Abuse: Covering the Environmental Crime Beat
Journalists share stories and tips from their investigations into environmental crimes, from deforestation in the Congo to the Beirut port blast.
GIJC23 Reporting Tools & Tips
Investigating Environmental Crimes: Tips From Reporters Covering the Amazon
Two reporters whose investigative work has exposed systemic land grabbing and illegal mining in the Amazon share their tips.