Analyst
Lead Analyst
Project
Kilele Mobile · Power BI · Beginner
The brief
From: Wanjiru Kamau, Chief Commercial Officer
I am taking the subscriber question to the board as one page, not a deck. Build me that page in Power BI from the kilele database.
The page must show: 1. Two cards side by side: Reported Active (our 90-day rule as it stands) and Revenue Active (the same rule, but Karibu promo credits do not count as revenue and the subscriber must have either usage or customer money in the window). Both as of 2026-06-30. 2. Active by region with both measures on the same bar chart. 3. Promo SIM activations by month across 2025, so the Karibu drive is visible. 4. A small table of the gap by region: how many "active" subscribers in each region are Karibu credits only. 5. A title that states the gap as a number and a percentage.
Connect to subscribers, recharge…
Independent grading
97/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