Back to Projects

E-Commerce Sales Performance Dashboard

Analysis of 400,000+ transactions revealing market concentration and seasonal patterns

400K+
Transactions Analyzed
84%
UK Revenue Share
25%
Q4 Sales Spike
7%
Top 5 Products Revenue
2%
Return Rate

Data Import & Libraries

Task: Loaded Online Retail.xlsx and imported pandas / matplotlib for comprehensive data analysis.
Result: Raw transactions dataset available in df for exploratory analysis and visualization.
Data Import Code
Data import and library setup

Data Cleaning & Preparation

Task: Removed missing CustomerID rows and separated sales from returns for accurate analysis.
Result: Cleaned dataset with sales and returns properly categorized. Calculated overall return rate of approximately 2% in the dataset.
Data Cleaning Code
Data cleaning process

Monthly Sales Analysis

Task: Aggregated Total_sales by month name and visualized as a comprehensive line chart.
Result: Identified strong seasonality patterns — November and December account for over 25% of total sales. Chart formatted with K/M y-axis labels for enhanced readability.
Monthly Analysis Code
Monthly sales analysis code
Monthly Sales Trend
Monthly sales trend visualization

Geographic Market Analysis

Task: Aggregated Total_sales by Country and computed each country's percentage contribution to total revenue.
Result: Discovered heavy geographic concentration with United Kingdom accounting for 84% of total revenue. Created visualizations of top-5 countries with percentage share analysis.
Country Analysis Code
Country analysis implementation
Country Revenue Distribution
Revenue distribution by country

Product Revenue Ranking

Task: Aggregated revenue by Product Description to identify top-performing products and compute contribution percentages.
Result: Top 5 products account for approximately 7% of total revenue. Generated top-10 product lists for merchandising strategy and visualized with bar charts using K/M y-axis formatting.
Product Analysis Code
Product performance analysis code
Top Products Analysis
Top performing products visualization

Dashboard Creation

Task: Built comprehensive Tableau dashboard with K/M formatting for presentation-ready visuals.
Result: Interactive dashboard providing insights into sales trends, product performance, and geographic distribution.
Dashboard Details
Dashboard interactive elements
View Code Live Dashboard Back to Projects
>