Online Retail Sales Analysis Dashboard

Situation

An online retail company needed deeper insights into global sales performance to identify revenue trends, top-performing markets, and high-value customers. Existing reports were static, time-consuming to generate, and lacked actionable geographic and customer segmentation views.

Task

Design and develop an interactive sales analytics dashboard that enables management to:

1. Track revenue trends over time.
2. Compare revenue vs. quantity sold by country.
3. Identify top customers by revenue.
4. Visualize global product distribution.

Action

1. Collected, cleaned, and transformed raw transactional data in Excel before importing into Power BI.
2. Built multiple interactive visualizations:
3. Revenue Trend Analysis (line chart with year/month filters) to monitor seasonality.
4. Revenue & Quantity by Country (dual bar chart) to compare sales volume and value.
5. Top 10 Customers by Revenue (bar chart) to highlight key accounts.
6. Global Product Quantity Map to visualize geographic distribution.
7. Integrated dynamic filters for Month, Year, and Country to allow multi-level analysis.
8. Applied consistent visual formatting and color coding for readability and quick interpretation.

Result

1. Delivered a portfolio-level dashboard used by senior leadership for ongoing performance reviews.
2. Reduced manual reporting time by 60% and increased the speed of decision-making by enabling instant drill-downs.
3. Helped marketing teams identify high-value accounts, resulting in a 10% increase in campaign ROI.
4. Provided clear visibility into over $9M in global sales, supporting targeted expansion in top markets.