Intermediate 4 days · 50 tasks

Network Complaints and Call Drops

A mobile operator's call drops and complaints have jumped, and unhappy customers are porting out. Join tower KPIs to complaint tickets, find what is breaking the network and the service, and size the revenue walking out.

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

Locked for now

This project opens soon. Start with the free project in Telecom meanwhile.

See Telecom projects

The problem

The CTO needs to know how much call drops, outages, congestion and complaints have changed from July to October 2026, which causes explain them (the Telnova upgrade, power backup, capacity, complaint handling), whether bad experiences are driving port-outs, and how much revenue is at risk, using site KPIs, complaint tickets and customer data.

How it works

Start the project — the 4-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: executive summary, data quality, findings and recommendations.
Two to four charts from your Python notebook, added to the report.