# Retail Sales Analysis using SQL

## Overview

This project analyzes the Kaggle Superstore dataset using SQL to derive business insights related to sales, profitability, customer behavior, and regional performance.

## Tools Used

- MySQL

- SQL

- Kaggle Superstore Dataset

## Business Questions Solved

1. Total sales and profit analysis

2. Category wise sales performance

3. Profitability analysis

4. Top profitable products

5. Loss making products

6. Regional performance

7. Monthly sales trend

8. Customer segment analysis

9. Top performing cities

10. Discount impact on profit

## Key Insights

- Technology category generated highest profits

- West region dominated sales

- Heavy discounts reduced profitability

- Certain products consistently caused losses

## Project Structure

Retail-Sales-Analysis/

│

├── data/

├── sql/

│ └── queries.sql

├── outputs/

├── README.md

## Dataset Source

Kaggle Superstore Dataset