📊
CASE #01 · CONFIDENTIAL · ANALYST BRIEFING
A jump in Churn in Q1 2026
An 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 jump in customer churn in the first quarter of 2026.
3 questions the CMO wants answers to
- who The customers who churn? Which segment?
- why Are they churning? What are the main factors?
- what to do this week to stop the churn?
How to work in the simulator
will pass 13 built-in steps. The first steps establish classic business analysis
(segmentation, GROUP BY, CTE), and the last ones challenge you with Window Functions
andAdvanced Subqueries. The last step is attaching the written analysis — getting a score of 0-100.
The rules of the game
- You can write As many queries as you want at every step.
- Step marked ✓ Automatic When the query is aimed in the right direction.
- The sample code in the hint locked until you run the 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 of the page.
- button 🗄️ Overview of the tables in the header — always available, shows all the tables and data.