Data Journalism for Beginners: A UK Reporter's Guide

Data journalism is one of the most in-demand skills in UK newsrooms, yet many reporters feel intimidated by it. The truth is that the most impactful data stories often rely on nothing more complicated than a spreadsheet and a good question. The Bureau of Investigative Journalism, the BBC Shared Data Unit, and regional newspapers across Britain are all producing excellent data journalism — and with the right approach, so can you.

Where to Find UK Data

The UK has some of the best publicly available datasets in the world. Knowing where to look is half the battle. Here are the key sources every UK reporter should bookmark:

Office for National Statistics (ONS): The UK's largest independent producer of official statistics. Covers population, employment, health, crime, housing and much more. The ONS website allows you to download data in CSV and Excel formats, and its NOMIS service provides detailed labour market data by local authority
data.gov.uk: The UK government's open data portal, hosting over 50,000 datasets from across government. Includes everything from school performance data to environmental monitoring
NHS Digital: Health data for England including hospital performance, prescribing data, and workforce statistics. Prescribing data is particularly rich — you can see exactly which drugs are being prescribed in every GP practice in England
Police.uk: Street-level crime data for England, Wales and Northern Ireland. Can be downloaded as CSV files for analysis
Companies House: Free access to company filings, accounts and director information. Essential for investigative reporting
Local authority data: Council spending, planning applications, FOI disclosure logs and more. Quality and accessibility vary enormously between councils

Essential Spreadsheet Skills

You do not need to learn Python or R to do effective data journalism. Google Sheets or Microsoft Excel will handle most reporters' needs. The key skills to master are:

Sorting and filtering: The most basic but powerful technique. Sort data to find the highest and lowest values; filter to focus on specific categories or time periods
Pivot tables: These allow you to summarise and cross-tabulate large datasets. For example, you could use a pivot table to show total crime by type for each local authority
VLOOKUP and INDEX/MATCH: These functions let you combine data from different sources. For example, matching crime data with population data to calculate crime rates per capita
Percentage change: Essential for putting numbers in context. The formula is (new value - old value) / old value * 100
Basic statistics: Mean, median, mode and standard deviation help you understand the shape of your data and identify outliers

Google offers free training through its Google News Initiative data journalism courses, and the European Journalism Centre provides excellent online resources specifically for journalists.

Visualising Data with Datawrapper

Datawrapper is a free tool used by newsrooms including the BBC, the Guardian and the Financial Times. It allows you to create publication-ready charts, maps and tables without any coding knowledge. To get started:

Create a free account at datawrapper.de
Paste or upload your data — Datawrapper accepts CSV, Excel and Google Sheets links
Choose a chart type — bar, line, pie, scatter, map or table
Customise the design, add annotations and source credits
Publish and embed the chart in your article

Other useful free visualisation tools include Flourish (excellent for animated and interactive visualisations), RAWGraphs (for unusual chart types) and Google Data Studio (for dashboards). The key principle is to choose the simplest chart type that tells your story clearly — a well-designed bar chart is almost always better than a flashy but confusing 3D visualisation.

Using FOI to Get Data

Not all useful data is publicly available. The Freedom of Information Act 2000gives you the right to request data held by public authorities. FOI is one of the most powerful tools in the data journalist's toolkit, but it requires patience and strategy.

Ask for data in a structured, machine-readable format (CSV or Excel) rather than PDF
Be specific about the fields, time period and geographic scope you need
Check the authority's disclosure log first — the data may have already been released
If you need the same data from multiple authorities, use WhatDoTheyKnow.com to send batch requests efficiently
Be prepared for refusals citing cost — if your request would exceed the cost limit (18 hours of work for central government, 24 hours for local authorities), narrow your scope

Storytelling with Numbers

Finding interesting data is only half the job. The other half is turning it into a story that readers care about. The best data journalism combines rigorous analysis with compelling narrative:

Lead with the human impact. A statistic about hospital waiting times becomes a story when you find the patient who waited 18 months for surgery
Provide context. Raw numbers are meaningless without comparison. Is this number going up or down? How does it compare to other areas? What is the national average?
Localise. National datasets can be broken down to local authority, parliamentary constituency or postcode level. Local angles drive engagement
Be honest about limitations. Every dataset has gaps, inconsistencies and caveats. Acknowledge them in your reporting
Show your working. Where possible, make your data and methodology available to readers. Transparency builds trust

Common Pitfalls to Avoid

Data journalism carries specific risks that every beginner should be aware of:

Correlation is not causation. Just because two trends move together does not mean one causes the other
Small sample sizes. Be cautious about drawing conclusions from small numbers. A 100 per cent increase sounds dramatic, but not if it means going from one incident to two
Cherry-picking. Do not select only the data points that support your hypothesis. Good data journalism follows the evidence wherever it leads
Misunderstanding rates and ratios. Always check whether you are looking at raw numbers or rates. Crime may be rising in absolute terms but falling per capita if the population has grown

Data journalism is a skill that improves with practice. Start small — pick a dataset, explore it, and see what stories it contains. Every story you produce will build your confidence and your toolkit. The free tools available to UK journalists make it easier than ever to get started.