📊 Jar Growth Data Analysis

Professional Sales Data Analysis Project developed using Python, Pandas, and Matplotlib as part of the Jar Growth Internship Assignment.

This project analyzes sales performance, profitability, monthly sales targets, and regional business performance to generate actionable business insights using real-world datasets.

📸 Project Screenshots

Category-wise Total Sales

Furniture Monthly Target Trend

Regional Sales Performance

📌 Project Overview

The objective of this project is to analyze business sales data and identify meaningful insights that can support business decision-making.

The analysis includes:

• Category-wise Sales Analysis
• Profitability Analysis
• Monthly Target Achievement Analysis
• Regional Sales Performance
• Business Recommendations

⭐ Project Highlights

✔ Category-wise Sales Analysis

✔ Profitability Analysis

✔ Monthly Target Achievement Analysis

✔ Regional Sales Performance

✔ Professional Data Visualizations

✔ Business Recommendations

✔ Recruiter-Friendly Documentation

✔ Portfolio-Ready Project Structure

✨ Features

• Data Cleaning and Validation

• Dataset Merging using Pandas

• Category-wise Sales Analysis

• Profit Margin Calculation

• Monthly Target Trend Analysis

• Regional Performance Analysis

• Business Insight Generation

• Professional Charts using Matplotlib

• Clean Folder Structure

• Exportable Reports

🛠 Tech Stack

• Python

• Pandas

• Matplotlib

• OpenPyXL

• Microsoft Excel

• Microsoft Word

• Git

• GitHub

📂 Project Structure

jar-growth-data-analysis/
│
├── data/
│   ├── List_of_Orders.xlsx
│   ├── Order_Details.xlsx
│   └── Sales_target.xlsx
│
├── charts/
│   ├── category_sales.png
│   ├── furniture_target_trend.png
│   └── regional_sales.png
│
├── Report/
│   ├── Jar_Growth_Intern_Assignment_Report.docx
│   └── Jar_Growth_Intern_Assignment.pdf
│
├── assignment.py
├── requirements.txt
├── README.md
└── .gitignore

🚀 Installation

Clone the repository

git clone https://github.com/soniyaritgithub/jar-growth-data-analysis.git

Move into the project folder

cd jar-growth-data-analysis

Install dependencies

pip install -r requirements.txt

Run the project

python assignment.py

📊 Generated Outputs

The project automatically generates:

• Category-wise Sales Report

• Profitability Summary

• Monthly Target Trend Analysis

• Regional Performance Summary

• Business Insights

• Professional Charts

• Word Report

• PDF Report

📚 Key Learnings

During this project I learned:

• Data Cleaning

• Data Analysis using Pandas

• Business KPI Analysis

• Data Visualization

• Python Project Structure

• Business Reporting

• Git & GitHub Workflow

🚀 Future Improvements

• Build an interactive dashboard using Streamlit.
• Add advanced business KPIs and performance metrics.
• Automate report generation in PDF format.
• Integrate the project with a SQL database.
• Add filtering and interactive visualizations.

👩‍💻 Author

Sunidhi Shinde

Python Developer | Data Analytics Enthusiast

GitHub: https://github.com/soniyaritgithub

LinkedIn: https://www.linkedin.com/in/sunidhishinde/