Olist E-Commerce Funnel & Retention Analysis
Analyzed 100K+ real Brazilian e-commerce orders to map a 4-stage purchase funnel, build a customer cohort retention heatmap, and segment R$8.7M in revenue across 10 categories, delivering 3 prioritized business recommendations.
Year
2026
Scope
Data Analysis / Product Analytics
Client
Independent Research
Duration
2 weeks
Data analysis project built on a real 100K+ order dataset to practice funnel thinking and business prioritization.
Challenge:
Large e-commerce datasets are messy and multi-dimensional. Extracting actionable product and business decisions from raw order data requires both analytical depth and clear prioritization frameworks.
Solution:
Mapped a 4-stage purchase funnel drop-off using 100K+ real orders from GitHub. Built a customer cohort retention heatmap revealing ~30–35% month-2 churn. Segmented R$8.7M revenue across 10 product categories. Delivered 3 prioritized business recommendations using an impact vs effort framework, visualized through a live Tableau dashboard.
