Analyst
Lead Analyst
Project
Kilele Mobile · SQL · Advanced
The brief
From: Wanjiru Kamau, Chief Commercial Officer
Daniel's Rudi Nyumbani win-back has run twice and both times he reported 8.5 percent reactivation. He wants budget for a third wave. I asked what the holdout did and got a long pause. I am not against Daniel; I am against spending money on a number nobody has checked.
From the kilele database: 1. For every campaign in the campaigns table, the number of subscribers and the conversion rate in the target group and in the holdout group, with the lift (target minus holdout) in percentage points. 2. The two win-back waves (campaigns 4 and 5) against the Weekly 2GB Upsell (campaign 2), side by side. 3. For win-back converters, how many had any customer-money revenue event more than 30 days after converting. I want to know whether they came back or j…
Independent grading
97/100
Achieved 11 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