Transit Data Integration

A municipal transit authority operated buses, light rail, and paratransit services across a major metropolitan area, each with separate operations and data systems. Passengers lacked reliable real-time arrival information, and operations teams could not optimize service across modes. The authority partnered with Vitosha to build a unified data platform on Microsoft Fabric, integrating IoT data from vehicles, schedule data, and incident reports into a single real-time analytics and visualization system.

The transit authority managed three separate operations teams (bus, light rail, paratransit), each using different CAD/AVL systems, scheduling platforms, and incident tracking tools. Real-time vehicle location data was available but not integrated, so passengers received unreliable arrival predictions that eroded trust in public transit. Operations analysts spent 30% of their time manually merging data from different systems to produce daily performance reports. The authority lacked a unified view of on-time performance, ridership trends, or service disruptions across modes, making it difficult to optimize schedules and respond to incidents.

Phase 1: IoT Data Ingestion — Deployed IoT sensors and Azure IoT Edge on the vehicle fleet, ingesting real-time GPS, engine diagnostics, and passenger count data into Azure Stream Analytics for low-latency processing and Microsoft Fabric for long-term storage and analytics. Phase 2: Unified Analytics Platform — Built a Microsoft Fabric lakehouse integrating CAD/AVL data, schedule data, ridership counts, incident reports, and weather data, creating a single operations data foundation with Purview governance. Phase 3: Real-Time Dashboards and Passenger Apps — Developed Power BI dashboards for operations teams (on-time performance, headway gaps, incident response) and real-time APIs to feed accurate arrival predictions and service alerts to the passenger mobile app and digital signage.

Passengers received real-time arrival predictions with 95% accuracy (up from 68%), and on-time performance improved by 25% as operations teams used real-time dashboards to proactively manage headways and deploy backup vehicles. Data processing speed increased 3x, with operational reports that previously took 4 hours to compile now available in real time. Ridership increased 8% in the first year, partially attributed to improved reliability and real-time information. The unified platform also reduced operational reporting effort by 20 hours per week.

The unified data platform transformed transit operations, delivering accurate real-time information to passengers and empowering operations teams with integrated analytics. The solution demonstrated how IoT and cloud analytics can modernize public transportation infrastructure.