Retail Sales Data Analysis using SQL

📌 Project Overview

This project demonstrates advanced SQL skills including:

• DDL & DML operations
• Joins (Inner, Left, Self)
• Aggregations
• Window functions
• Data cleaning
• Performance optimization
• Business reporting queries

🛠 Tools Used

• SQL Server / PostgreSQL / MySQL
• GitHub for version control

📊 Dataset

Retail sales dataset containing:

• Customers
• Products
• Orders
• Order Items

🚀 Key SQL Concepts Demonstrated

• GROUP BY & HAVING
• Window functions (RANK, DENSE_RANK, ROW_NUMBER, SUM OVER)
• CTEs
• Subqueries
• Index creation
• Data validation & cleaning

📈 Business Problems Solved

• Top selling products
• Revenue trends
• Customer segmentation
• Monthly growth
• Running totals
• Customer lifetime value