🛒 Olist E-commerce Analysis

Overview

Analyzed 99K orders and $13.5M revenue to understand customer behavior, growth trends, and business performance.

Revenue & Growth

Revenue shows strong growth from 2017 with seasonal peaks.

Product Insights

Top categories dominate revenue and reflect essential consumer demand.

Order Value Analysis

AOV varies significantly across categories and payment methods.

Customer Segmentation

• Best Customers (~10.7%) have high spending but low frequency
• Churn Customers (~11.9%) mostly purchase only once
• Main issue: failure to convert first-time buyers into repeat customers

Business Impact

Improving retention strategies and targeting first-time buyers can significantly increase revenue. Leveraging seasonal campaigns can further drive growth.