📊 Amazon Sales Analysis

A comprehensive Data Analytics project focused on analyzing Amazon sales data to uncover business insights related to sales performance, customer behavior, product categories, and fulfillment operations.

The project combines Python-based Exploratory Data Analysis (EDA) with Power BI dashboards to transform raw sales data into actionable business intelligence.

---

📌 Project Overview

E-commerce platforms generate large volumes of transactional data that can be leveraged to improve decision-making and business performance.

This project analyzes Amazon sales data to identify:

• Sales trends
• Product performance
• Customer segments
• Fulfillment efficiency
• Revenue contribution by category
• Geographic sales distribution

The analysis was performed using Python for data cleaning and exploration, followed by Power BI for interactive dashboard creation.

---

🎯 Objectives

• Analyze overall sales performance
• Identify top-performing product categories
• Evaluate fulfillment methods
• Understand customer purchasing behavior
• Discover high-revenue states
• Generate actionable business insights

---

🛠️ Tools & Technologies Used

Programming Language

• Python

Data Analysis

• Pandas
• NumPy

Data Visualization

• Matplotlib
• Seaborn

Business Intelligence

• Power BI

Version Control

• Git
• GitHub

---

📂 Project Structure

amazon-sales-analysis-project/
│
├── Data/
│   ├── raw_dataset.csv
│   └── cleaned_dataset.csv
│
├── Notebook/
│   └── amazon_sales_analysis.ipynb
│
├── Powerbi/
│   ├── dashboard.pbix
│   └── report.pdf
│
└── README.md

---

⚙️ Project Workflow

1. Load raw sales dataset
2. Perform data cleaning
3. Handle missing values
4. Conduct exploratory data analysis
5. Visualize sales patterns
6. Analyze product performance
7. Create business insights
8. Develop interactive Power BI dashboard
9. Generate final report

---

📈 Exploratory Data Analysis

The following analyses were performed:

• Sales Trend Analysis
• Product Category Analysis
• Revenue Distribution Analysis
• State-wise Performance Analysis
• Customer Segment Analysis
• Fulfillment Analysis
• Order Status Analysis

---

🔍 Key Business Insights

Product Performance

• T-Shirts and Shirts contribute approximately 77% of total net revenue.
• Apparel products dominate overall sales performance.

Fulfillment Analysis

• Amazon Fulfillment demonstrates better operational performance.
• Lower loss percentage compared to merchant fulfillment methods.

Geographic Analysis

• Maharashtra generates the highest revenue.
• Karnataka is the second highest-performing state.

Customer Segmentation

• B2C orders account for approximately 99.2% of all orders.
• B2B customers generate a higher Average Order Value (AOV).

---

📊 Power BI Dashboard

The Power BI dashboard provides interactive visualizations including:

• Revenue Overview
• Product Category Performance
• State-wise Sales Analysis
• Fulfillment Performance
• Customer Segment Analysis
• Order Distribution

---

📸 Dashboard Screenshots

Sales Overview Dashboard

Revenue & Category Analysis

---

🚀 Business Impact

The insights generated from this analysis can help:

• Improve inventory planning
• Optimize fulfillment strategies
• Identify high-performing regions
• Increase profitability
• Enhance customer targeting

---

📈 Future Improvements

• Sales forecasting using Machine Learning
• Customer churn prediction
• Product recommendation analysis
• Interactive web dashboard
• Real-time sales monitoring

---

👩‍💻 Author

Asvithaa K

Data Analytics & Business Intelligence Enthusiast

---

⭐ Support

If you found this project useful, consider giving it a star on GitHub.