Analyst
Analyst
Project
Kilele Mobile · SQL · Intermediate
The brief
From: Peter Mwangi, Head of Network Planning
Six new sites for Kisumu were approved last year with 2025 dates. None is live. Complaints from Kisumu are up and the CFO's position is that "Nyanza is fine on the dashboard". Nyanza is not Kisumu. I need the case for Kisumu in numbers he will sign, by Friday.
From the kilele database: 1. Monthly average busy-hour utilisation and dropped-call rate, Jan 2025 to Jun 2026, for Kisumu town sites (towns Kisumu CBD, Kondele, Mamboleo, Nyalenda) against all other live sites. 2. For 2026 H1, the number of sites averaging above 90 percent and above 95 percent busy-hour utilisation, by town. Kisumu against the rest. 3. Planned sites in Kisumu town with their target commissioning dates. 4. Network complaints per 1,000 active subscriber-months by half-yea…
Independent grading
62/100
Achieved 4 Nov 2026
Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.
What is DataSimHQ?
A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more