Verified by DataSimHQ

Analyst

Sumaya Mateen

Lead Analyst

Project

The capacity case

Kilele Mobile · Power BI · Intermediate

The brief

From: Peter Mwangi, Head of Network Planning

The CFO reads dashboards, not emails. Build the Kisumu case as one Power BI page from the kilele database.

The page must show: 1. Busy-hour utilisation by month, Kisumu town against all other live sites, with a reference line at 90 percent. 2. Dropped-call rate by month for the same two groups. 3. Sites averaging above 95 percent in 2026 H1, by town. 4. Network complaints per 1,000 active subscriber-months by half-year, Kisumu town against the rest. 5. A card for Kisumu silent churn (share of Dec 2025 active subscribers with no usage after April 2026) beside the same card for the rest. 6. A table of the planned Kisumu sites with their target dates and status.

Kisumu town is the four towns Kisumu CBD, Kondele, Mamboleo and Nyalenda. If you bui…

Independent grading

97/100

Achieved 12 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