Supplier Spend Analysis Dashboard

This interactive Power BI report explores the Procurement dataset using ZoomCharts Drill Down custom visuals and native Power BI visuals. It analyzes purchase order activity from 2022 to 2024, highlighting procurement spend, supplier performance, budget versus actuals, savings, delivery timelines, supplier risk, and maverick spend across categories, departments, regions, and suppliers.

The report helps users identify spending trends, compare supplier performance, monitor compliance, evaluate budget pressure, and uncover opportunities to improve procurement efficiency, reduce risk, and support better purchasing decisions.

The report was submitted to the FP20 Analytics ZoomCharts Data Challenge 37 (April-May 2026).

Author’s Description:

This report was built for FP20 Analytics Challenge 37 - Procurement Data Analytics, using a dataset of 5,200 procurement records spanning 2022–2024 across departments, suppliers, and categories.

The report is structured across two pages. Page 1 - Executive Overview provides a comprehensive summary of the organization’s spending performance. Total expenditure amounted to $979.4 million, which was $33.7 million (3.3%) below budget, resulting in savings of $104.3 million. Monthly trends and PO type breakdowns highlight spending patterns across the analyzed period.

Page 2 - Supplier, Delivery & Compliance highlights operational and compliance risks. The overall on-time delivery rate stands at 64.1%, with Maintenance, Marketing, and IT Hardware recording the weakest performance. Maverick spending is primarily concentrated in Professional Services, Marketing, and IT Software, while single-source procurement accounts for 12.5% of total spend ($122M), indicating significant supply chain risk. ESG analysis also shows that high-risk suppliers have lower average ESG scores (52) compared to low-risk suppliers (64), correlating with delivery delays averaging 4.1 days late overall.