Making procurement and supply-chain risk visible. This interactive dashboard organizes a realistic set of procurement data using a familiar supply-chain framework, so teams can see where risk is concentrated — by category, region, or single-source dependence — and focus their effort where it matters most.
The framework is general by design allowing the same idea to be applied to other purchasing or supplier questions, not just this example.
PythonPlotlyDashPandasFlask
Problem
Procurement teams often manage hundreds or thousands of items at once,
and the risk across that mix is rarely spread evenly. A handful of purchases can carry real exposure:
a single supplier, a long lead time, or a critical component the business can't run without. The rest are routine.
Without a way to sort and compare all of it, the real danger tends to stay hidden, and attention follows whatever is loudest instead of what matters most.
Approach
I built an interactive dashboard around a realistic set of procurement data covering roughly a thousand items, sorting them with a familiar supply-chain framework — one that plots each item by how much risk it carries against how much it affects the bottom line.
On top of that I added straightforward filters and summary metrics, so anyone can narrow the view by supplier region, category, or product and quickly see where single-source dependence, long lead times, and environmental impact are concentrated.
Outcome
The dashboard turns a long, hard-to-read list of purchases into a clear picture of where risk actually sits, so effort goes toward the items that matter most instead of the ones that just happen to be in front of people.
At a glance, a team can see which categories and regions need attention, which items carry the most risk overall, and how single-source exposure breaks down across the portfolio.
Key Capabilities
At-a-glance metrics: Summary cards showing total items, average supply risk, average profit impact, and how much of the portfolio depends on a single supplier.
Risk-and-impact map: A scatter chart that plots each item by how risky and how high-impact it is, with size reflecting order volume, so the biggest exposures stand out right away.
Category, region, and lead-time views: Breakdowns showing how purchases spread across categories and supplier regions, plus lead-time and single-source patterns.
Environmental impact heatmap: A simple color grid comparing environmental impact across regions and categories.
Highest-risk watchlist: A ranked table of the ten items carrying the most combined risk, with the details a team needs to follow up.