Open Contracting Analytics: Introducing the M&E and Corruption Risk Dashboards

June 7, 2017
Andrew Mandelbaum
News/Events, Procurement

National and local government officials are in a bind: they spend significant proportions of their budgets on procuring goods, works, and services, but know very little about how effectively they are spending these monies. Citizens and businesses, too, have an interest in knowing that government is purchasing wisely, and that participating in public markets is a worthwhile endeavor.

What would these groups want to know about public procurement to ensure that their concerns are being addressed? Questions they might ask could include:

  • Is there a healthy competition for technology procurement that drives down prices?
  • Is the health ministry receiving value for money in the procurement of medicines and routinely used goods, like gauze and syringes?
  • Which procuring entities are most efficient in conducting procurement and are small and medium-sized enterprises (SMEs) getting a fair chance?
  • Are some suppliers colluding with one another, and are they targeting specific types of procurements?

To help explore these and other questions, Development Gateway is pleased to introduce demonstration versions of our procurement Monitoring and Evaluation (M&E) Dashboard and Corruption Risk Dashboard. These demos aim to familiarize users with the functionalities of these open source tools, as well as their scope and flexibility. Visitors can peruse a fictitious data set formatted for the Open Contracting Data Standard (OCDS), a standard format that facilitates comparison and publication of procurement information

OC Explorer

Visit the M&E Dashboard

Fraud Risk

Visit the Corruption Risk Dashboard

The M&E Dashboard

This tool was originally developed in collaboration with the World Bank and Vietnam’s Public Procurement Authority. The demo version contains over 15 analytics that support users’ understanding of procurement competitiveness, value for money, and efficiency. All of the indicators can be filtered, so that users can select their desired procuring entities, suppliers, procurement methods, tender or award amount, and other criteria. A map visualizes tender locations and displays analytics for each one. Additional analytics and filters can be developed to meet user needs.

The Corruption Risk Dashboard

Built with the collaboration and support of the Open Contracting Partnership (OCP), the Corruption Risk Dashboard seeks to identify specific contracting processes that may be susceptible to collusion, fraud, or rigging. This prototype version includes 8 indicators of various corruption risk types, the overlap of which can be viewed on a cross tabulation table. We provide in this dashboard a similar set of filters to those available in the M&E dashboard, in order to study the data in more detail. Contracts with the most flags of each risk type are also displayed, along with charts showing trends over time. The basis for our methodology – along with a number of additional indicators – has been published in a joint report with OCP. All indicators can be easily customized to fit the specific needs of users, including thresholds and eligibility criteria.

The Backend

As we’ve described in the past, DG’s interlinked Open Contracting analytics tools draw data from a common backend. This enables us to store, disclose, and analyze procurement information efficiently and effectively. We pull in data directly from government or other sources, and convert it into OCDS. Once converted, the data can be published in OCDS-compliant JSON or spreadsheet (CSV, XLSX, etc.) format, and be made available for public or internal use. Our MongoDB database has been tested with real life production datasets of more than 1 million tenders (the demonstration features 407,000). It’s ready for immediate deployment, and can easily scale up to include all procurement data coming from a large country, or even an entire region. We perform live analytics on the complete dataset – including all planning, tendering, contracting, and award information – and on all the suppliers and players involved.

For more information about DG’s Open Contracting & Procurement Analytics Program, please review our current programming note; you can also contact Andrew Mandelbaum.

Project Team: Andrew Mandelbaum, Sarah Orton, Mihai Postelnicu, Josh Powell, Alexei Savca, Owen Scott, Llanco Talamantes

Share This Post

Related from our library

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
Introducing: Data… for What?!

To help contextualize the new Strategic Plan, we are launching a podcast series called Data… for What?! This series consists of 5 episodes in Josh Powell and Vanessa Goas talk to DGers throughout the organization – as well as collaborators within our strategic partner, IREX - about how and why we prioritized the various elements of the new strategy. In this first episode, we talk to Kristin Lord, President and CEO of IREX about how our partnership fits into the Strategic Plan; and to Aleks Dardelli, Executive Vice President of IREX and Chair of DG’s Board of Directors, about the process of putting the Plan together at this opportune, yet precarious, global moment.

August 9, 2022 Team