Back to portfolio
Dashboard case study
Supplier DIFOT Performance Analysis
A Power BI supplier performance dashboard for DIFOT, on-time delivery, in-full delivery, and supplier risk.
Business question
Which suppliers should be protected, coached, or reviewed?
Power BISupplier PerformanceDIFOTOperationsProcurement
At a glance
KPIs
Total lines, DIFOT %, In full %, On time %
Filters
Supplier type, Seller, Month, Delivery status
Tools
Power BI, DAX, Power Query, Data modelling, Supplier analytics
What it shows
Single-page supplier performance report with DIFOT cards, quadrant scatter, supplier detail table, and monthly delivery trend.
- DIFOT, in-full, on-time, and total-line KPI cards
- Supplier quadrant scatter with target lines
- Supplier detail table with status icons and volume bars
Main insights
Clear supplier risk view with action-oriented quadrants, volume weighting, and a monthly reliability trend.
- DIFOT is stricter than timing or completeness alone
- Large poor suppliers create the highest operational risk
- Strategic suppliers can be protected or expanded
Helps operations and procurement teams prioritise supplier follow-up using clear reliability quadrants.
Discuss a dashboard