106
More Report pages
Report Author: Karan Kumar
106
Share template with others
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:
๐๐
๐ฒ๐ฐ๐๐๐ถ๐๐ฒ ๐ฆ๐๐บ๐บ๐ฎ๐ฟ๐:
A comprehensive two-page Power BI dashboard designed to transform 5,200+ purchase orders into actionable procurement insights. This report focuses on financial health, operational efficiency, and risk mitigation.
๐๐ฒ๐ ๐๐ฒ๐ฎ๐๐๐ฟ๐ฒ๐ & ๐ง๐ฒ๐ฐ๐ต๐ป๐ถ๐ฐ๐ฎ๐น ๐๐บ๐ฝ๐น๐ฒ๐บ๐ฒ๐ป๐๐ฎ๐๐ถ๐ผ๐ป:
• ๐ฆ๐๐ฟ๐ฎ๐๐ฒ๐ด๐ถ๐ฐ ๐ข๐๐ฒ๐ฟ๐๐ถ๐ฒ๐: Visualizes $908.8M in spend and identifies $104.3M in total savings. It highlights category concentration risks, specifically an overreliance on IT Software (32.96% of spend).
• ๐ฅ๐ถ๐๐ธ & ๐๐ผ๐บ๐ฝ๐น๐ถ๐ฎ๐ป๐ฐ๐ฒ ๐๐ฒ๐ฒ๐ฝ-๐๐ถ๐๐ฒ: Tracks critical leakage points, including a 10.8% Maverick Spend rate and a 15.5% Overdue Invoice rate.
• ๐ข๐ฝ๐ฒ๐ฟ๐ฎ๐๐ถ๐ผ๐ป๐ฎ๐น ๐๐ณ๐ณ๐ถ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐: Pinpoints departmental bottlenecks, identifying Facilities and Legal as having the highest average delivery delays.
• ๐๐ป๐๐ฒ๐ฟ๐ฎ๐ฐ๐๐ถ๐๐ฒ ๐จ๐ซ: Leverages ZoomCharts for intuitive navigation, allowing stakeholders to drill down from global totals to specific high-risk suppliers such as Atlantic Raw Materials.
๐ข๐ฏ๐ท๐ฒ๐ฐ๐๐ถ๐๐ฒ:
To provide an executive-level overview that answers “where the money is going” and “where the risks are” in under 60 seconds.
Participate in data challenges, build and submit reports to get free template downloads.
Join CommunityMobile view allows you to interact with the report. To Download the template please switch to desktop view.
Was this helpful? Thank you for your feedback!
How can we improve it?