Link to project:

https://docs.google.com/spreadsheets/d/14qnuXrZ-VZOH-Wkj1t1B9ls0Nf9TI17o/edit?usp=sharing&ouid=108370073302113037437&rtpof=true&sd=true

E-Commerce Performance Analytics Dashboard

Project Overview

This project demonstrates the development of an interactive Excel dashboard for analysing e-commerce sales performance. The dashboard analyses 25K+ orders and 178K units sold, generating approximately $12.6M in sales and $1.46M in profit. It enables business users to explore sales trends, product profitability, regional performance, and the impact of discounting using interactive filters and KPI metrics.

Business Problem

E-commerce businesses often generate large volumes of transaction data but lack clear visibility into sales drivers, profitability, and operational efficiency.

Key challenges addressed:

Identifying high-performing product categories
Understanding regional sales distribution
Evaluating discount impact on profitability
Tracking returns and operational costs
Providing executives with quick performance insights

The goal was to transform raw sales data into an interactive decision-support dashboard.

Dataset Overview

Dataset used in the project:

Metric	Value
Orders analysed	51,255
Units sold	178,218
Total Sales	$12.63M
Total Profit	$1.46M
Average Discount	14%

Dataset structure:

Orders (Fact Table)
Customers (Dimension)