The objective of this project is to build a BI system that evaluates vendor performance based on delivery timelines, quality metrics, and cost efficiency. The platform will support procurement teams in selecting reliable suppliers and improving supply chain effectiveness.
Gather procurement and vendor performance datasets.
Clean and standardize vendor-related data fields.
Design a dimensional data model for supplier analytics.
Load data into a BI environment using ETL workflows.
Develop dashboards showing vendor ratings, delay frequency, and defect rates.
Compare vendor performance across different time periods.
Identify high-risk and high-performing vendors.
Implement scorecard-based evaluation logic.
Enable drill-down views for individual vendor analysis.
Test dashboard insights against historical procurement outcomes.
Prepare documentation explaining procurement improvement strategies.
