Analyst
Lead Analyst
Project
Kilele Mobile · SQL · Intermediate
The brief
From: Amina Hassan, Head of KilelePay
Grace is getting calls from Coast agents who say customers cannot withdraw at month end, and the agents are being told it is their fault. I do not believe our Coast agents are worse people than our Nairobi agents. I want the cause, in numbers, before the next agent forum in Mombasa.
From the kilele database, as of 2026-06-30: 1. Withdrawal failure rate for insufficient_agent_float, by region, split by payday window (dim_date.is_payday_window) and other days. 2. Every withdrawal failure reason, counted, so we know the float problem's size against the others. 3. Agent float limits by region and agent type: minimum, average, maximum. 4. For Coast agents who are not dealers: average closing float and average stockout minutes on payday days against other…
Independent grading
97/100
Achieved 12 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