Current process assessment
- Met with the procurement team to grasp their pain points and specific expectations regarding suppliers.
- Learned retail supplier performance KPIs and associated industry.
Metrics identification and dashboard design
- Held brainstorming sessions to identify the key performance indicators that help us assess and monitor the performance of the suppliers.
- The Power BI tool was used to develop a comprehensive dashboard that evaluates the performance of the suppliers at various levels, such as order fulfillment, sales and margin, backend rebates, and
- The Power BI dashboard enabled supplier selection and comprehensive 360-degree.
- Integrated the ability to perform detailed assessments of a chosen supplier across various product categories, enabling benchmarking against competitors.