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
Full price - £275
Student - £155
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:
Professor Stuart Hall Building
Goldsmiths, University of London, Lewisham Way, New Cross,
London SE14 6NW
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.
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
14:00 Excel 2, including formulas, cleaning, OpenRefine
15:00 Pivot tables
16:00 The story memo
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
14:00 to 16:00 working on data-driven story ideas with support from trainers
16:00 Discussion on next steps
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.
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.