Kenyan county leaders see what each permit, pass and collector brings in, down to the ward, refreshed through the day.
The provider wanted county governments to see their revenue clearly, so they could plan and bring low-cost power and water to more villages and wards sooner.
What changed
What stood in the way.
- Revenue from business permits, vehicle and parking passes and cess had to be cleaned, combined and reported for government users.
- There was no historical data to base revenue forecasts on, and access had to be limited to a few authorised people without heavy admin.
- 45high-level KPIs (as reported)
- 30%of manual analysis removed by automated reports (as reported)
- 66%less data processing effort (as reported)
What we built.
- Cleaned and regularised data in Power BI, with dashboards comparing daily, monthly and quarterly figures and cohort views per revenue stream.
- Drill-down filters by county, sub-county, ward, zone and time, and rankings of the top revenue services, collectors and areas.
- Revenue and service forecasts from conservative and aggressive scenarios with upper and lower bounds, in place of missing history.
- Access by rank: full data for governors, deputy governors and senior finance officials, county views for others, set by a super admin.
- About 45 KPIs across 10-11 report pages, refreshed automatically every 2.5 hours.
- Microsoft Power BI
What this work shows about us.
Permits, passes and cess are collected by people in wards and zones; the reports follow that same structure, from ward to governor.
With no past data, scenario ranges gave leaders a usable forecast from day one.
Want similar revenue reporting in Power BI? Tell us what you want to change. Our AI assistant, Ask Unthinkable, helps you define your requirements, then connects you with the right team.
Start your plan ↗If we built it today, with AI.
This work came before today's AI. If the leading Kenyan ICT and fintech provider asked us now, this is what we would add, step by step.
An agent would spot a ward or collector whose takings fall below the forecast range and tell the county finance team, with the figures behind it. Officials still decide what to do.
An agent would answer an official's question, such as parking revenue in one sub-county last quarter, from the same reports and only within that person's access.
Where this work fits.
- LendersYour customers are meant to get the loan they need, without chasing anyone.
- Pramerica Life InsurancePramerica's customers' national ID numbers are masked in every stored document, ahead of the government's deadline.
Facts and figures from the project records; nothing added.
Want this for your business?
Tell us what you run or what you're building. Our AI assistant, Ask Unthinkable, helps you define your requirements, then connects you with a senior AI engineer.
Send us a note instead
An AI agent. This prototype uses prepared answers and sends nothing.
We use essential cookies to run this site. With your consent we also use analytics cookies to see which pages help. Privacy policy