← Back to Portfolio
Procurement & Stock Analytics Dashboard
Operational AnalyticsOperational dashboard tracking procurement efficiency, supplier performance, and inventory optimization.
Overview
💡 Challenge
Procurement teams lacked visibility into supplier performance, stock levels, and purchase order discrepancies.
⚡ Solution
Designed Power BI dashboard integrating PO, GRN, and invoice data with automated 3-way match validation and supplier scorecards.
🎯 Impact
Reduced invoice discrepancies by 40% and improved stock visibility, enabling better cash flow management.
Technical Details
🛠️ Tech Stack
Power BISQLExcelPython
✨ Key Features
- ✓Supplier performance scorecards
- ✓3-way match validation (PO-GRN-Invoice)
- ✓Stock level alerts and reorder recommendations
- ✓Procurement cycle time analysis
Key Learnings
- →Operational dashboards need real-time or near-real-time updates
- →Data quality at source is critical for reliable analytics
- →Stakeholder collaboration ensures dashboard adoption
📊 Data Notes
This project uses synthetic/open data to demonstrate capabilities while maintaining privacy and confidentiality. All methods and approaches are applicable to real-world scenarios.