This project is based on Amazon sales data and focuses on analyzing sales performance using Microsoft Excel and Power BI.
The main objective was to convert raw sales data into an interactive dashboard that helps understand sales trends, product performance, profit, and regional performance.
- Analyze overall sales and profit
- Identify top-performing product categories
- Compare regional sales performance
- Track monthly sales trends
- Create interactive dashboards for better decision-making
The dataset contains sales records with information such as:
- Order Date
- Region
- State
- Category
- Sub-Category
- Product Name
- Sales
- Quantity
- Discount
- Profit
- Microsoft Excel
- Pivot Tables
- Pivot Charts
- Power Query
- Power BI
- DAX
The dashboard includes:
- Total Sales
- Total Profit
- Total Orders
- Sales Trend
- Category-wise Sales
- Region-wise Sales
- State-wise Analysis
- Interactive Filters (Slicers)
- Identified the highest-performing product categories.
- Compared sales across different regions.
- Analyzed monthly sales trends.
- Highlighted profitable and low-performing areas.
Amazon-Sales-Analysis
│
├── Dataset
├── Excel Dashboard
├── Power BI Dashboard
├── Images
└── README.md
Aman Kumar
Aspiring Data Analyst
- Microsoft Excel
- Power BI
- SQL
- Python
- Data Analysis