open-contracting / bi.open-contracting.org Goto Github PK

Chart details:

• Type: Single Line Chart
• Title: Proportion of awards with competitive contracting processes over time
• Description: Identify which times of the year does competition suffer.
• X-axis → Month and year
• Y-axis → Proportion of awards

Additonal details:

• Timestamp to use the date of the compiled release.
• Zoom into shorter time periods.

Tile details

• < Number > and < Percentage > Contracting processes with collusion red flags

Tile details:

• < Number > and < Percentage > Buyers with contracting processes with competition red flags

Tile details

• < Number > and < Percentage > Buyers with contracting processes with 3+ competition red flags

Chart details:

• Type: Horizontal bar chart
• Title: Top bidders with the highest number of red flags
• Description: Identify who are the bidders with the highest number of red flags. Note that bidders may become suppliers.
• X-axis → Count of red flags
• Y-axis → Bidder name

Chart details:

• Type: Scatter plot
• Title: Prices over time for item category
• Description: Identify price disparity in specific item categories.
• X-axis → Month & Year
• Y-axis → Unit Price ($USD)

Additional details:

• Chart is for a specific item category only.
• Users can select the item category using a dropdown.

Chart details:

• Type: Horizontal bar chart
• Title: Number of unique suppliers for a contracting process per item category
• Description: See which item categories are more likely to end up with multiple suppliers contributing to fulfilling a contract.
• X-axis → Number of unique suppliers
• Y-axis → Item category

Additional details:

• Only the top 10 bars to be displayed. ‘See all’ button to view in a table.
• This considers all tenders not only competitive ones.
• Add in a tooltip: Number of contracting processes for the specific item category

Tile details:

• < Number > and < Percentage > Contracting processes with competition red flags

Tile details:

• < Number > and < Percentage > Buyers with contracting processes with collusion red flags

Chart details:

• Type: Single line chart
• Title: Contracting processes with red flags detected over time
• Description: Visualise the overall trend to see if the number of contracting processes with red flags is getting better or worse over time or if there are specific times of the year when red flags are more likely to occur.
• X-axis → Month and year
• Y-axis → Proportion of contracting processes with red flags

Additional details:

• Timestamp to use the date of the compiled release
• Zoom into shorter time periods

Chart details:

• Type: 2-Slice Pie Chart
• Title: Proportion of contracting processes with red flags
• Slice A → Contracting processes with red flags
• Slice B → Contracting processes with no red flags

Tile details:

• < Number > and < Percentage > Bidders with ‘supplier’ red flags

Chart details:

• Type: Box plot
• Title: Price distribution per item category
• Description: Compare the unit price distribution between different item categories.
• X-axis → Item category
• Y-axis → Unit price

Additional details:

• One box plot for each price category. Users can select the item category using the dropdown.
• Users can select up to 5 item categories to compare.
• Include only item categories with a reasonable number of procedures. We need to check the data to select the threshold.

Tile details:

• < Number > Total bidder red flags detected

Tile details:

• < Number > and < Percentage > Bidders with red flags

Chart details:

• Type: Horizontal bar chart
• Title: Buyers with highest proportion of contracting processes with competition red flags
• Description: See which buyers have a higher proportion of competition red flags
• X-axis → %
• Y-axis → Buyer name

Additional details:

• Exclude buyers with very few procedures. Check in the data what is the reasonable threshold. Eg. > 100 procedures.
• Only the top 10 bars with the highest proportion are to be displayed.

Tile details:

• Title: < Number > Types of red flags found (X out of Y)

Additional details:

• This is not the count of red flags (which can be in the thousands), rather how many of the different red flags have been detected (R022, R023, R024, R028, R025, R034 etc...)

Tile details:

• Title: < Number > and < Percentage > Awards with competitive contracting processes

Chart details:

• Type: Horizontal bar chart
• Title: Mean number of bidders for a contracting process per item category
• Description: See if there are item categories that are more competitive than others.
• X-axis → Mean number of bidders
• Y-axis → Number of unique bidders

Additonal details:

• Only the top 10 bars to be displayed. ‘See all’ button to view in a table.
• Add in tooltip: number of contracting processes for the specific item category.
• Need to check if there are outliers, e.g item categories with very few procedures and a high average, to evaluate if we should filter only for top item categories.

Tile details:

• < Number > Mean unique red flags per supplier

Table details:

• Title: List of historical bidders and awarded suppliers by item categories
• Description: This table lists for a specific item category, who have been the historical bidders and awarded suppliers. Start by selecting the item category from the dropdown.

Filters:

• Item category
• Bidder name
• Region

Columns:

Chart details:

• Type: Single Line Chart
• Title: Proportion of total value awarded in competitive contracting processes over time
• Description: Understand the amount of public spending that goes on competitive contracting processes.
• X-axis → Month and year
• Y-axis → Total value of awards ($1,000)

Additional details:

• Add in a tooltip: “Proportion and total amount.”

Chart details:

• Type: Horizontal bar chart
• Title: Collusion red flags frequency
• Description: Identify which collusion red flags are most prevalent.
• X-axis → Number of contracting processes flagged
• Y-axis → Red flag name

Table details:

• Title: List of contracting processes and details of competitiveness.
• Description: This table lists contracting processes and details of the competitiveness of those contracting processes.

Filters:

• Ocid
• Buyer name
• Item category
• Date
• Competitive contracting process

Columns:

Tile details:

• Title: < Number > and < Percentage > Bidders with red flags

Additional details:

• This calculates the proportion of bidders that have +1 red flags.

Chart details:

• Type: Horizontal bar chart
• Title: Buyers with the highest proportion of contracting processes with 1+ collusion red flags
• Description: Identify which buyers have a higher risk collusion occurring.
• X-axis → Proportion of contracting processes with collusion red flags (0-100%)
• Y-axis → Buyer name

