Procurement Cockpit white.png Proc Cockpit Dark.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

KPi 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)

Visualization and 12 dashboard pages

Home

Procurement - Home

Procurement - Home
Procurement - HomeProcurement - Home

Cockpit

Procurement Cockpit

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

Procurement KPIs

Procurement KPIs
Procurement KPIsProcurement KPIs
Get a transversal view of your Procurement Performance

Procurement Top KPIs Evolution

Procurement Top KPIs Evolution
Procurement Top KPIs EvolutionProcurement Top KPIs Evolution
Visualize how your Procurement Performance is evolving (Month-to-Date, Year-to-Date)

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

Trends Analysis

Evolution over years

Evolution over years
Evolution over yearsEvolution over years
Visualize how your top KPIs are correlated and how this correlation evolved across years

Trends Split Analysis

Trends Split Analysis
Trends Split AnalysisTrends Split Analysis
Visualize the evolution of the KPI you selected, breakdown by the dimension you selected.

Segmentation Analysis

Segmentation Analysis

Segmentation Analysis
Segmentation AnalysisSegmentation Analysis
Visualize the value of the KPI you selected split by the dimension you selected (market share analysis)

Pareto Analysis

Pareto Analysis
Pareto AnalysisPareto Analysis
Flexible Pareto Analysis (80 / 20 analysis)

KPI Performance

KPI Performance
KPI PerformanceKPI Performance
Visualize the overall performance of the selected KPI: evolution and breakdown by the dimension of your choice

You want to gain full spend visibility? You want to build a Tableau dashboard to better understand your Procurement data?

Using LinPack-for-Tableau.com, you can generate a stunning Tableau dashboard on Procurement in less than 1 minute!

 

Purchasing dashboard Live Demo

 

For this, just follow the instructions :-)

 

1st step: Create a Tableau workbook containing the connection definition to your procurement data (whether it comes from SAP, SalesForce, Excel...)

You must retrieve at least the following attributes:

  • 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

The attributes names do not have to match and the underlying data model could be one file or 5 tables, it does not matter :-).

 

2nd step: On LinPack-for-Tableau.com, select 'create dashboard from template: Procurement' and upload your Tableau workbook

 

3rd step: Map your attributes, click 'Confirm & Download'... you're done!!!

 

This Procurement Dashboard will help you better managing your Procurement processes: What are the most important suppliers? For which items do we have a single supplier dependency? Which supplier provides the best pricing conditions?....

Just try it here :-)

Enjoy and share your feedbacks with us so we can improve the solution :-)

Other #DataViz Packs