All projects
Data Analysis2026

Olist E-commerce Data Analytics

End-to-end marketplace analytics covering sales, customer value, logistics, forecasting and Power BI storytelling.

PythonPandasSQLExcelPower BIDAX
0 approx.

Marketplace orders

0

Source tables

0

Report areas

0+

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

Olist business overview dashboard
Olist business overview dashboard
Customers, products and RFM segmentation
Customers, products and RFM segmentation
Logistics, regions and strategic insights
Logistics, regions and strategic insights
How it works

Architecture

The end-to-end flow from raw data to a shipped result.

01

Integrate

Join nine Olist marketplace tables

02

Analyse

Python, SQL & Excel workflows

03

Model

RFM, CLV, churn & forecasting

04

Tell

Power BI dashboards & recommendations

Keep exploring

Other projects