This project analyzes retail sales data to uncover trends, identify top-performing products, and highlight customer insights.
The interactive dashboard was created using Power BI with SQL for data preparation.
- Sales Overview: Monthly sales vs. budget, top 10 products, and top customers.
- Customer Details: Gender distribution, top cities by sales and count, and monthly active customers.
- Product Details: Sub-category performance, sales trends, and average sales per product.
- Power BI
- SQL (Data Cleaning & Transformation)
- Excel (Initial Data Processing)
- Mountain Bikes and Road Bikes contribute the majority of sales.
- Sales exceed budget in Q4 due to seasonal demand.
- London and Paris are the top-performing cities.
Dataset contains sales transactions with fields for product, customer, location, and time period.
Author: Anchal Gupta