Amazon Products Sales and Reviews Analysis Dashboard

Dashboard Link: https://www.novypro.com/profile_about/ankurshukla?Popup=memberProject&Data=1727008320987x494018075147536960

The Amazon Products Sales and Reviews Dashboard is a dynamic Power BI solution designed to analyze sales and review performance for Amazon products. It addresses the challenge of fragmented data by consolidating key metrics such as Year-to-Date (YTD) Sales, Quarter-to-Date (QTD) Sales, product reviews, and category trends. This tool enables data-driven decisions for optimizing product listings, marketing, and inventory.

Data Cleaning & Transformation:

Raw sales and review data were imported, cleaned, and transformed using Power Query. This included handling missing values, parsing product details, and standardizing data formats.

Data Modeling & Relationships:

The data was modeled using the Star Schema, with fact tables for sales and reviews, and dimension tables for product categories, time, and regions. Relationships between these tables were created to ensure seamless analysis.

DAX Calculations & Measures:

Key metrics like Total Sales, Profit Margins, and Review Ratios were calculated using DAX. Measures for YTD/QTD Sales and Category Contribution provided dynamic, interactive insights as users explored the dashboard.

Interactive Visualizations:

The dashboard features line charts for sales trends, bar charts for top-selling products, and heatmaps for category performance. Interactive slicers allow filtering by product category and quarter, supporting drill-down analysis.

Business Value:

This dashboard empowers stakeholders with real-time insights into product performance, enabling better inventory management and marketing strategies. By combining clean data, efficient modeling, and advanced visualizations, this solution adds significant value to business decision-making.

The Amazon Products Dashboard showcases the end-to-end data analytics process, from data cleaning to DAX calculations and visualization. It enables Amazon to monitor key KPIs such as Total Sales, Product Reviews, and Top Performers, offering a clear path for data-driven insights and decisions.