📊 Amazon Sales Dashboard – Power BI Project

This project provides a dynamic and interactive Sales Analysis Dashboard for Amazon Products using Power BI. The dashboard enables users to analyze YTD and QTD sales, track product performance, and explore customer review trends.

---

🚀 Overview

This Power BI dashboard addresses the following key performance metrics:

• YTD Sales: Monitor year-to-date sales to gauge revenue performance.
• QTD Sales: Analyze quarterly sales trends.
• YTD Products Sold: Track the total products sold throughout the year.
• YTD Reviews: Measure customer engagement via product reviews.

---

📊 Visuals Included

Chart Type	Purpose
Line Chart	YTD Sales by Month
Column Chart	YTD Sales by Week
Text Table / Heat Map	Sales by Product Category
Horizontal Bar Chart	Top 5 Products by YTD Sales
Horizontal Bar Chart	Top 5 Products by YTD Reviews

---

🛠️ Functionalities Used

• Power Query Editor for data cleaning
• Data Modeling (relationships between tables)
• DAX calculations:
  • YTD, QTD, CALCULATE, FILTER
  • DATE, TEXT, and Time Intelligence functions
• Custom sorting & formatting
• Conditional Formatting
• Slicers for interactivity (Product, Quarter)
• Interactive navigation & dynamic visuals

---

🧰 Tools & Technologies

• Microsoft Excel 2021 – for raw data manipulation
• Power BI (May 2025) – for building the report and dashboard

---

📷 Dashboard Screenshot

---

📁 Files in this Repository

File Name	Description
amazon_sales.pbix	Power BI dashboard project file
amazon_combined_data.xlsx	Cleaned dataset used in Power BI
dashboard_screenshot.png	Screenshot of the final dashboard
README.md	This documentation

---

📬 Contact

Feel free to reach out for any feedback or suggestions.

Harshdev Parmar
📧 Email: harsh.parmar03@gmail.com

---