Analyst
Senior Analyst
Project
Kilele Mobile · Power BI · Intermediate
The brief
From: Amina Hassan, Head of KilelePay
I am presenting the Coast withdrawal problem to the agent network team and I want one Power BI page that leaves no room for the usual arguments.
Build from the kilele database: 1. A matrix: region by payday window, value is the share of withdrawals that failed for insufficient_agent_float, with colour scaling. 2. A bar chart of average float limit for sub-agents by region. 3. A line chart of Coast withdrawals and Coast float failures by month. 4. Two cards: KES not served on Coast payday days, and withdrawal fees forgone on those days. 5. A visual of average stockout minutes on payday days: Coast sub-agents and kiosks against everyone else. 6. A text box with the cause in one sentence and the proposed fix in one sentence.
Mark dim_date as your date…
Independent grading
90/100
Achieved 5 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