Project 2 – Customer Order Behavior Analysis Using SQL

📌 Topics Covered

• Customer segmentation using CASE WHEN
• Ranking with ROW_NUMBER() and RANK() window functions
• Aggregation by customer, category, and payment mode
• Data quality assessment at the customer level

📝 Project Summary

This project analyzes customer purchasing behavior from retail data in BigQuery. Learners will identify high-value customers, segment buyers into spending tiers, and analyze payment preferences. Using aggregation and introductory window functions, the project produces customer-level insights and a documented SQL report for business decision-making.

✅ What You Will Learn

• Identify top customers by revenue
• Segment customers into High/Medium/Low spending tiers
• Analyse payment preferences across regions
• Rank customers within product categories
• Detect potential duplicate or inconsistent customer records

Note to Students –

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

Click “Mark as Complete” button.

Good Luck.