Data-Driven Investigations

    Data-driven Investigations

    From the Panama Papers to Luxleaks; Spotlight to the Iraq War Logs, data journalism is everywhere. If you've heard about it and want to get started in the field, the Centre for Investigative Journalism can help.

    Goldsmiths University of London
    25 February 2017 - 26 February 2017

    Bookings

    Full price - £275
    Student - £155
     

    Book your place

    Course Outline

    This weekend course will take you from an investigative hypothesis, a tip-off, or even just a hunch, and show you where to find the data behind the story; how to interrogate and understand that data to provide the evidence to back your story up; and how to present it to your readers in coherent, accessible and compelling ways. 

    Through demonstrations and hands-on practical skills training our experts will show you techniques and tools required to conduct the thorough research required for hard-hitting investigations.

    On both days, the workshop will be in:

    Room 302,
    Professor Stuart Hall Building
    Goldsmiths, University of London, Lewisham Way, New Cross,
    London SE14 6NW

    See a map of the area for more details.

    Registrations will take place on Saturday at 09.45am and training will begin at 10am and finish around 5pm. Sunday we start at 10am.

    The course will run roughly from 10-5 each day with a break for lunch of an hour, and a short break in the morning and afternoon.

    You will need to bring your own laptop.

    Below is a draft timetable, there may be some changes as we like to keep it flexible to respond to delegates requirements and interests.

    Day 1

    10:00 Introduction to the course, to each other, setting needs and aims

    Intro to Data

    11:00 Excel 1

    12:00 Sources of data

    13:00 Lunch

    14:00 Excel 2, including formulas, cleaning, OpenRefine

    15:00 Pivot tables

    16:00 The story memo

    17:00 Close

    Day 2

    10:00 Exercise revising day 1

    11:00 SQL – why you need it and how to get started

    12:00 How to think like a datajournalist

    13:00 Lunch

    14:00 to 16:00 working on data-driven story ideas with support from trainers

    16:00 Discussion on next steps

    17:00 Close

    About the trainers

    Jonathan Stoneman worked for the BBC for 20 years as researcher, producer, reporter, editor and finally Head of Training at World Service. Specialising mainly in central and eastern Europe, Jonathan reported for World Service from virtually every country of the former Warsaw Pact in the 1990s, before moving on to run the Macedonian and then the Croatian language services. 

    In 2010 Jonathan decided to leave the BBC and become a freelance trainer. Since then he has worked increasingly with data – re-learning MS Excel as a journalistic tool as an introduction to the growing world of datajournalism, and the Open Data movement. 

    Tracking the use of Open Data and learning new techniques to make the most of it has become something between an obsession and a hobby. 

    @stonepeople 

    Leila Haddou is a freelance investigative and data journalist currently working at the Financial Times. She has previously worked for the Guardian covering offshore tax leaks, corporate land banking and issues surrounding social justice. She continues to explore how technology can be used by journalists to assist with data-led investigations. 

    @LeilaHaddou