Additional details:

• Only the top 10 bars to be displayed. ‘See all’ button to view in a table.
• Add tooltip with number of procedures.
• Exclude buyers with very few procedures. Check in the data what is the reasonable threshold. Eg. > 100 procedures.

Chart details:

• Type: Horizontal bar chart
• Title: Market concentration per item category
• Description: See which item categories have a higher market concentration. A market with a HHI index above 2500 is considered highly concentrated.
• X-axis → Market Concentration HHI index (0-10,000)
• Y-axis → Item category

Additional details:

• Only the top 10 bars with the highest market concentration are to be displayed.
• The tooltip should indicate the number of contracting processes for that particular item

Tile details:

• < Number > and < Percentage > Bidders with ‘collusion detection’ red flags

Chart details:

• Type: Single Line Chart
• Title: Proportion of single bid tenders over time
• Description: See if there are seasonal patterns in the proportion of tenders that only have a single bidder. Note that you can have a competitive process, but still only have a single bidder.
• X-axis → Month and year
• Y-axis → Proportion of awards

Additional details:

• Calculate this only for competitive contracting proceses.

Chart details:

• Type: Horizontal bar chart
• Title: Item categories with a higher proportion of contracting processes with collusion risk
• Description: Identify if there is a higher collusion risk in specific item categories
• X-axis → Proportion of contracting processes in item category with collusion detection red flags (0-100%)
• Y-axis → Item category

Additional details:

• Only the top 10 bars to be displayed. ‘See all’ button to view in a table.

Chart details:

• Type: 2-Slice Pie Chart
• Title: Proportion of contracting processes with red flags now completed
• Slice A → Contracting processes with red flags still in progress
• Slice B → Contracting processes with red flags now completed

Additional details:

• When the user clicks on a slice, only data for that segment to show in the other charts and for this to be highlighted.
• Data labels with percentage and value should show upon hover.

Chart details:

• Type: Horizontal bar chart
• Title: Item categories with a higher proportion of price related flagged contracting processes
• Description: Identify which item categories have a higher proportion of contracting processes with price related red flags.
• X-axis → Proportion of contracting processes in item category with price red flags
• Y-axis → Item category

Additional details:

• Only the top 10 bars to be displayed. ‘See all’ button to view in a table.
• Red flags are tender value higher or lower than average, items with unreasonable prices.
• Add tooltip for the number of contracting processes for the item category.

Tile description

• < Number > Total unique bidders

Chart details:

• Type: 2-Slice Pie Chart
• Title: Proportion of value awarded in single bid tenders vs competitive tenders
• Slice A → Proportion of value awarded to single bid tenders ($000 USD)
• Slice B → Proportion of value awarded to competitive tenders ($000 USD)

Additional details:

• Data labels with percentage and value should show upon hover.

Table details:

• Title: List of contracting processes with collusion red flags
• Description: This table lists all contracting processes with collusion red flags. Identify the riskiest contracting processes by sorting the list.

Filters:

• Ocid
• Buyer name
• Item category
• Date range
• Status

Columns:

Tile details:

• < Number > and < Percentage > Contracting processes with tender value higher or lower than average

Tile details:

• Title: < Number > and < Percentage > Contracting processes with red flags

Tile details:

• < Number > and < Percentage > Bidders with ‘competition’ red flags

Chart details:

• Type: Vertical Bar Chart
• Title: Contracting processes by number of red flags it has
• Description: Identify the contracting processes that have multiple risks through the count of red flags that are associated with them.
• X-axis → Number of red flags (1, 2, 3, 4, 5+)
• Y-axis → Count of contracting processes

Additional details:

• Bars should all be the same colour.

Tile details:

• Title < Number > Mean bidders per tender in competitive processes

Tile details:

• Title: < Number > and < Percentage > Contracting processes with red flags detected over time

Table details:

• Title: List of contracting processes that procured a particular item
• Description: This table lists all of the contracting processes that have procured a particular item. Each contracting process can have multiple items and different quantities of an item.

Filters:

• Ocid
• Buyer name
• Procurement method
• Procurement method details
• Date range
• Status
• Item category

Columns:

Tile details:

• Title: < Percentage > Single bid tenders

Chart details:

• Type: Horizontal bar chart
• Title: Competition red flags frequency
• Description: See which competition red flags are most common.
• X-axis → Contracting processes with ‘competition’ red flags
• Y-axis → Red flag name

tile details:

• < Percentage > Contracting processes with items with unreasonable prices

Table details:

• Title: List of item categories and details of their price distribution
• Description: This table lists for all item categories, details of their unit price distribution and the number of procedures. You can use this table to identify average unit prices and market concentration.

Filters:

• Item category

Columns:

Tile details:

• < Number > and < Percentage > Contracting processes with 3+ competition red flags

Table details:

• Title: List of contracting processes with competition red flags
• Description: This table lists all contracting processes with competition red flags. Identify the riskiest contracting processes by sorting the list.

Filters:

• Ocid
• Buyer name
• Item category

Columns:

Chart details:

• Type: Horizontal Bar Chart
• Title: Most prevalent red flags for contracting processes
• Description: See the prevalence of the different red flags in contracting processes being tracked to understand what kind issues are more common.
• X-axis → Count of red flags
• Y-axis → Red flag name

Additional details

• Only the top 10 bars to be displayed. ‘See all’ button to view in a table.
• The bars of the four categories of red flags ‘competition’, ‘collusion detection’, ‘related suppliers’ and ‘prices’ need to be different colours.

Tile details:

• Title: < Number > and < Percentage > Buyers with contracting processes with red flags

Additional details:

• This calculates the number and proportion of buyers that have +1 contracting processes flagged