This project focuses on analyzing an Amazon Sales Report to extract meaningful insights related to sales performance, product demand, customer behavior, and geographical distribution. The analysis uses Python and data analysis techniques to support data-driven business decision-making.
Analyze overall sales trends and performance
Identify top-selling products, categories, and sizes
Understand customer buying behavior
Analyze fulfillment methods and their effectiveness
Explore geographical sales distribution
Provide actionable business recommendations
Source: Amazon Sales Report (CSV file)
Key Columns:
Order ID
Date
Category
Style (Product Identifier / SKU equivalent)
Size
Quantity (Qty)
Amount (Sales Value)
Fulfilment
Ship-state
Ship-city
##Tools & Technologies
Python
Pandas – Data cleaning & analysis
Matplotlib – Data visualization
Jupyter Notebook
Data cleaning (missing values, duplicates, date formatting)
Sales overview and trend analysis
Product analysis (category, style, size demand)
Fulfillment performance analysis
Customer and geographical segmentation
KPI calculation (total sales, average order value, top regions)
Sales are driven by a limited number of high-performing categories and styles
Certain sizes show consistently higher demand
Sales are concentrated in specific states and cities
One fulfillment method contributes significantly to revenue and order volume
Some products are slow-moving and require inventory optimization
Increase inventory for high-demand products and sizes
Focus marketing efforts on top-performing regions
Optimize fulfillment strategy to improve delivery efficiency
Reduce stock for slow-moving products
Use sales trends to plan promotions during peak periods
The project delivers actionable, data-driven insights that help optimize sales strategy, inventory management, customer experience, and overall business performance. It demonstrates how data analysis can support better decision-making and revenue growth in an e-commerce environment.
📁 Project Structure ├── Amazon_Sales_Analysis.ipynb ├── Amazon Sale Report.csv ├── README.md