Back to Projects

E-Commerce Analytics

PythonPandasNumPyMatplotlibSeabornJupyterData AnalysisVisualization
E-Commerce Analytics

Executive Summary

In this analysis, I dove deep into a vast dataset of a Brazilian E-Commerce brand to gain insights into basic exploratory analysis, customer behavior, seasonal impacts on sales performance, and logistics efficiency's impact on customer satisfaction. Through this project, I highlighted key findings that can drive strategic decisions to enhance business operations, customer retention, and overall profitability.

Key Findings

Sales & Revenue Overview

  • Total Revenue: Approximately R$ 16,008,872
  • Average Order Value: R$ 154.10
  • Monthly Revenue Trends: Sales peaked in November 2017 with R$ 1,194,883, suggesting a seasonal trend possibly linked to holiday shopping

Product Category Performance

  • Top Selling Categories: Bed, Bath, and Table (11,115 orders), Health and Beauty (9,670 orders), Sports and Leisure (8,641 orders)
  • Credit card stood out as the most preferred payment method, with boleto and vouchers as close second and third respectively

Customer Behavior Insights

  • Purchase Frequency: Majority of the customer base can be categorized as one-time buyers (93,099), suggesting a severe lack of retention
  • Geographical Distribution: São Paulo leads with the highest number of purchases (15,540), followed by Rio de Janeiro (6,882)

Logistics and Delivery Performance

The delivery performance appears to be in shambles as orders take an average of 12.5 days to be delivered. While reasonable given the expected range for Brazil, there is significant room for improvement to gain competitive advantage.

Customer Satisfaction

  • Review Scores: 73.41% of orders received positive feedback (4-5 stars), while 13.99% received low scores (1-2 stars), often due to delivery issues or product quality
  • Common Complaints: The most frequent complaints in low-rated reviews include non-delivery of products, highlighting a critical area for improvement

Strategic Recommendations

  1. Customer Retention: Develop loyalty programs to encourage repeat purchases, especially targeting one-time buyers. Personalized marketing and post-purchase engagement can significantly increase customer lifetime value.
  2. Logistics Optimization: Focus on reducing shipping times, particularly in regions with longer delivery times. Consider local warehousing or partnerships with more reliable carriers.
  3. Product Strategy: Capitalize on the popularity of top-selling categories by expanding product lines or offering bundled deals.
  4. Customer Service: Enhance customer service to address common complaints swiftly, particularly around delivery issues. Implementing real-time tracking and proactive communication can mitigate dissatisfaction.
  5. Fraud Prevention: Strengthen transaction monitoring systems to detect, flag, and prevent fraudulent activities, ensuring secure transactions for both business and customers.

Conclusion

The insights derived from this dataset provide a clear plan for strategic enhancements in various business areas. By focusing on customer retention, logistics efficiency, and product strategy, the company can not only increase its market share but also improve customer satisfaction and operational effectiveness. The seasonal trends and fraud detection insights further underscore the need for adaptive strategies and robust security measures to safeguard business interests and customer trust.