Data Journalism Spring Bootcamp

    Data journalism using Excel

    From Excel to SQL - in five days intensive training learn how to manage datasets and find stories in your data.

    City University London
    25 April 2012 - 29 April 2012

    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.

    Course fees:
    Full price: £500
    NUJ member: £375
    Student: £250
    SQL only (last three days): £300.

    Course Outline

    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: 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):
    Britain’s Private Care Faces Crisis
    BP Failures Heighten Fears at North Sea Risk