Skip to content

README.md

Latest commit

 

History

History
72 lines (47 loc) · 1.58 KB

README.md

File metadata and controls

72 lines (47 loc) · 1.58 KB

🛍️ Retail Sales Analysis using SQL

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)

Profit Metrics

🛠️ 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