E-commerce Sales Analysis Dashboard using SQL & Power BI

This project analyzes e-commerce sales data from 2018 to 2026 using SQL, Excel, and Power BI

Key Insights

Total sales performance and order volume were analyzed using SQL queries

The analysis shows that sales are well distributed across multiple countries, with UAE leading slightly

Lifestyle products generated the highest revenue, indicating strong demand for casual wear

Sales trends reveal seasonal patterns, with higher performance in mid-year and end-of-year periods

Early months such as January and February tend to have lower sales performance

Tools Used

SQL Server

Microsoft Excel

Power BI

Deliverables

Interactive Power BI Dashboard

Cleaned Excel dataset

SQL analysis queries

Visual report in PDF format