Selected work

Data & analytics

Public Transport Analytics — Iași

Turning fleet telemetry into operating decisions.

A live analytics dashboard for the public-transport fleet of Iași, Romania, built on Metabase over GPS and telemetry data. It reports on 238 vehicles across buses and trams — tracking speed, safety, accessibility, and congestion in one place. It shows how raw fleet telemetry becomes operational views a transport authority can act on.

  • Telemetry data pipelines
  • Operational dashboarding
  • Fleet & mobility analytics
  • Data-to-decisions design
Public Transport Analytics — Iași — A Metabase dashboard that turns a city's public-transport telemetry into operating decisions
Live vehicle-location map across the city fleet

The context

Public-transport operators sit on continuous GPS and telemetry streams but rarely turn them into daily operating decisions. The challenge is converting raw location and speed data into views that inform efficiency, safety, and compliance.

What we delivered

  • A live vehicle-location map covering the city fleet
  • Fleet-composition analysis across 238 vehicles (63% buses, 37% trams / light metro)
  • Mobility-efficiency metrics: average speed by time of day and by category (buses 27.35 km/h, trams 17.52 km/h), plus a speed-distribution histogram
  • Accessibility indices for wheelchair-accessible (71.85%) and bicycle-accessible (10.08%) vehicles
  • A congestion-point map and a recorded-speeding table of 58 events, flagging outliers up to 141 km/h as more than 50 km/h over the limit

Why it matters

  • Converts raw telemetry into decisions across efficiency, safety, accessibility, and congestion
  • Gives operations and public-sector teams a single, factual view for compliance and safety oversight
  • Demonstrates a repeatable data-to-decisions pipeline that applies to any fleet or sensor stream

From the dashboard

Capabilities shown

  • Telemetry data pipelines
  • Operational dashboarding
  • Fleet & mobility analytics
  • Data-to-decisions design

Built with

  • Metabase
  • SQL
  • GPS / telemetry pipeline

Where is the value hiding in your business?

Let's have a direct, no-pressure conversation about where AI and technology could actually move your numbers.