Training Courses

Data Journalism : Introduction

  9 reviews

One Day Course

Overview

Data-driven journalism is the increasingly popular process of analysing and filtering data to find new stories or different angles on existing stories. This is a one day course that will teach journalists to how use the powerful data-analysis tools in Microsoft Excel to assess data from different sources and look for stories within the facts.

This course assumes a working knowledge of Excel, if you do not have that, we can run a tailored course for you. Please call to discuss this option. This is not a course that will teach you to write a story, if you wish to hone your writing skills, you should consider taking our Introduction to Feature Writing or Introduction to News Writing courses as well. To attend this course you need a working knowledge of Excel. You should be able to create and format your own spreadsheets and workbooks and create formulas. If you don't know Excel, we can run a tailored course for you. Please call to discuss this option.

Public Course Dates & Pricing

Course DatesLocationPriceStatus
SOLD  OUT SOLD  OUT


  • Public Courses

    Small class sizes so you get the maximum amount of trainer time possible. You attend with delegates from other companies.

    A great, cost efficient way to learn, discounts are also available for group bookings.

     

    Discount Info
  • Private Courses

    One to one tuition or a private group with just your colleagues. Your choice of duration, content and location. We can train at one of our centres or onsite with you wherever you are located.

    We offer a free consultation service to help work out every detail and build the perfect course for you.

    From £545 + VAT

    Free Consultation

Course Outline

  • Introduction
    • What is Data Journalism?
    • Why is there such an increase in Data Journalism?
    • Examples of good Data Journalism
    • Merging technical knowledge and journalism

    Mission critical Excel skills
    • How to use Excel to find stories
    • Conditional formatting
    • IF and LOOKUP
    • Sorting
    • Auto-filtering data
    • Constructing a drop-down menu
    • Turning records into a table

    Pivot tables and journalism
    • Why journalists need pivot tables
    • Creating a pivot table
    • Auto-filtering data
    • Constructing a table
    • Moving fields around
    • Various ways of displaying values
    • Manoeuvring fields around the table
    • Creating different results and tables from the same spreadsheet
  • Finding data online
    •Turning online text into a spreadsheet
    •Finding data journalism sources online
    •Preparing third-party spreadsheets for your analysis
    •Recognising data entry errors and how to repair them
    •When to add your own data columns to a spreadsheet
    – and how to use them to analyse data

    Finding Stories in the Data
    •Asking the right questions
    •Analysing the data in different ways
    •Finding new story ideas
    •Looking for the hidden story

    Questions and answers
Experience + Flexibility

We know training inside out. We can advise you on all the options to make sure you get the best possible course.

Tell us you need to cancel 5 working days before your course and there’s no charge. Great for your peace of mind.

Our trainers bring their years of industry experience into the classroom. You'll leave confident and prepared.

The smallest class size in the industry. More one on one time with the trainer and a less intimidating group size.

Tell us which you use and it'll be booted up and waiting with the latest software when you arrive.

We provide a lovely onsite lunch so you can relax. We can cater for any dietary requirement with no fuss.

Comfort + Location
Reputation + Feedback

Our Clients


We've worked very hard over the last 20 years to grow our business through personal recommendations.

When you attend a course we ask you to tell us how it went. We use your feedback to help us improve our courses.

We publish all our customer satisfaction stats live on our site (good or bad) because we want everyone to know just how highly you rate us every day, every week and every year.

We know that choosing the best course can be difficult, maybe the thoughts of the 7525 other clients we've asked will give you the inspiration to join us too.

The most recent comments from attendees of our courses are shown below. We reckon they will give you a pretty good indication of how they think we perform.

  Client Ratings

Attendees surveyed7525
  Trainer Knowledge9.8 / 10
  Trainer Materials9.6 / 10
  Trainer Preparation9.8 / 10
  Overall Trainer Score9.7 / 10
  Centre Lunch9.6 / 10
  Centre Staff9.9 / 10
  Overall Centre Score9.7 / 10
  Overall Experience9.6 / 10
  % Who Would Recommend Us99.7%

  Recent Feedback




"Moving through a lot of information, explaining it clearly. Excellent teaching. "



"Great practical training on pivot tables - very clear and lots of unexpected resources like Twdocs"



"Course was very informative and useful. "



"Everything was really well explained and the one-to-one tuition was very valuable. "