Free guides

Procurement analytics guides

Short, practical methods from the Starter Kit, worked on a fictional practice dataset so every number can be checked.

• 82% PO compliance, 62% contract coverage. How much spend is actually controlled?

  The 2x2 control matrix, the union formula, and why 46.59% of spend sits outside at least one control.

• Spend analysis in Excel: the structure, the formulas and the traps

  Columns, core formulas with expected values, reconciliation, and the five traps that make a spend cube lie.

• A procurement analytics portfolio project you can show in an interview

  The five-item evidence pack, a truthful CV line, and an interview answer that shows judgement.

• AI prompts for procurement analysts, with tests you can check

  Four copy-paste prompts with known answers, and the rules that stop AI inventing numbers.

Want data to try the formulas? Download the free 15-invoice procurement CSV preview.