What problem does it solve? Answering "where does our money go" typically takes weeks of manual spreadsheet work. This Skill turns a raw spend file (CSV, Excel, or Coupa export) into a consulting-grade spend analysis with reconciled metrics, data quality documentation, and executive-ready outputs in a single run. ## Core Features & Use Cases - Schema inference and normalization: Automatically maps columns to amount, supplier, category, date, region, and currency semantics, then canonicalizes supplier names, derives categories, and converts currencies to a base currency with logged crosswalks. - Core procurement metrics: Computes total spend, Pareto concentration, HHI/Gini, Top-N supplier share, tail spend segmentation, and time trends, with rigorous self-checks for duplicates, outliers, negatives, and reconciliation against source totals. - Deliverables: Produces a 3-sheet Excel workbook (Data Overview & Quality, Analysis & Strategy, Executive Summary) plus separate PNG charts (category pie, supplier Pareto, regional bars) and a methodology file. - Use Case: A CPO receives a Coupa export of 24 months of transactions and needs a board-ready view of category mix, supplier concentration, and quantified savings opportunities before the next sourcing cycle. ## Quick Start Run a spend analysis on my file coupa-export.xlsx using EUR as the base currency and a 24-month lookback window.
