๐ง SQL Concepts You'll Practice
โ DDL & DML
โ INNER JOIN
โ LEFT JOIN
โ GROUP BY
โ HAVING
โ Aggregate Functions
โ CASE WHEN
โ CTEs
โ Window Functions
โ Date & Time Functions
๐ Business KPIs You Can Build
๐ Total Orders
๐ Total Revenue
๐ Average Order Value (AOV)
๐ Average Delivery Time
๐ On-Time Delivery Rate
๐ Delayed Delivery Rate
๐ Orders by Hour
๐ Peak Ordering Hour
๐ Orders by Day of Week
๐ Revenue by Restaurant
๐ Revenue by City
๐ Top 10 Restaurants
๐ Top Customers by Spending
๐ Average Restaurant Rating
๐ Delivery Partner Performance
๐ Average Orders per Delivery Partner
๐ Highest Revenue Cuisine
๐ Customer Retention Rate
๐ Repeat Order Rate
๐ Cancellation Rate
๐ Delivery Time by City
๐ Delivery Time by Cuisine
๐ Revenue Trend (Daily & Monthly)
๐ Restaurant Market Share
๐ Customer Lifetime Value (CLV)
๐ฏ This project simulates the SQL work performed by Data Analysts at companies like Swiggy, Zomato, Uber Eats, and DoorDash, making it an excellent portfolio project for analytics interviews.
๐ก Double Tap โค๏ธ For More
Post #2596
2.09K
- โค 8