welcome! here is a quick summary of the Retail Sales Analysis project using SQL This project analyzes retail sales data using SQL to uncover business insights such as monthly sales trends, top-performing product categories, and customer purchasing patterns. The analysis helps identify high-performing months and product segments.
Key objectives of this analysis • Analyze sales performance across different product categories • Identify the best-selling months in each year • Evaluate average sales trends • Understand quantity sold patterns • Answer business questions
Dataset contains
- Transaction ID
- Customer ID
- age
- Sale Date
- Sale time
- gender
- Product Category
- Quantity Sold
- cogs
- price per unit
- Total Sales Amount
Key SQL operations used in this project
• Data filtering using WHERE conditions • Aggregations using SUM, AVG, COUNT • Date analysis using YEAR() and MONTH() • GROUP BY for summarizing data • ORDER BY for sorting results