In 2019, the Department was responsible for overseas spending of over £950m
We’ve been working with the Department for Science, Innovation and Technology (DSIT) to help them track spending on overseas aid, or Overseas Development Assistance (ODA)
Monitoring spending on overseas aid is important for the organisations that manage ODA, and for people who care about transparency around how the UK’s aid money is being used.
We hope that people in the UK and around the world who need to track aid spending will be able to build on the foundations we have laid when developing their own services.
Outcome
Working with the Department we created a new digital service, Report ODA (RODA), which makes it much easier to gather information and track the projects and programmes being delivered.
This is a long term project, with the first real users submitting their reports on the system in late 2020. We have continued to develop and make iterative improvements to the service since then.
Information is published to the International Aid Transparency Initiative (IATI) data standard which aims to improve consistency in the way data on aid spending is published around the world. As more organisations adopt the standard, it becomes easier for people to use the data and take a global view.
What we did
The Department works with delivery partners like the UK Space Agency, the Academy of Medical Sciences, and the Royal Society to allocate and track a proportion of the UK’s ODA spending.
Tracking ODA has traditionally been a slow and painful process with delivery partners having to fill out a fairly complicated spreadsheet every quarter and submit it by email. It wasn’t straightforward to automatically validate what a user had entered, and a meticulous review process was needed to prevent data quality issues creeping in.
The Department also communicated with delivery partners via email to resolve any queries or issues, and people were able to create copies of the original spreadsheet, making it harder to establish a single version of the truth.
In building the new RODA service, we have resolved data quality issues like missing fields or invalid dates, as well as reducing the effort needed to fill in, review and approve these reports.
What we learned
Conforming to the IATI standard was one of the most challenging parts of this project.
Creating data standards is about forging consensus over time, and that can be a tough and messy process. Publishing against a data standard isn’t always easy either. It can take a lot of effort to align what you already do against a common standard, and it’s likely to mean some compromises.
At dxw, we strongly believe this is an investment worth making. It makes it much easier for people and organisations to get value from your data. Anyone working with the IATI standard will immediately understand the ODA data, and that makes it far more likely that people will use it to create interesting and useful things.