dashboard page template for tableau on Procurement Purchasing Purchasing Consistency between Price & Volume data visualization dataviz

 

Presentation

This dashboard pages shows a quick overview of the Average Buying Price increase/decrease, compared the the increase/decrease of Total Purchase Quantity.

It is composed of three main sections:

  • Average Buying Price Growth vs Total Purchase Quantity Growth
  • Priority 1
  • Priority 2

 

Average Buying Price Growth vs Total Purchase Quantity Growth

On this dataviz, you can visualize each product categorize in different  segments depending on Total Purchase Quantity and Average Buying Price change:

  • Total Purchase Quantity change
    • INCREASE of Purchase Quantity
    • NO CHANGE in Purchase Quantity
    • DECREASE of Purchase Quantity
  • Average Buying Price change
    • INCREASE of Unit Price
    • NO CHANGE in Unit Price
    • DECREASE of Unit Price

Each product is shown as a circle, sized by Purchasing Volume.

 

Priority 1

This section shows the list of Products/Services for which the Average Buying Price increased while the Total Purchase Quantity also increased.

For those products, you might consider leveraging the increase of Total Purchase Quantity for each Product to negotiate better pricing conditions.

 

Priority 2

This section shows the list of Products/Services for which the Average Buying Price increased while the Total Purchase Quantity decreased.

For those products, you might consider assessing if the increase of Average Buying Price is acceptable for each Product

 

 

Select Current Period

'Current Month' and 'Current Year' selectors allow you to easily select what is the period (month and year) you want to analyze.

 

Select Performance Scope

'Performance Scope' selector allows you to easily switch from one type of Performance Analysis to another.

Just pick-up what you want to analyze:

There are five types of Performance Analysis available:

  • Current Month vs Previous Month (e.g. if you selected Nov-2017 as being your current month, you will analyze Nov-2017 vs Nov-2016)
  • Current Month vs Same Month, Previous Year (e.g. if you selected Nov-2017 as being your current month, you will analyze Nov-2017 vs Oct-2017)
  • Current Month: Actual vs Target  (e.g. if you selected Nov-2017 as being your current month, you will analyze Actual Nov-2017 vs Target Nov-2017)
  • Year-to-Date: Current Year vs Previous Year (e.g. if you selected Nov-2017 as being your current month, you will analyze YTD Nov-2017 vs YTD Nov-2016)
  • Year-to-Date: Actual vs Target  (e.g. if you selected Nov-2017 as being your current month, you will analyze Actual YTD Nov-2017 vs Target YTD Nov-2017)

Note: 'Current Month: Actual vs Target' and 'Year-to-Date: Actual vs Target' are only available in the list if at least one of your KPIs is defined as having a related Target.

 

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