BeginnerFree 5 days · 50 tasks

Prepaid Churn After a Tariff Hike

A mobile operator raised prepaid prices on 3 July and fewer customers are renewing. Measure renewal and ARPU, and separate the effect of the price hike from dual-SIM users, a network problem in two circles and a UPI payment outage.

Vaani Telecom Ltd · SQL · Python (pandas, seaborn) · solved in your browser

Ready to start?

Create a free account to open the workspace, check your answers and earn a certificate.

The problem

Management does not know how much of the fall in renewals is caused by the price hike itself and how much by other problems. The Chief Marketing Officer needs a data-backed analysis of recharges from 1 January to 30 September 2026 to decide whether to launch a cheaper pack, target particular customers with retention offers, or push the network and payments teams to fix their issues first.

How it works

Start the project — the 5-day timer begins and the workspace opens with every table loaded.
Solve 50 tasks in SQL or Python (30 basic, 15 intermediate, 5 hard). Each is checked instantly.
Write the final report in the workspace and add charts from your notebook.
Score = 70% tasks + 30% report review. 60 or more earns a certificate.

What you will deliver

Answers to the 50 analysis tasks (30 basic, 15 intermediate, 5 hard), solved with SQL or Python in the JobPrax workspace.
A final report written in the workspace for the Chief Marketing Officer: executive summary, data quality, findings and recommendations.
Two to four charts from your Python notebook, added to the report (for example renewal rate by month, ARPU against recharging base, renewal by circle).