Sales Order Performance & Revenue Impact Analysis (SQL)

📌 Project Overview

This project analyzes sales order data to understand revenue trends, product performance, delivery delays, and the revenue impact of delayed orders using SQL.

🗂 Dataset

• sales_details table containing order dates, shipment dates, sales value, quantity, and product identifiers.

🛠 SQL Concepts Used

• Aggregations (SUM, COUNT, AVG)
• GROUP BY
• CASE statements
• CTEs
• Window functions (LAG)
• Date calculations

🔍 Key Analyses

• Overall sales performance
• Monthly sales trends
• Month-over-month growth
• Top and low-performing products
• Shipping delay analysis
• Revenue impact of delayed vs on-time orders

📈 Business Insights

• Identified how delivery delays affect total revenue
• Highlighted high-value orders and operational risk areas

🚀 Tools

• MySQL
• GitHub