unthinkable
Case study · An ICT and fintech provider, Kenya · county revenue and prepaid utility systems

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.

Kenya

What changed

45high-level KPIs (as reported)
30%of manual analysis removed by automated reports (as reported)
66%less data processing effort (as reported)
What stood in the way

What stood in the way.

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.
What changed
  • 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

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 it shows

What this work shows about us.

We know public revenue flows

Permits, passes and cess are collected by people in wards and zones; the reports follow that same structure, from ward to governor.

Forecasts without a history

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

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.

The money

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.

Questions & disputes

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.

Ask Unthinkable

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

Required

Thanks. A senior AI engineer will reply to you.
u
Ask UnthinkableClarity first, then the right team
Your conversation

An AI agent. This prototype uses prepared answers and sends nothing.