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
  • Incomplete summary
  • Click on a slice of the pie to filter
  • Supplier Page of the COVID19 dashboard
  1. MODULE4: Explore the OCPO procurement dashboard
  2. 4.1 A walk through the OCPO COVID-19 reporting dashboard

Summary and Supplier page of the dashboard

Previous4.1 A walk through the OCPO COVID-19 reporting dashboardNextFind supplier information from external sources

Last updated 2 years ago

Incomplete summary

The first page of the dashboard is a summary of transactions during COVID-19, including the number of orders, etc.

Note that this summary doesn’t contain all orders during COVID-19. By scraping the last page —— Transaction List of the dashboard, we get over 49k orders in August 2022. However, this front page only contains 1250 orders.

Until late 2021, this page still contains most of the orders. It seems the department has decided to filter out some orders recently. But we don’t know the standard for such filtering.

Click on a slice of the pie to filter

Now let’s have a look at this summary page. In the pie chart on the left, it’s the top payments to supplier. Clicking on one slice of a pie is similar to a filtering function. All information on the cards on the top will show information about this specific order.

If we are interested in Digital Vibes, how can we find more information about it?

Supplier Page of the COVID19 dashboard

Within the dashboard, the fourth page is dedicated to supplier analysis. Click on Supplier Analysis. Once the page is loaded, we could click on the drop-down box and type in “Digital Vibes” to search. Note that all of the drop-down boxes on this dashboard allow you to search.

On the supplier analysis page, there is the Central Supplier Database (CSD) Registration number of the company. However, the database is not open to the public, so it’s hard for us to use the information.

Other information includes the directors of this company and the order and payment amount to this supplier. From the search, we could see Digital Vibes has four directors and their names

If we are interested in more information on Digital Vibes. There are a few external websites that we could use to look up this company.

Skip the next part if you already knows how to do this with Biz Portal and B2BHint

From this dashboard, we can tell Digital Vibes is the biggest supplier. There has been between Digital Vibes and the Department of Health.

a big scandal