Verified by DataSimHQ

Analyst

Sumaya Mateen

Lead Analyst

Project

How many subscribers are real

Kilele Mobile · SQL · Beginner

The brief

From: Wanjiru Kamau, Chief Commercial Officer

The board gets one number from me every quarter: active subscribers. Last quarter I quoted the figure straight from the warehouse, the same 90-day rule we have always used. Then Grace mentioned that a lot of the free SIMs we handed out in the Karibu drive never made a call.

I want to know how many of our active subscribers are real before I stand up again in September.

What I need, as of 2026-06-30: 1. Subscribers by status (active, dormant, churned), and active subscribers by region. 2. Promo SIM activations by month for 2025, so I can see the shape of the Karibu drive. 3. From subscriber_flags, the number of active subscribers flagged karibu_only (no usage in the last 90 days and no customer money, only the 1 KES Karibu credits), the share…

Independent grading

97/100

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