This project is a Sales Analytics Dashboard for Amazon e-commerce data, built using Power BI. The goal is to help business stakeholders monitor sales performance, identify trends, and make data-driven decisions.
- Analyze sales performance over time.
- Identify top-selling product categories and sub-categories.
- Track order volumes, profit, and cost.
- Understand sales trends based on location (State/City).
- Monitor key business KPIs such as Total Sales, Total Orders, Profit, and Quantity Sold.
| Feature | Description |
|---|---|
| Sales Overview | Total Sales, Total Profit, and Orders KPI |
| Sales Trend Analysis | Monthly Sales and Profit line charts |
| Category & Subcategory Sales | Bar charts for top-performing products |
| Customer Insights | Customer type and segment analysis |
-
Amazon E-commerce Sales Dataset
-
Contains details like:
- Order ID, Product, Category, Subcategory
- Order Date, Ship Date
- Sales, Profit, Quantity
- Customer Details
- Location (State, City)
- Order Status
- Power BI Desktop (.pbix file)
- Data Cleaning & Transformation: Power Query
- Data Modeling: Relationships & DAX Measures
- Visualization: Interactive Dashboards
- Total Sales
- Total Orders
- Profit Margin (%)
- Sales by Category / Sub-Category
- Sales by State / City
- Monthly Sales Trend
- Download the
.pbixfile from this repository. - Open it using Power BI Desktop.
- Click on Refresh if you want to reload the data
- Interact with the dashboard using filters and slicers.
<"https://github.com/user-attachments/assets/09e0b967-e841-4f86-aac9-3ad696ba2a22" />
- Identified top-selling categories and profit drivers.
- Visualized regional performance to optimize logistics.
- Monitored monthly sales trends to forecast future demand.
- Highlighted areas of cost reduction and profit maximization.