Project
Kilele Mobile · SQL · Beginner
The brief
From: Daniel Otieno, Head of Customer Value Management
Usiku is the best launch I have had. Two night bundles, 1GB for 20 KES and 3GB for 45 KES, 22:00 to 06:00, launched 1 September. Data volume on the network is up about 30 percent since. Wanjiru has asked me for "the money line", which I think is her way of saying well done, but she wants it from you, not me.
Please pull it together from the kilele database. subscriber_flags has a night_adopter flag for anyone who has ever bought a Usiku bundle. 1. How many subscribers are night adopters. 2. For adopters and for everyone else, the average data per month (total, daytime, night) and the average customer revenue per month, active months only, for Jun to Aug 2025. Then the same for Dec 2025 to Feb 2026. 3. Purchases of the Daily 1GB (D-1G…
Independent grading
98/100
Achieved 29 Oct 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