eGig
SMIT PATEL
Aspiring Data analyst | MIS Executive | Back Office operator ·
Hire
Olist E-Commerce Data Analysis
📌 Project Overview
An end-to-end e-commerce data analysis project using SQL, Power BI and Excel to analyse sales performance, customer behaviour, delivery performance and seller operations.
The project transforms raw transactional data into business insights and recommendations.
🎯 Business Objectives
Analyse overall revenue a… Olist E-Commerce Data Analysis
📌 Project Overview
An end-to-end e-commerce data analysis project using SQL, Power BI and Excel to analyse sales performance, customer behaviour, delivery performance and seller operations.
The project transforms raw transactional data into business insights and recommendations.
🎯 Business Objectives
Analyse overall revenue and order performance
Identify top-performing product categories
Analyse customer distribution and behaviour
Measure on-time and late delivery performance
Analyse customer satisfaction through review scores
Identify repeat vs one-time customers
Evaluate seller performance
Identify business opportunities for customer retention and operational improvement
🛠️ Tools & Technologies
SQL
PostgreSQL
Power BI
DAX
Excel
Power Query
📊 Power BI Dashboard
Page 1 — Executive Overview
Executive Overview
Page 2 — Sales & Revenue Analysis
Sales & Revenue
Page 3 — Customer & Delivery Analysis
Customer & Delivery
Page 4 — Seller & Operations Analysis
Seller & Operations
Page 5 — Business Insights & Recommendations
Business Insights
🔍 Key Insights
Total revenue: ₹15.84M
Total orders: 99,441
Average Order Value: ₹159.33
On-time delivery: 91.89%
Late delivery: 8.11%
Average review score: 4.09/5
Repeat customer rate: 3.12%
💡 Business Recommendations
Improve customer retention and repeat purchases
Monitor late deliveries and improve delivery reliability
Focus on high-performing product categories
Identify and support high-performing sellers
Use customer feedback to improve customer experience
📁 Project Structure
Power BI/ — Power BI dashboard
SQL/ — SQL analysis queries
Dashboard Screenshots/ — Dashboard pages
👤 Author
Smit Patel
📌 Project Overview
An end-to-end e-commerce data analysis project using SQL, Power BI and Excel to analyse sales performance, customer behaviour, delivery performance and seller operations.
The project transforms raw transactional data into business insights and recommendations.
🎯 Business Objectives
Analyse overall revenue a… Olist E-Commerce Data Analysis
📌 Project Overview
An end-to-end e-commerce data analysis project using SQL, Power BI and Excel to analyse sales performance, customer behaviour, delivery performance and seller operations.
The project transforms raw transactional data into business insights and recommendations.
🎯 Business Objectives
Analyse overall revenue and order performance
Identify top-performing product categories
Analyse customer distribution and behaviour
Measure on-time and late delivery performance
Analyse customer satisfaction through review scores
Identify repeat vs one-time customers
Evaluate seller performance
Identify business opportunities for customer retention and operational improvement
🛠️ Tools & Technologies
SQL
PostgreSQL
Power BI
DAX
Excel
Power Query
📊 Power BI Dashboard
Page 1 — Executive Overview
Executive Overview
Page 2 — Sales & Revenue Analysis
Sales & Revenue
Page 3 — Customer & Delivery Analysis
Customer & Delivery
Page 4 — Seller & Operations Analysis
Seller & Operations
Page 5 — Business Insights & Recommendations
Business Insights
🔍 Key Insights
Total revenue: ₹15.84M
Total orders: 99,441
Average Order Value: ₹159.33
On-time delivery: 91.89%
Late delivery: 8.11%
Average review score: 4.09/5
Repeat customer rate: 3.12%
💡 Business Recommendations
Improve customer retention and repeat purchases
Monitor late deliveries and improve delivery reliability
Focus on high-performing product categories
Identify and support high-performing sellers
Use customer feedback to improve customer experience
📁 Project Structure
Power BI/ — Power BI dashboard
SQL/ — SQL analysis queries
Dashboard Screenshots/ — Dashboard pages
👤 Author
Smit Patel
Comments
Log in to comment.