SQLCase
Home / Advanced
Advanced

Advanced track

RFM, cohorts, recursive CTEs, and full business dashboards — the complete analyst toolkit. 15 cases.

Advanced Analytics
CASE 036

Revenue by Channel

customersmarketing_touchesorders
✓
CASE 037

Month-over-Month

orderspayments
✓
CASE 038

Best Seller Per Category

order_itemsproducts
✓
CASE 039

Spending Quartiles

customersorderspayments
✓
CASE 040

The Rolling Average

customersorderspayments
✓
Segmentation & Reporting
CASE 041

The Cross-Sell Opportunity

customersordersorder_items
✓
CASE 042

New, Returning, or Loyal

customersorders
✓
CASE 043

The Customer Scorecard

customersorderspayments
✓
CASE 044

The Cohort Quality Check

customersorders
✓
CASE 045

The Strongest Pairing

order_itemsproducts
✓
Mastery & Capstone
CASE 046

RFM Segmentation

customersorderspayments
✓
CASE 047

Unpredictable Buyers

customersorders
✓
CASE 048

The Customer Who Was Due

customersorders
✓
CASE 049

Filling the Gaps

orders
✓
CASE 050

The Shape of the Business

customersorderspayments
✓

Looking for a different level?

BeginnerIntermediate