All case studies

Data & Business Intelligence

πŸ‡°πŸ‡ͺ Kenya

Logistics Operations Dashboard

Unified GPS tracking, fuel logs, and driver performance data into a Metabase dashboard that surfaced route inefficiencies the team could not see in spreadsheets.

Client: A Kenyan logistics and fleet operator

KES 2.4Mmonthly cost savings identified

The challenge

Where things stood

Fleet data was scattered across a GPS tracking tool, fuel card statements, and manually logged driver trip sheets. No one had a single view of cost per route, and fuel losses were only noticed weeks after they happened.

The approach

What we did

  • Audited every data source and cleaned up inconsistent trip and fuel records
  • Built an ETL pipeline pulling GPS, fuel card, and trip sheet data into one warehouse
  • Built a Metabase dashboard showing cost per route, fuel variance, and driver performance in real time
  • Set up automated weekly reports emailed to the operations manager
  • Trained the ops team to build their own ad-hoc reports without needing a developer

The outcome

What changed

  • Identified KES 2.4M per month in avoidable fuel and route costs
  • Route planning decisions that used to take a week now take an afternoon
  • Fuel variance flagged within a day instead of being discovered at month-end

Tech stack

MetabasePostgreSQL

More proof

Other results

AI AutomationπŸ‡°πŸ‡ͺ Kenya

87%

reduction in processing time

Replaced a 5-day manual loan approval workflow with an AI pipeline that reviews applications, checks credit history, and routes decisions in under 4 hours.

Read the full story
Web Development🌍 International

3.2Γ—

increase in order volume

Built a Next.js + Supabase wholesale ordering platform with live inventory, tiered pricing, and automated invoicing for a UK-based importer.

Read the full story
AI AgentsπŸ‡°πŸ‡ͺ Kenya

68%

of tickets resolved without a human

Deployed a WhatsApp AI agent that handles order status, returns, and product questions instantly, escalating only the conversations that genuinely need a person.

Read the full story

Ready to see what’s possible?

A 20-minute intro call is free. A 90-minute Paid Discovery Session is $500 / KESΒ 25,000 β€” and ends with a clear, actionable roadmap for transforming how your business operates.

hello@biran.co.ke Β· WhatsApp: +2547142987206