Use

Good data is a means to an end, not an end in itself. So how can you put it to work to improve procurement? This section offers a host of resources to get you started finding, evaluating and analyzing open contracting data in real-world situations to help you set and measure your open contracting reform goals.

BEGIN

Explore open contracting data using common tools

The first step in using data that has been published according to the Open Contracting Data Standard (OCDS) is to learn how to access and manipulate OCDS data. This section introduces a variety of tools that can help you get started using OCDS data using your preferred formats and methods.

LEARNING LAB
Getting & Exploring OCDS Data with Google Sheets

In this learning lab, work through a hands-on exercise where you will: get a bulk spreadsheet OCDS dataset from a publisher, explore the dataset using Google Sheets, and generate insights from the OCDS datasets using Google Sheets features.

LEARNING LAB
Using the Flatten Tool

This learning lab covers how to make use of the our flatten tool to convert your data from .JSON format to a .CSV format or vice versa.

DATA TOOL
Flatten Tool colab notebook for non-technical users

This notebook is designed to help our non-technical users with download OCDS data from different publishers and flatten it to a spreadsheet format. It provides guidance on getting OCDS data, downloading bulk data, using Kingfisher collect and flattening JSON data to xls format.

Analyze, visualize, and interpret contracting data

Once you know how to access and explore OCDS data, let’s put it to work from spreadsheets to R and many things in between, this section covers popular tools and methods to start turning your data into insights you can act on.

LEARNING LAB
Advanced OCDS analysis with Excel (beta)

Excel is one of the most common spreadsheet packages: most people have at least some experience using it. The goal of this lab is to show you how to use this widespread tool to get insight into contracting data that is published using OCDS in spreadsheet formats.

BLOG
From JSON to visualization: Analysis and process guidance for OCDS data

This post in our technical series explores a particular trend around the use and analysis of OCDS data, along with our reflections from analyzing OCDS data published by the UK’s Crown Commercial Service (CCS).

GUIDE
R for OCDS

The goal of this manual is to provide the basic foundations needed to analyze and visualize Open Contracting data using the R programming language to people that might be interested in pursuing this challenging but worthy endeavor. A basic understanding of computer programming will come in handy when reading this document; however, enough guidance is provided to ensure that less-tech-savvy readers can also follow along.

GUIDE
Visualizing OCDS data with Kibana

This guide has been created to increase the use and impact of data publication, import OCDS and analyze them visually and intuitively. Although all the examples are based on the Mexican case, we provide you with instructions to import any dataset that meets OCDS standard.

Apply open contracting data to real-world situations

The resources in this section help guide you through applying open contracting data to real-world scenarios such as measuring procurement performance, red flags to track malfeasance or mistakes by authorities, and quality control of information.

GUIDE
How can OCDS help to assess the quality and performance of a procurement system? A step-by-step guide

Excel is one of the most common spreadsheet packages: most people have at least some experience using it. The goal of this lab is to show you how to use this widespread tool to get insight into contracting data that is published using OCDS in spreadsheet formats.

LEARNING MATERIAL
Indicators to diagnose the performance of a procurement market

This document details a list of common indicators for an initial diagnosis of the performance of a procurement market using public procurement data, providing key information on different aspects of the contracting process. The main indicators proposed describe the level of competition and the internal efficiency of the processes, and signal potential risks and areas of improvement.

GUIDE
Red flags for integrity

In this introductory guide, learn how countries can reference their procurement data against a set of over 150 suspicious behavior indicators, or “red flags.” These flags occur at all points along the entire chain of public procurement-from planning to tender to award to the contract, itself, to implementation-and not just during the award phase, which tends to be the main focus in many procurement processes.

Learn more…

Publish

Learn how to publish data according to Open Contracting Data Standard (OCDS)

Learning Library

A searchable collection of all of our learning resources

Need custom training?

Get in touch with us to arrange a conversation

Explore our learning library

A searchable collection of all of our learning resources