Amazon Sales Dashboard

The project aims to provide comprehensive insights into Amazon's 2022 sales performance across product categories, service levels, and fulfillment types. It focuses on identifying trends, inefficiencies, and opportunities to optimize operations, customer satisfaction, and revenue.

Questions and Answers

Which product categories generate the highest sales?

The top categories include Set, Kurta, and Western clothing, with sales of 35.51M, 19.01M, and 10.13M, respectively.

How do different service levels affect sales?

Expedited service drives 51M in sales, while Standard service contributes 20M, showing a preference for faster delivery.

What percentage of orders are fulfilled by Amazon vs. merchants?

69.78% of orders are fulfilled by Amazon, and 30.22% by third-party merchants.

Which sizes are most popular among customers?

M, L, and XL sizes lead in demand, with quantities around 19K, 19K, and 18K units, respectively.

Where are the most cancellations happening?

Zundal, Zamnia, and Zirakpur account for a significant portion of the cancellations, impacting sales performance.

Recommendations

Optimize Inventory for Popular Sizes: Ensure adequate stock of M, L, and XL sizes to meet high demand and prevent stockouts.

Improve Fulfillment for Merchants: Support third-party merchants to align with Amazon’s standards, improving customer trust and reducing cancellations.

Analyze Cancellations in Key Cities: Investigate operational challenges in Zundal, Zamnia, and Zirakpur to reduce order cancellations.

Enhance Expedited Shipping Capacity: Expand resources to support expedited shipping, meeting customer preferences for faster delivery.

Promotional Strategy: Increase promotions for third-party merchants to improve their sales contribution and balance fulfillment methods.