Verified by DataSimHQ

Analyst

Project

The bridge

Kilele Mobile · SQL · Advanced

The brief

From: Wanjiru Kamau, Chief Commercial Officer

Board pack time. Five findings from six weeks and I want them in one table I can paste into the pack with the numbers recomputed from source, not copied from old emails.

From the kilele database, one result set, five rows: 1. Active base: reported, corrected (promo credits excluded), difference. 2. Usiku: adopters' average monthly revenue before and after, and the difference. 3. Coast payday withdrawals: failure rate at the Coast against the rest, and KES not served on Coast payday days. 4. Kisumu: share of sites above 95 percent in 2026 H1 for Kisumu town against the rest, and silent churn for both. 5. Rudi Nyumbani: reported conversion, holdout conversion, lift.

Columns: finding, reported figure, corrected or comparison figure, difference,…

Independent grading

74/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