📊 Amazon Sales Analysis

Project Overview

Welcome to the Amazon Sales Analysis project! This project provides a detailed analysis of Amazon sales for the year 2022, covering various aspects such as sales performance, order statuses, product categories, fulfillment methods, and geographical insights. The insights gained from this analysis can help in understanding sales trends, identifying top-performing products, and improving overall business strategies.

This project was completed as part of the InnoByte Services internship programme.

📈 Key Insights

Monthly Sales Growth: Analysis of monthly sales data to identify trends and growth patterns.
Order Status Distribution: Breakdown of order statuses (delivered, returned, canceled) to understand fulfillment efficiency.
Top Product Categories: Identification of best-selling product categories to focus marketing efforts.
Fulfillment Methods: Comparison of different fulfillment methods and their impact on delivery times and customer satisfaction.
Geographical Insights: Sales distribution across different states and cities in India to identify regional performance.

🛠️ Tech Stack

Data Analysis: Python, Pandas
Visualization: Power BI,DAX
Reporting: Power BI(.pbix), Analysis Report

📂 Project Structure

data/: Contains raw and processed data files.
notebooks/: Jupyter notebook containing analysis codes.
reports/: Generated reports including:
- Power BI file with analysis and visualizations (Dashboard/PBI report)
- PDF version of the Power BI report for quick insights
- Word document with a link to the Live Dashboard
- Detailed report with insights, recommendations, and actionable suggestions to optimize business operations, enhance customer experience, and drive revenue growth.

📊 Sample Visualizations

Figure 1: Monthly Sales Growth

Figure 2: Saleds Amount by Product Size