Retail Sales SQL Analysis

Overview

SQL project for analyzing retail sales data.

Business Questions

• Which products generate maximum revenue?
• Which cities have highest sales?
• Monthly Sales?
• Customer Purchase Frequency?
• Profit Analysis?

SQL Concepts Used

• SELECT
• GROUP BY
• ORDER BY
• JOIN
• CTE
• CASE
• Window Functions
• Aggregate Functions

Database

MySQL

Skills

SQL Data Analysis Business Intelligence