📊
CASE #01 · CONFIDENTIAL · ANALYST BRIEFING
Churn Spike in Q1 2026
Israeli telecom company · operational crisis · 6,000 customers at risk
The Situation
You are a data analyst at an Israeli telecom company. In this morning's management meeting, the CMO presented a troubling figure:
a sharp spike in customer churn in the first quarter of 2026.
The 3 questions the CMO wants answered
- Who are the customers churning? Which segment?
- Why are they churning? What are the main drivers?
- What to do this week to stop the churn?
How the simulator works
You will go through 13 structured steps. The first steps build classic business analysis
(segmentation, GROUP BY, CTE), and the later ones challenge you with Window Functions
and advanced Subqueries. The final step is writing up the analysis — and getting a score of 0-100.
The Rules
- You can write as many queries as you want in each step.
- A step is marked ✓ automatically when the query is on the right track.
- The sample code in the hint is locked until you run your first query — try it yourself first!
- You can jump between steps from the sidebar, and return to this briefing from any step via the banner at the top.
- The 🗄️ Table Viewer button in the header — always available, shows all the tables and data.