LogoLogo
Procurement Data Crash Course
Procurement Data Crash Course
  • About this course
    • Course introduction
  • Module 1: How the public procurement process works
    • 1.1 Understanding the public procurement process
      • ❓Why the public procurement process exists
      • ⚖️What rules govern the public procurement process?
      • ⚙️RFQ or RFP? An introduction to the different types of tender
      • 📋The key stages of the procurement process
        • 📑Stage 1: Planning
        • 🚴‍♂️Stage 2: Initiation
        • ✔️Stage 3: Selection & award
        • 🤝Stage 4: Contract
        • 🏗️Stage 5: Implementation
      • 🛡️Why monitoring the procurement process is important
      • Test yourself: Understanding the public procurement process
    • 1.2 What does procurement data look like?
      • 💰Budgets & IRPs
      • 📃RFPs & RFQs
      • 🏆Awards
      • 📖Annual Reports
      • 🏛️The Auditor General's report
    • 1.3 Where is public procurement data published?
      • 🔍Where to find procurement data
      • 📚Maintaining your own library of procurement data
    • 1.4 Procurement oversight and monitoring for NPOs and media
      • ✋Procurement oversight guide for CSOs
      • 📺Procurement oversight guide for media
  • Module 2: Working with procurement data
    • 2.1 Whey we need machine readable data
      • Important data formats: CSVs, Excel and Google Sheets
    • 2.2 Turning websites and PDFs into machine readable data
      • Scraping data with Tabula
      • Simple web scraping with Google Sheets
      • Web scraping by inspecting network traffic
  • Useful resources and libraries
    • 3.1 Procurement data online resources
      • Importance reference resources
      • Online data repositories
  • Course testing & feedback
    • 🎓Extended course exam
    • 📝Surveys & feedback
    • ⏱️Quick course exam
  • MODULE4: Explore the OCPO procurement dashboard
    • 4.1 A walk through the OCPO COVID-19 reporting dashboard
      • Summary and Supplier page of the dashboard
      • Find supplier information from external sources
      • Navigating COVID19 Item Spend Page
      • Navigating the Transactions List Page
    • 4.2 Keep the Receipts Tool
      • Background and Introduction
      • Download data from Keep the Receipts
    • 4.3 Using KeeptheReceipts and Google Sheet for Procurement Data Analysis
      • Infrastructure Order Analysis
      • Mask Price Analysis
Powered by GitBook
On this page
  1. Module 1: How the public procurement process works
  2. 1.3 Where is public procurement data published?

Maintaining your own library of procurement data

PreviousWhere to find procurement dataNext1.4 Procurement oversight and monitoring for NPOs and media

Last updated 2 years ago

In the previous topics, we've looked at where procurement data is available and noted the problems that are inherent in the way that RFPs, RFQs and the like are shared. Reading one PDF is straightforward, trying to analyse information from several similar PDFs is very hard.

Many tenders are just a few pages long, some have multiple technical documents and appendices ().

For this reason, as you work with procurement documents, it is highly likely that you will want to create your own system for storing procurement data which is both searchable and comparable. OpenUP, for example, takes information published by National Treasury around Covid-19 procurement efforts and makes it easily accessible and downloadable in CSV format at .

A library could be as simple as a shared folder of documents on Dropbox or Google Drive, or it could be an SQL database or CSV file.

This kind of project can require specialised resources, but enabling others to build on your work helps to promote transparency and scrutiny of the procurement process. You'll find some advice on .

📚
acquiring data in this lesson
like this 35 document package from Eskom
Keep The Receipts