Amazon Sales Dashboard in Power BI

https://app.powerbi.com/view?r=eyJrIjoiOGI0OWM1ODEtMjlkMS00ZTM2LTk2YzUtMDFjNTM3Zjg5NmI3IiwidCI6ImIyMDE2N2Y1LWRlYjktNDQ5Yy05ODBlLThkZGQ0MGJlOGU2MSJ9

Client: Amazon Seller (E-commerce) Project Type: Sales Analytics Dashboard Platform: Microsoft Power BI Data Source: Excel (Amazon Sales Export)

Problem: The client lacked clear visibility into their Amazon sales performance across regions and products, making it difficult to track KPIs like revenue, ROI, and top-selling items. Decision-making around marketing, inventory, and pricing was delayed due to manual data handling.

Solution: I designed a Power BI dashboard connected to their Excel sales data. Using Power Query and DAX, I modeled the data to produce meaningful insights. The dashboard includes dynamic filters, category-wise breakdowns, trend visuals, drilldowns, and KPIs that helped the client track performance in real time and make informed decisions quickly.

Connected and automated data refresh from Excel

KPI tracking: Revenue, Orders, ROI, and Profitability

Filters for region, product category, and time period

Drilldown into SKU-level performance

Sales trends and top-selling product visualizations

Insights for stock, pricing, and marketing optimization