David Donald teaches data journalism
From Excel to SQL - in five days intensive training learn how to manage datasets and find stories.
City University London
3 October 2012 - 7 October 2012
This course is now full and we are no longer taking registrations, however, we plan to run another course early next year so if you are interested, please email: firstname.lastname@example.org
This five-day workshop on database journalism is designed for reporters with little or no knowledge of data journalism and will give you a foundation in the essential skills.
Full price: £500
NUJ member: £375
SQL only (last three days): £300.
This five-day workshop in data journalism, also known as computer-assisted reporting, is designed for reporters with little or no knowledge of data journalism and gives a foundation in the essential skills. By the end of the workshop, attendees will be able to produce data-driven, evidence-based stories and investigations that will make a difference in their newsrooms and the communities they serve.
Reporters who have some spreadsheet skills but need to learn how to manage and use larger data sets can attend this portion of the workshop at a reduced cost. The last three days will take their existing skills to a new level, giving them the ability to make greater impact with database-driven stories.
Please get in touch with Minal: email@example.com
if you have any questions.
Topics and skills covered during the workshop include:
- Spreadsheet analysis to make sense out of numbers;
- The basics of data management and SQL;
- Finding, importing and cleaning data for stories;
- Connecting data-driven evidence to narrative reporting;
- Seeing data as part of web-based storytelling;
- Award-winning, database stories and how they were produced;
- Time to work on your own data project;
- Suggestions of how to make data journalism work in your newsroom;
- Taking the skills back to your newsroom.
- Open Lab
Reporters who identify and bring data from their beats and areas of interest to the workshop, will get one-on-one time with the trainers at the end of each day to start and develop their data analysis.
About David Donald
David is the data editor at the Center for Public Integrity in Washington. His interests include financial, housing and healthcare analysis and new tools for data analysis. Prior to joining the Center in 2008, he served as training director at Investigative Reporters and Editors and the National Institute for Computer Assisted Reporting for five years. He uses data analysis to uncover fraud and governmental abuse. His stories have won three Batten Awards and two Hammet Awards for ethical and courageous journalism.
But Don’t Just Take Our Word For It
“David has been teaching data journalism in the UK since before any newspaper had a single data specialist – let alone data teams. His expertise is matched by his methodial, laid-back and humorous teaching style, which five years ago helped me grasp the basics of what has since become my trade. Now David is over the in the UK trying – for what I think is the first time – the multi-day training previously only on offer in the US, I think that’s a great opportunity for anyone keen on this fast-developing field.”
James Ball data journalist the Guardian
“David Donald single-handedly opened my eyes to the power of computer-assisted reporting. His CAR training is the reason many of us do the work we do and find stories that otherwise would go unreported. From the first “aha-moment” in Excel years ago, David has been an expert guide and a patient teacher. A true master!”
Cynthia O’Murchu, investigative reporter at the FT
Read Cynthia's stories for the FT found using data journalism techniquest (no charge but registration required):
Please note: All our courses are scheduled to go ahead subject to a minimum number of attendees signing up. The minimum number for each course differs and this is just to enable us to cover costs of the training venue and trainer fees where applicable.