How to Find, Analyze, and Apply Aid Data

November 4, 2015
Dustin Homer, Paige Kirby, Josh Powell
Aid Effectiveness & Management, News/Events, Open Data

The global community, as represented at the Open Government Partnership (OGP) Summit and beyond, has made strides toward producing a variety of open data, including open aid data. Aid transparency was among the first open data ‘pushes’ in the global development space – leading to a wide range of government, civil society, and donor-sponsored portals. As the open data movement has expanded to include budgetary, contracting, and other sources of information, we felt it was fitting to reflect about how to access and understand where to locate and how to interact with aid data resources.

Opening up aid data requires both political and technical support. The Open Aid Partnership has been working to ensure that open aid commitments are included in country National Action Plans, and the Government of Liberia has included two such commitments in their second action plan. On the technical side, initiatives such as the International Aid Transparency Initiative are working to make these data portals more interoperable and useful, whether for interaction with national budget or other datasets.

So how can we leverage these portals for better analysis and decision making? One of the first steps is understanding how these resources can complement, enrich, and sometimes correct each other.

Let’s take the example of government-validated data from Malawi’s Aid Management Platform (AMP), and donor-reported data from the IATI datastore. Both are included in this Excel download, if you’d like to follow along (note: some data processing, including currency standardization and XML to Excel conversion, has already been performed on the datasets).

<p>AMP and IATI</p>

Figure 1: Examples of data about African Development Bank (AfDB) activities in Malawi from Malawi’s AMP (top) and the IATI Datastore (bottom).

As you can see, AMP (total commitments and disbursements by year) and IATI (transactions) data here are represented a bit differently — this pre-processing was done to save time, as our data exercise focuses on comparing annual figures by funder.

<p>Field Completeness</p>

Figure 2: Analysis of key field completeness.

Over DG’s years of partnership with country government aid data users, we have identified several common key fields critical for ministries of finance and planning. The good news is, for the sub-set of IATI publishers included in this dataset, almost all of those key fields are populated — meaning that IATI data gaps don’t necessarily preclude its inclusion for a more complete picture of aid flows in country, where more funding is available through IATI than AMP.

<p>Comparison by funder</p>

Figure 3: Comparison of AMP and IATI data for selected funders.

In the case of Malawi, not all funding data match well between the IATI and AMP sets; in fact, when we run a comparison between commitment and disbursement numbers, we can find significant differences in reported figures. Some of these discrepancies relate to the timeliness issues highlighted before; other times, differences can be traced to how headquarters may classify funds (i.e., by including overhead or administrative expenses) versus how country offices report funds (i.e., actual amount disbursed in country); based on DG experience, completeness of AMP reporting also tends to correlate with whether or not the donor has official representation in-country. This means that, on the basis of the figures above, IATI data would be a boon to government and development partner users to provide more information about activities by, for example, Canada and UNICEF.

This AMP-IATI exercise aimed to simply scratch the surface of how we as the open data community can interact with aid data. However, better understanding the resources available – as well as the benefits, pitfalls, and nuances of each – can help us improve the way in which open aid data is collected, compared, and ultimately used to make development finance more efficient and effective.

This post is based on Development Gateway’s OGP Summit 2015 workshop session on “How to Find, Analyze, and Apply Aid Data”.

Share This Post

Related from our library

DG’s Open Contracting Portal Designated as a Digital Public Good

Digital Public Goods Alliance designated DG’s Open Contracting Portal as a digital public good in September 2022. The Portal provides procurement analytics that can be used to improve procurement efficiency and, in turn, reduce corruption and increase impact.

December 6, 2022 Open Contracting and Procurement Analytics, Process & Tools
Photo by Adrian Infernus via Unsplash
DG at the African Green Revolution Forum (AGRF)

Representatives from Development Gateway: an IREX Venture (DG) will be attending the African Green Revolution Forum (AGRF) from September 5-9 in Kigali, Rwanda to highlight two projects: the Visualizing Insights on African Agriculture (VIFAA) project and the Farmer-Centric Data Governance Models project.

September 1, 2022 Agriculture
“Data…for What?!:” Expanding into Education, Media/Disinformation & Youth

In Episode 2 of "Data…for What?!," a podcast series from Development Gateway: an IREX Venture (DG) which explores our new strategic plan, Josh Powell met with experts from DG and IREX to discuss DG’s expansion into the education, media and disinformation, and youth sectors. The conversations explore the most pressing challenges and greatest opportunities for data and technology to positively impact these sectors and discuss how these trends are likely to play out in the years ahead. Based on these trends, the experts explain the unique fit for DG’s skills and specific opportunities for collaboration that align with the vision of DG’s partnership with IREX, which has a long and successful history working in each sector.

August 16, 2022 Team