Amazon India Sales Performance Analysis

Mini Project — Excel to Python Bootcamp
Developer: Jeet Sengupta (Junior Data Analyst)

📊 Business Problem Statement

As a newly joined Junior Data Analyst at Amazon India, the Sales and Operations team provided a comprehensive sales transaction dataset spanning various Indian states, product categories, payment modes, and customer segments.

The objective of this project is to evaluate overall business performance, uncover regional and product-level inefficiencies, and provide data-driven insights to help management plan the upcoming quarter's strategy.

---

🚀 Project Objectives & Scope

• Data Cleaning & Preprocessing: Programmatically handle missing data, remove duplicates, fix structural errors, and ensure correct data types using Python.
• Sales & Profitability Analysis: Evaluate financial performance metrics across time periods, states, and payment modes.
• Product Performance Evaluation: Identify top-performing categories and flag bleeding, underperforming products.
• Geographical Insights: Isolate underperforming regions across India to identify strategic choke points.
• Data Visualization & Dashboards: Create interactive or static visual dashboards to present complex trends simply.
• Strategic Recommendations: Formulate actionable business solutions based on data trends.

---

🛠️ Tech Stack & Tools

• Development Environment: Google Colab (Python 3)
• Data Manipulation: Pandas, NumPy
• Data Visualization: Matplotlib, Seaborn
• File Management & Version Control: Git, GitHub, MS Excel (.xlsx)

---

📈 Key Business Questions Addressed

1. Which product categories drive the highest revenue and profit margins?
2. Which states or regions are underperforming and require operational restructuring?
3. How do different payment modes impact order values or frequencies?
4. What operational bottlenecks or low-margin items should be eliminated before next quarter?

---

🏅 Certification & Verification

This mini-project was completed as part of the curriculum for the Excel to Python Analytics Bootcamp hosted by DevTown.

• 📂 Verified Credentials: View My Merged Certificates (PDF)

Institutional Verification Links:

• Microsoft Student Chapter (GNIT): Verify Completion
• Google Developers Group On Campus (CSMU): Verify Completion
• DevTown & MSME Community Support: Verify Appreciation