# 📊 SQL Business Sales Analysis

## 📌 Project Overview

This project analyzes e-commerce sales data using MySQL and SQL.

The goal is to identify business insights related to revenue, profit, products, customers, categories, regions, and monthly sales performance.

## 🎯 Objectives

- Analyze total revenue and profit

- Identify top-selling products

- Analyze sales by category

- Compare regional performance

- Identify top customers

- Calculate Average Order Value

- Analyze monthly revenue

- Perform product and region ranking

- Calculate month-over-month revenue changes

## 🛠️ Technologies Used

- MySQL

- SQL

- Git

- GitHub

## 🔍 SQL Concepts Used

- SELECT

- GROUP BY

- ORDER BY

- HAVING

- LIMIT

- Aggregate Functions

- CASE WHEN

- Subqueries

- CTE

- Window Functions

- RANK()

- LAG()

## 📂 Project Structure

SQL-Business-Sales-Analysis/

│

├── data/

│   └── sales\_data.csv

│

├── sql/

│   ├── 01\_database\_setup.sql

│   ├── 02\_basic\_analysis.sql

│   ├── 03\_product\_analysis.sql

│   ├── 04\_customer\_analysis.sql

│   └── 05\_advanced\_analysis.sql

│

├── README.md

├── requirements.txt

└── .gitignore


## 📌 Project Status

Completed SQL business sales analysis using MySQL.
## 📅 Project Update

- Added advanced SQL business analysis queries.
- Added revenue, profit, customer, product and regional analysis.
- Added ranking and month-over-month analysis using SQL window functions.
## Business Insights

- Analyzed category-wise revenue and profit
- Identified top profitable products
- Analyzed top customers by revenue
- Compared regional sales performance
- Studied monthly sales trends
- Identified high-sales but low-profit products
- Calculated overall orders, revenue, profit, and average order value