📊 Amazon Sales Report Dashboard is an interactive data visualization project built using Power BI. The dashboard transforms sales and profit data from raw Excel (.xlsx) files into insightful visuals, enabling users to track performance and identify trends across categories, states, and time periods.
🎯 Project Overview
This dashboard provides a clear, interactive view of Amazon sales data by:
Tracking total orders, profit, and sales over time.
Breaking down sales performance by product category.
Showing profit distribution by state.
Visualizing sales trends over the years with line and tree map charts.
The raw .xlsx file was first cleaned and updated in Microsoft Excel, ensuring accurate and structured data for visualization in Power BI.
🔑 Key Features
KPI Cards: Highlight total orders, total profit, and total sales.
Sales Trends Over Time: Line chart showing sales fluctuations by order date.
Category-Wise Sales: Tree map visualizing sales by product category.
Profit by State: Bar chart displaying top and bottom performing states.
Sales Gauge: A gauge chart showing progress towards sales targets.
🛠 Tools & Technologies
Power BI – Dashboard creation and data visualization.
Microsoft Excel – Data cleaning, updating, and preparation.
Excel (.xlsx) Files – Primary data source.
📸 Dashboard Screenshot
🚀 Future Enhancements
Add interactive filters for year, region, and product subcategories.
Integrate real-time sales data via APIs or connected databases.
Include forecasting to predict future sales and profit trends.
Add customer segmentation analysis to understand buying patterns.