dashboard page template for tableau on Procurement Purchasing Purchasing Supplier Dependencies data visualization dataviz

 

Presentation

This dashboard pages shows an analysis of your supplier dependencies.

It is composed of three sections:

  • Products purchased per number of vendors
  • Single Supplier Dependencies
  • Savings Opportunities

 

Products purchased per number of vendors

This data visualization shows the number of distinct Suppliers you have for each item you purchase.

The first row shows one circle per item, categorized by number of distinct Suppliers. colored by Purchasing Category.

The second row shows the cumulated Purchasing Volume per number of distinct Suppliers.

 

Single Supplier Dependencies

This table highlights which items present a Single Supplier Dependency, meaning that you have only one unique supplier for those items.

For those items, you might consider having at least one other Vendor:

  1. Reduce risks of break in delivery chain
  2. Leverage competition and get better value for money.

 

In the table, you can visualize:

  • The item name
  • The (unique) Vendor
  • The minimum price for this item over the analyzed period
  • The Average Buying Price
  • The maximum price for this item over the analyzed period
  • Then, the △ and △% between Minimum and Maximum Price

 

Savings Opportunities

This table highlights for which items you have more more then 4 distinct Vendors.

For those items, you might consider consolidating your purchases on less suppliers. This will generate more volume per Vendor, thus you will be in position to negotiate better conditions.

In the table, you can visualize:

  • The item name
  • The number of Vendors
  • The Average Buying Price per Vendor (colored by Price, Sized by Volume)
  • The minimum price for this item over the analyzed period
  • The Average Buying Price
  • The maximum price for this item over the analyzed period
  • Then, the △ and △% between Minimum and Maximum Price

 

Filter on Date

This data visualization comes with a filter on the Date value. This feature enables you to focus on the period you are interested in.

You can filter dates at multiple levels: Day, Week, Month, Quarter or Year.

 

Filter your data

This data visualization comes with four top filters:

In your Purchasing dashboard, you will be able to filter on:

  • SupplierName of your supplier
  • Purchasing CategoryPurchasing category
  • Buyer / PurchaserBuyer name, Buying unit...

Other DataViz in "Purchasing" Pack

Home

Purchasing Home

Purchasing Home
Purchasing Home Purchasing Home
Get a Home Page for your Purchasing dashboard

Cockpit

Purchasing Cockpit

Purchasing Cockpit
Purchasing Cockpit Purchasing Cockpit
Gain full spend visibility on your purchasing process: What is our Purchasing Volume? What about Savings? What are our top Purchasing Categories? What are our top purchased products? Did we purchase them at the right price? How many suppliers to we work with?

Purchasing Analytics

Top Items - Pricing Analysis

Top Items - Pricing Analysis
Top Items - Pricing Analysis Top Items - Pricing Analysis
Purchasing performance of your top items (Purchasing Volume, Average Buying Price & Variation, Savings, Number of Suppliers): What are our top purchased products? Did we purchase them at the right price?

Supplier Dependencies

Supplier Dependencies
Supplier Dependencies Supplier Dependencies
Optimize your procurement strategy by quickly figuring out the number of distinct suppliers you have for the items your purchase: How many distinct suppliers do we have per Product? For which products do we have a Single Supplier Dependency? For which products do we have too many suppliers and potentially savings opportunities?

Price Volume Mix Analysis

Price Volume Mix Analysis
Price Volume Mix Analysis Price Volume Mix Analysis
Price Volume Mix variance analysis enhances standard variance analyses by decomposing how volume or pricing changes of our product assortment contributed to the difference in performance between the Actual and Reference values

Consistency between Price & Volume

Consistency between Price & Volume
Consistency between Price & Volume Consistency between Price & Volume
Overview of the evolution of Average Buying Price by Product compared to the evolution of Total Purchase Quantity over the same period

Items Purchasing Classification

Items Purchasing Classification
Items Purchasing Classification Items Purchasing Classification
Instant classification of your purchased items by Volume & Price Volatility

Item Detail

Item Detail
Item Detail Item Detail
Get an efficient overview of the purchasing history of a given item/product: Min/Max Prices, Vendors, evolution of Prices, evolution of Volume...

Behavioral Analytics

Purchasing Adhoc Analysis

Purchasing Adhoc Analysis
Purchasing Adhoc Analysis Purchasing Adhoc Analysis
Perform simple ad-hoc analysis on your Purchasing data set: analyze any of your KPIs across any dimension (trends, distribution and pareto analysis)

Other Dashboard Templates