Olist E-commerce Data Analytics
End-to-end marketplace analytics covering sales, customer value, logistics, forecasting and Power BI storytelling.
Marketplace orders
Source tables
Report areas
Core analyses
Overview
An end-to-end analysis of the Brazilian Olist e-commerce dataset. The workflow integrates marketplace tables, cleans and analyses orders, customers, products, payments, reviews and sellers, then turns the results into Power BI dashboards and business recommendations.
Features
- Revenue, orders and average-order-value trends by category and region
- RFM segmentation, customer lifetime value and churn-risk analysis
- Delivery-delay, review-performance and seller-performance analysis
- SQL and Excel analysis supporting an interactive Power BI model
- Revenue and order-demand forecasting with predictive indicators
- Management-ready recommendations for growth, retention and operations
Challenges
- Integrating nine related marketplace tables into a consistent analytical model.
- Connecting customer, product, logistics and review metrics without double-counting orders.
- Turning descriptive KPIs into practical retention, inventory and delivery decisions.
Results
The project moves from integrated marketplace data to decision support: business overview, customer and product performance, logistics and regional opportunity, plus predictive indicators for demand and churn risk.
Screenshots
Architecture
The end-to-end flow from raw data to a shipped result.
Integrate
Join nine Olist marketplace tables
Analyse
Python, SQL & Excel workflows
Model
RFM, CLV, churn & forecasting
Tell
Power BI dashboards & recommendations