/uploads/galerie/000002/Procurement Cockpit W.png /uploads/galerie/000002/Procurement Cockpit D.png
7 required attributes
  • dateDate
  • stringSupplier
  • stringItem / Product
  • stringPurchasing Category
  • stringBuyer / Purchaser
  • numericPurchased Amount
  • numericPurchased Quantity
8 KPIs
  • Total Purchased Amount
  • Total Purchased Quantity
  • Dist. Items Purchased #
  • Active Suppliers #
  • Buyers #
  • Average Unit Price
  • Amount per Supplier
  • Amount per Buyer

Detailed presentation of the PURCHASING dashboard

Your PURCHASING dashboard will contain 8 KPIs

  • Total Purchased AmountSum of purchased amount
  • Total Purchased QuantitySum of purchased quantity
  • Dist. Items Purchased #Number of distinct items purchased during the period
  • Active Suppliers #Number of distinct suppliers having a purchase transaction during the period
  • Buyers #Number of distinct active buyers during the period
  • Average Unit PricePurchased Amount / Purchased Quantity (expressed in currency)
  • Amount per SupplierPurchased Amount / Number of Suppliers (expressed in currency)
  • Amount per BuyerPurchased Amount / Number of Buyers (expressed in currency)

and 10 dashboard pages

Home

Purchasing Home

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

Cockpit

Procurement Cockpit

Procurement Cockpit
Procurement CockpitProcurement Cockpit
Gain full spend visibility on your Procurement process

Purchasing Top KPIs Evolution

Purchasing Top KPIs Evolution
Purchasing Top KPIs EvolutionPurchasing Top KPIs Evolution
Visualize how your Purchasing KPIs are evolving (Month-to-Date, Year-to-Date)

Purchasing Top KPIs Overview

Purchasing Top KPIs Overview
Purchasing Top KPIs OverviewPurchasing Top KPIs Overview
Get a transversal view on your top 6 Purchasing KPIs, split by the dimension of your choice

Item / Product Analysis

Item Average Buying Price

Item Average Buying Price
Item Average Buying PriceItem Average Buying Price
Visualize the evolution of the Product Average Buying Price over time

Price vs Volume

Price vs Volume
Price vs VolumePrice vs Volume
Quickly figure out which products you are not buying at the right price compared to previous year

Supplier Analysis

Supplier Dependencies

Supplier Dependencies
Supplier DependenciesSupplier Dependencies
Optimize your procurement strategy by quickly figuring out the number of distinct suppliers you have for the items your purchase

Distribution Analysis

Purchasing Segmentation Analysis

Purchasing Segmentation Analysis
Purchasing Segmentation AnalysisPurchasing Segmentation Analysis
Visualize the value of any of your Purchasing KPIs, split by the dimension you selected (market share analysis)

Purchasing Pareto Analysis

Purchasing Pareto Analysis
Purchasing Pareto AnalysisPurchasing Pareto Analysis
Perform a Pareto Analysis on any of your Purchasing KPIs: the 80/20 rule.

Purchasing KPI Performance

Purchasing KPI Performance
Purchasing KPI PerformancePurchasing KPI Performance
Visualize the overall performance of any of your Purchasing KPIs: what is the performance, how does this performance evolve, who contributes to this performance

Creating your PURCHASING dashboard Step-by-Step

You want to get a clear understanding on your Purchasing results? You want to build a Tableau dashboard to better understand your Purchasing data?

Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Purchasing data in less than 5 minutes!

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Purchasing data (whether it comes from: ERP, database, Excel, CSV file...)

You must retrieve at least the following attributes (it is ok if the names don't match, and it is better to add additional attributes to analyze):

  • date
    Date Date
  • string
    Supplier Name of your supplier
  • string
    Item / Product Purchased item: product, service…
  • string
    Purchasing Category Purchasing category
  • string
    Buyer / Purchaser Buyer name, Buying unit...
  • numeric
    Purchased Amount Amount of the purchase
  • numeric
    Purchased Quantity Quantity purchased

2nd STEP: Upload your Tableau workbook file

On LinPack-for-Tableau.com, select 'create dashboard from template: Purchasing' and upload your Tableau workbook (note: your data is NOT uploaded).

3rd STEP: Map your attributes

Map the attributes of your workbook on the attributes of the template.

Finally, click 'Confirm & Download'... and your Purchasing dashboard is already downloading :-)

Open the Tableau workbook file you received, it will automatically reconnect to your data sources.

Your Purchasing dashboard is now ready to be used or customized!


Just give it a try here :-)

Other #DataViz Packs