• Customers, Subscriptions, Usage, Billing, Support tickets

• KPIs: Churn Rate, Retention Rate, ARPU, CLV, MRR

Project 3 — Banking Analytics

• Customers, Accounts, Transactions, Loans, Branches

• KPIs: Deposits, Withdrawals, Transaction Volume, Average Balance, Loan Exposure

Project 4 — Marketing Analytics

• Campaigns, Leads, Customers, Conversions, Revenue

• KPIs: Conversion Rate, CAC, CPL, CPA, ROI, Revenue per Channel

🔴 Month 6 — Interview & Job Preparation

Week 21: SQL Interview Fundamentals

• SELECT, WHERE, GROUP BY, HAVING, CASE, Joins, Subqueries

• Target: 50+ questions

Week 22: Advanced Interview Questions

• Window functions, CTEs, Ranking, LAG / LEAD, Running totals, Date calculations, Cohort analysis

• Target: 50+ questions

Week 23: Real-World Scenarios

• Customers who purchased in consecutive months

• Second-highest salary in each department

• Monthly retention

• Top 3 products by revenue for every month

• Customers whose spending increased month over month

🏆 Week 24 — Final SQL Challenge

• Raw Data → Database Design → Data Cleaning → SQL Analysis → Business KPIs → Insights → Dashboard → Business Recommendations

📚 SQL Topics Checklist

Beginner:

• SELECT, DISTINCT, WHERE, ORDER BY, LIMIT, AND / OR, IN, BETWEEN, LIKE, NULL

Intermediate:

• GROUP BY, HAVING, CASE, Aggregate functions, String functions, Date functions, Joins, Subqueries, CTEs

Advanced:

• Window functions, ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, Running totals, Moving averages, Cohort analysis, Retention analysis, Funnel analysis, Gaps & islands, Recursive CTEs

Data Analyst SQL:

• Revenue analysis, Customer analytics, Product analytics, Marketing analytics, Churn analysis, Cohort analysis, RFM analysis, KPI calculations, Business scenario analysis

⏱️ Double Tap ❤️ For Detailed Explanation of each topic