Global E-Commerce Shipping Analytics Report

Global E-Commerce Shipping Analytics Report 

📅 Date: 22/02/2025 📝 Author: Akieni Wright 📊 Project Type: Data Analysis & Business Intelligence 🔍 Tools Used: MySQL & Power BI  

Executive Summary  

Project Overview In this freelance project, I conducted an in-depth analysis of a global e-commerce shipping dataset to uncover critical insights related to customer behavior, operational efficiency, and profitability. Leveraging MySQL for data extraction and transformation, alongside Power BI for dynamic visualizations, I provided actionable recommendations to improve delivery performance and customer satisfaction. 

 

 

Key Analytical Questions & Findings 

Using SQL queries, I segmented customers by gender and purchase patterns to identify demographic groups with higher transaction volumes. Results showed that male customers exhibited the highest purchase frequency accounting for 50.26% of the purchases, likely influenced by ease of access to expedited shipping and targeted marketing campaigns. 

                                   

 

Analyzing delivery records by shipment mode, I discovered that sea shipments consistently maintained the highest on-time delivery rates but it also had the highest rates of delayed shipments yielding numbers of 4459 on time and 3003 delayed, while standard ground shipping showed 1035 von time and 725 delayed, and shipping by air yielded 1069 on time and 708 delayed, primarily due to logistics bottlenecks. 

Correlating customer service interactions with satisfaction scores, I found that frequent customer inquiries were shown to yield no significant difference showing that the average satisfaction score was 3 despite how many calls were made.  

Through MySQL queries and Power BI visualizations, I identified that products that were classified as low importance yielded the highest profit margins, while low-margin categories were oddly enough the items that were classified as high importance products. 

                                 

 

5. Discounting & Profitability Trends 

Examining price markdowns vs. profit margins, I observed that the fewer the discounts given by the warehouses the larger the number of purchases thus leading to larger profit. 

Data showed that regardless of the mode of shipment the customer satisfaction rating was shown to be roughly 3 out of 5. 

Heavy-weight shipments (>10kg) experienced 35% more delays compared to lighter packages, highlighting the need for optimized freight logistics and alternative fulfillment strategies for bulk orders. 

Conclusion & Business Impact 

This analysis provided valuable insights for e-commerce businesses aiming to streamline logistics, improve customer engagement, and optimize profit strategies. By refining shipment methods, enhancing customer service protocols, and adjusting discount policies, companies can improve their efficiency, revenue generation, and customer retention.