🚀 Comprehensive Amazon sales dashboard analyzing $2.18M+ in sales data with interactive visualizations for revenue tracking, product category performance, and business intelligence insights. Features monthly sales trends, top-performing products, and regional analytics.
This project presents a comprehensive sales analysis dashboard for Amazon products, featuring interactive visualizations and key performance indicators (KPIs) to provide actionable business insights. The dashboard analyzes sales data to track revenue performance, product categories, and sales trends.
Live View = (https://tvscrm-my.sharepoint.com/:u:/r/personal/kumars_tvsscs_com/Documents/amazon-dashboard.pbix?csf=1&web=1&e=3cnydy)
- Total Sales: $2.18M
- QTD Sales: $811.09K
- Products Sold: 27.75K units
- YTD Revenue: $19.42M
- 📈 Monthly Sales Trends: Track sales performance over time with interactive line charts
- 💰 Revenue Analysis: Weekly price/dollar analysis with detailed breakdowns
- 🛍️ Product Category Performance: Comprehensive analysis across multiple categories:
- Men Shoes: $9.40M (43.18% of sales)
- Camera: $4.92M (22.62% of sales)
- Men Clothes: $3.57M (16.42% of sales)
- Car Accessories: $2.37M (10.90% of sales)
- Toys: $1.10M (5.06% of sales)
- Mobile & Accessories: $325K (1.49% of sales)
- 🏆 Top Products: Track best-performing items by sales volume and reviews
- 🎯 Interactive Filters: Dynamic filtering by product category and other dimensions
- Real-time KPI cards showing total sales, QTD performance, units sold, and revenue
- Monthly sales trend analysis with clear visualization of seasonal patterns
- Weekly revenue tracking with detailed price analysis
- Category-wise sales breakdown with percentage contribution
- Top products by YTD sales volume
- Top products by customer reviews and ratings
- Product performance comparison across different categories
- Interactive line charts for sales trends
- Bar charts for category performance comparison
- KPI cards for quick metric overview
- Weekly revenue distribution charts
- Data Source: Excel files (raw sales data)
- Data Processing: Excel for initial data preparation, Power BI Power Query for data transformation and modeling
- Visualization: Microsoft Power BI
- Data Modeling: Power BI DAX formulas and calculated measures
The analysis is based on Amazon sales data including:
- Product information (category, name, price)
- Sales transactions (date, quantity, revenue)
- Customer data (reviews, ratings)
- Time-series data for trend analysis
- Clone the repository
git clone https://github.com/Jrsandy26/Amazon-Data-Analysis-Dashboard.git
cd amazon-sales-dashboard- Requirements
- Microsoft Power BI Desktop (free download from Microsoft)
- Excel files with Amazon sales data
- Load the data
- Open Power BI Desktop
- Import the Excel files from the
/data/raw/folder - Use Power Query to clean and transform the data as needed
- Open the dashboard
- Open the
.pbixfile in Power BI Desktop - Refresh data connections if needed
- Publish to Power BI Service (optional) for sharing
- Open the dashboard file
- Use the filter options to explore different product categories
- Navigate between different views to analyze sales performance
- Export insights and reports as needed
- Men Shoes category dominates sales with 43.18% market share
- Camera products show strong performance with 22.62% of total sales
- Seasonal trends visible in monthly sales patterns
- Strong product portfolio across diverse categories
- Consistent revenue growth throughout the year
amazon-sales-dashboard/
├── data/
│ ├── raw/ # Raw Excel/CSV files
│ └── processed/ # Cleaned data files
├── dashboard/ # Dashboard files
└── README.md
![Product Overview]
Contributions are welcome! Please feel free to submit a Pull Request.
This project is licensed under the MIT License - see the LICENSE file for details.
⭐ If you found this project helpful, please give it a star!