Project 1 – Retail Sales Performance Analysis Using SQL

📌 Topics Covered

• Writing queries to measure revenue, profit, and order volume
• Aggregation with GROUP BY, HAVING, and CASE WHEN
• Filtering data using WHERE and date functions
• Ranking and segmenting data into Low/Medium/High tiers
• Monthly trend analysis with ORDER DATE

📝 Project Summary
This project focuses on analyzing retail sales data across multiple product categories, states, and payment modes using SQL in BigQuery. Learners will progress from simple row-level queries to multi-dimensional summaries to identify top-performing categories, regions, and payment methods. The goal is to transform raw transactional data into actionable business insights, producing a clean, documented SQL report.

✅ What You Will Learn

• Calculate revenue, profit, and order count by category
• Identify top states by profit and rank them
• Segment transactions into value tiers using CASE WHEN
• Build monthly revenue and profit trends
• Audit data for duplicates and NULL values

Note to Students –

Live Classes will held on Google Meet.
Mentor will provide files, dataset in the Google Clasroom.
Class video will be provided on Google Classroom.

Click “Mark as Complete” button.

Good Luck.