Sales Data Analysis Project

Project Overview

This project analyzes sales data to provide insights into sales performance by region, product category, and month. It includes Python-based analysis and SQL queries.

Folder Structure

• data/ - Contains the sales CSV file
• notebooks/ - Python Jupyter notebook for analysis
• sql/ - SQL queries for analyzing the sales data

Python Analysis

• Data loading and cleaning
• Sales by region (bar chart)
• Monthly sales trend (line chart)

SQL Analysis

• Total sales by region
• Total profit by category
• Top 5 products by sales
• Monthly sales trend
• Orders with profit < 0

Technologies Used

• Python (pandas, matplotlib)
• SQL
• Jupyter Notebook

How to Run

1. Open notebooks/sales_analysis.ipynb in VS Code or Jupyter Notebook
2. Install required Python packages: pandas, matplotlib
3. Run each cell to see the analysis and charts
4. SQL queries can be executed in any SQL database after importing the CSV