Vendor and Supplier Use Case

Last modified: October 18, 2022

A guide to implementing Auto Insights for a vendor and supplier use case, including data structure and sample questions.

Problem Statement

Procurement teams typically deals with the same scope of data but with different requirements for analysis; identification of cost savings, where should the team optimise pricing at, which supplier/vendor has been awarded multiple contracts across departments (key man risk), what has the past average price been at and if there's room for further contract negotiation.

An example of Vendor & supplier data structure

right click and 'open image in new tab' to expand the view

An example of Vendor and supplier data structure

Please refer to this article for more information about preparing data.

Segments

A segment is a qualitative value, like names or categories. Here are some of the typical segments we find in vendor & supplier data:

  • Vendor attributes: Vendor name, vendor company size, vendor category, etc.

  • Product attributes: Product description, product sub-description, material description, etc. 

  • Company attributes: Site/office location, project name, project description, entity, etc.

  • Other attributes: contract manager, contract status, ordering department, orderer name etc.

Measures

A measure is a quantitative, numeric value. Here are some of the typical measures we find in vendor & supplier data:

  • Spend

  • Quantity purchased

  • Unit price

  • Average Unit Price per Product

  • Average Spend per Project

  • Average Spent per Department

  • Variance to Budget*

*To compare spending to budget and calculate variance to budget, you would need to upload a separate goals dataset. Click here to read more on the goals feature.

What sort of insights can Auto Insights help me uncover?

Identify cost savings

  • Spend by site location

  • Unit price trend for Product last financial year

Optimize pricing

  • Unit price trend by Product Category

  • Unit price trend by Product by Vendor

  • Unit price variance for a particular product

  • Spend by vendor

Support supplier negotiation & vendor management

  • Expired contracts by contract manager

  • Spend by contract status this financial year

  • Spend with preferred vendors last financial year

  • Spend with non-preferred vendors last quarter

Monthly/Quarterly/Yearly Reporting

  • Spend comparing contract manager in July 2021 vs June 2021

  • Spend comparing Departments in FY21 vs FY20

  • Average Spend per Project comparing Projects in FY22 Q1

Related Articles

How to prepare data
How to upload data
Best-in-class mission
Quick Guide to Find and Create Insights

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.