Verified by DataSimHQ

Analyst

Ahmed Oyelowo

Senior Analyst

Project

Float map

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