Supply Chain and Operations Optimization Analytic

Project Title: Supply Chain and Operations Optimization Analytics (Excel, MYSQL, Power BI[Power Query, DAX, Visualization])

Project objectives: To optimize supply chain for efficiency, cost savings, and enhanced customer satisfaction on key metrics

• Developed Regression Analytics, cutting costs by 10% and boosting Supply Chain efficiency by 15%

• Utilized ETL process to assess risks in KPIs: Delivery Status, Avg Days for Shipping, SKU, Top Products, Shipping Mode

• Implemented Power BI for real-time supply chain insights, reducing report generation time by 50%