Project Report: Amazon Sales
Analysis
Introduction
The objective of this project is to analyze the provided Amazon sales data to extract actionable insights
and support business decision-making. The dataset contains detailed information on sales transactions,
including order ID, date, status, fulfillment method, sales channel, product category, size, quantity,
amount, shipping details, and more.
Key Objectives
1. **Sales Overview**: Understand overall sales performance, trends, and patterns over time.
2. **Product Analysis**: Analyze the distribution of product categories, sizes, and quantities sold to
identify popular products.
3. **Fulfillment Analysis**: Investigate the fulfillment methods used and their effectiveness in
delivering orders.
4. **Customer Segmentation**: Segment customers based on their buying behavior, location, and other
relevant factors.
5. **Geographical Analysis**: Explore the geographical distribution of sales, focusing on states and
cities.
6. **Courier Status Analysis**: Analyze the distribution of courier statuses to assess the efficiency of
order delivery.
Data Preparation
1. **Data Loading**: The dataset was loaded into a Pandas DataFrame.
2. **Data Cleaning**: The 'Amount' column was converted to numeric, and rows with NaN values in the
'Amount' column were dropped.
3. **Date Formatting**: The 'Month' column was ordered correctly for analysis.
Analysis and Insights
1. Sales Overview
Monthly Sales Overview
- The sales trend over the months shows a significant increase in April, followed by decreases in May
and June.
- **Monthly Sales**:
- March: ₹101,683.85
- April: ₹28,627,458.79
- May: ₹26,105,818.34
- June: ₹23,344,842.90
Weekly Sales Overview
Weekly Sales
- Friday: ₹10,745,150.26
- Monday: ₹11,279,219.51
- Saturday: ₹11,279,327.90
- Sunday: ₹11,983,539.39
- Thursday: ₹10,311,261.22
- Tuesday: ₹11,388,563.92
- Wednesday: ₹11,192,741.68
2. Product Analysis
Top 5 Product Categories
- T-shirt: ₹39,074,570.36
- Shirt: ₹21,127,971.29
- Blazzer: ₹11,141,538.83
- Trousers: ₹5,328,406.30
- Perfume: ₹787,818.66
- Top 5 Product Sizes
- M: ₹13,629,948.32
- L: ₹12,968,681.45
- XL: ₹12,181,655.71
- XXL: ₹10,412,257.10
- S: ₹10,391,969.70
3. Fulfillment Analysis
-Fulfillment Methods Distribution
- Amazon: 89,085
- Merchant: 38,932
4. Customer Segmentation
Top 5 Customers by Sales
- Order ID 408-3363121-6123562: ₹8,636.0
- Order ID 405-8750647-4224357: ₹8,081.0
- Order ID 403-4288285-8521928: ₹6,993.0
- Order ID 404-9932919-6662730: ₹6,832.0
- Order ID 408-3317403-1729937: ₹6,680.0
5. Geographical Analysis
- Top 5 States by Sales
- Maharashtra: ₹13,261,933.90
- Karnataka: ₹10,421,496.02
- Telangana: ₹6,880,035.27
- Uttar Pradesh: ₹6,798,644.08
- Tamil Nadu: ₹6,477,109.53
- Top 5 Cities by Sales
- Bengaluru: ₹6,806,039.31
- Hyderabad: ₹4,923,424.25
- Mumbai: ₹3,677,250.37
- New Delhi: ₹3,596,827.78
- Chennai: ₹3,085,104.93
6. Courier Status Analysis
Courier Status Distribution
- Shipped: 85.01%
- On the Way: 5.31%
- Unshipped: 5.19%
- Cancelled: 4.49%
Overall Results
1. **Sales Trend Monitoring**: Regularly monitor sales trends to identify potential declines early
and take corrective actions.
2. **Product Inventory Management**: Focus on maintaining adequate inventory for popular
product categories and sizes, particularly T-shirts and sizes M, L, and XL.
3. **Fulfillment Strategy**: Evaluate the performance of Amazon vs. Merchant fulfillment
methods and optimize the use of each method based on efficiency and customer satisfaction.
4. **Customer Loyalty Programs**: Develop loyalty programs targeting top customers to
encourage repeat purchases.
5. **Geographical Focus**: Prioritize marketing and sales efforts in high-performing states like
Maharashtra and Karnataka and cities like Bengaluru and Hyderabad.
6. **Courier Performance**: Work with courier services to improve the proportion of 'Shipped'
orders and reduce 'On the Way' and 'Unshipped' statuses.
Conclusion
The comprehensive analysis of the Amazon sales data provides valuable insights into sales performance,
product preferences, fulfillment methods, customer behavior, and geographical sales distribution.
Implementing the recommendations can help optimize business operations, enhance customer
experience, and drive revenue growth.
Deliverables
- Analysis report with visualizations
- Actionable insights and recommendations for improving sales strategies, inventory management, and
customer service