Worked on a Shipfast Logistics case study using Python for data cleaning and Looker Studio for dashboarding to address key operational challenges.

Problem: Optimize shipment processes to reduce delays and costs while improving customer satisfaction and profitability.

Key Metrics Analyzed:

• Total Sales: ₹2.3M

• Total Profit: ₹286.4K

• Unique Orders: 5,009

• Average Sales: ₹229.86

• Unique Customers: 793

Key Findings:

• High cancellation rates caused by service quality issues.

• Sales increasing, but declining service ratings may reduce repeat customers.

• Consumer segment led in sales; corporate and home office underperformed.

• West region contributed 31.6% of sales, Central & South lagged.

Impact:
The analysis revealed improvement opportunities in delivery times, service quality, and regional strategy to retain customers and improve profitability.