Back to Portfolio
Customer Analytics

Ecommerce Customer Sales Insights

An end-to-end ecommerce analytics project built using Python, SQL and Power BI to analyze customer behavior, sales performance, revenue trends and business KPIs. The project delivers interactive dashboards and actionable insights to support data-driven business decisions.

Python SQL Power BI Power BI
Source Code View Dashboard

Executive Overview Dashboard

Walmart Dashboard

Product & Market Insights Dashboard

Walmart Dashboard

Customer Segmentation Dashboard

Walmart Dashboard

Business Problem

Ecommerce businesses generate thousands of transactions every day, making it difficult to identify purchasing patterns, high-value customers and sales opportunities. This project analyzes customer behavior, product performance, regional sales and revenue trends to provide business insights through interactive dashboards.

Dataset

Project Workflow

Data Collection

Collected ecommerce transaction data including customers, orders, products and payments from multiple tables for business analysis.

Data Cleaning

Removed duplicates, handled missing values, standardized product names and prepared clean datasets using Python.

SQL Analysis

Used SQL to analyze revenue, customer behaviour, sales trends and product performance.

Power BI Dashboard

Designed an interactive Power BI dashboard with KPIs, customer segmentation, sales trends and business insights.

Key Performance Indicators

$8.91M

Total Revenue

4K

Customers

19K

Total Orders

37

Countries

Business Insights

Sales Performance

Revenue steadily increased over time with significant spikes during promotional campaigns.

Customer Insights

A small percentage of loyal customers contributed a major share of total revenue.

Product Analysis

Technology products generated the highest revenue while office supplies maintained consistent sales throughout the year.

Business Recommendation

Increase marketing efforts for high-value customers and optimize inventory for top-selling products.

Want to Explore the Complete Project?

Explore the complete project repository including Python analysis, SQL scripts, Power BI dashboard and business recommendations.

View Source Code Back to Portfolio