🛍️ Retail Sales Analysis using SQL

This project analyzes a retail company's sales and financial performance using structured SQL queries in MySQL.

---

📁 Dataset Overview

The dataset (FINANCIALS table) includes:

• Product-level transaction records
• Columns: Segment, Country, Product, Discount Band, Units Sold, Gross Sales, COGS, Profit, Date, Month, Year

---

🔍 Analysis Breakdown

🧪 1. Data Exploration

• Previewed data
• Checked row counts, nulls, and time range
• Explored unique segments, products, and countries

💰 2. Sales & Profit Analysis

• Total revenue, cost, and profit
• Top countries by sales
• Highest profit product and top revenue segment

📆 3. Time-Based Trends

• Yearly and monthly sales trend
• Month with highest average profit

📦 4. Product Performance

• Top-selling products by unit
• Profit margin and profitability insights

📊 5. Advanced Insights

• Profit per unit sold
• Average discount by segment
• Best country-product combination for profit

---

🖼️ Sample Output

Profit per Unit Sold (MySQL Workbench Screenshot)

---

🛠️ Tech Stack

• Database: MySQL
• Tool: MySQL Workbench
• Language: SQL

---

📌 How to Use

1. Clone the repo
2. Load the dataset into MySQL
3. Run sql/retail_analysis.sql to explore and analyze

---

📫 Contact

Musthaq Ahamed
LinkedIn
📧 mustaaquh@gmail.com