What you've learned in Advanced
Advanced Analytics
- First-touch attributionCase 036: Revenue by Channel →
- LAG over an aggregated CTE (time-series comparison)Case 037: Month-over-Month →
- Top-N per group (ROW_NUMBER + PARTITION BY)Case 038: Best Seller Per Category →
- NTILE()Case 039: Spending Quartiles →
- Window frames (ROWS BETWEEN)Case 040: The Rolling Average →
Segmentation & Reporting
- EXCEPT (set difference)Case 041: The Cross-Sell Opportunity →
- Customer segmentation (CTE + CASE)Case 042: New, Returning, or Loyal →
- Multi-CTE reportCase 043: The Customer Scorecard →
- Cohort analysis with conditional COUNT DISTINCTCase 044: The Cohort Quality Check →
- Self-join + ratio (multi-step CTE)Case 045: The Strongest Pairing →
Mastery & Capstone
- Recency/Frequency/Monetary scoringCase 046: RFM Segmentation →
- STDDEV_SAMP as a custom aggregateCase 047: Unpredictable Buyers →
- Predictive flagging (LAG + AVG + date math)Case 048: The Customer Who Was Due →
- Recursive CTE (generating a date series)Case 049: Filling the Gaps →
- Capstone: full multi-metric dashboardCase 050: The Shape of the Business →