E-Commerce Sales Analysis Dashboard

AI downloaded the data from Kaggle. I thoroughly analyzed this data and developed an Interactive Dashboard Using Power BI.

Skills: Data Modelling, Power BI

This dashboard has three sections: Overview of Sales, Product Category wise sales analysis, Sales Location wise analysis

In the Overview of sales Section, analyzed on:

1. Total seals, 2. Total Profit, 3. %of Profit Margins
2. Sales by top 10 Locations (State)
3. Toal Sale and Target by category
4. Profit by Category

In the Product Category wise sales analysis Section analyzed: Based on the selected category calculate

1. Total sales 2. % of Profit margins
2. Top 10 Locations(State)
3. Sales and profit margin by Sub-Categories of the selected Category.
4. Sales by Month

In the Sales Location-wise analysis Section analyzed: Based on the selected Location(State) calculate

1. Total sales 2. % of Profit margins
2. Sales and profit margin by Cities of the selected State
3. Sales and profit margin by Category
4. Sales by Month

Dashboard

• Dashboard Link: Click Here

Screenshots