Project Details
This project explores how delivery delays influence customer satisfaction using real-world e-commerce data. I built a robust data pipeline using MySQL 8.0, applying advanced SQL techniques like CTEs, window functions, and index optimization to join and transform data from multiple tables including orders, reviews, products, and sellers.
The project focuses on:
Measuring delivery delays by seller, product category, and region
Analyzing the effect of delays on review scores and customer sentiment
Highlighting underperforming sellers and logistical bottlenecks
Key tools used:
MySQL SQL Scripts – for building the delivery-performance dataset
R Scripts – for exploratory data analysis and visualizations
Power Query Workflow – for fast data cleaning and aggregations
Tableau Dashboard – for interactive insights into delay patterns and review trends
This project showcases how data can drive actionable decisions in logistics and customer experience. View the full project on GitHub