GTFS-RT real-time analytics, ridership forecasting, maintenance intelligence, and revenue optimization for TransLink, BC Transit, and regional transportation authorities across British Columbia.
Live vehicle position feeds via GTFS-RT, on-time performance monitoring, incident detection, and operations room dashboards refreshing every 30 seconds.
30 and 90-day ridership forecasts by route and corridor using Prophet time-series ML — trained on historical ridership, special events, and seasonal patterns.
Compass card fare data integration, route-level revenue analysis, underpriced route identification, and missed revenue recovery opportunity modeling.
Preventive maintenance scheduling, fleet utilization analysis, breakdown pattern detection, and vehicle lifecycle cost modeling.
Transit data is inherently real-time and high-volume. Our architecture handles both: streaming pipelines for operations teams, and batch forecasting models for planning teams — all feeding a unified Power BI environment.
Azure Event Hubs ingesting GTFS-RT vehicle positions and service alerts. Azure Stream Analytics joining live feeds with scheduled timetable data in real time.
Azure ML for Prophet forecasting models. Python pipelines for Compass card revenue analysis. Delta Lake for efficient historical storage and time-series querying.
Power BI real-time streaming datasets for operations room screens. Planner dashboards for forecasting. Executive dashboards for KPI and financial reporting.
Whether you're on BC Transit, TransLink, or a regional authority — we know GTFS, we know Compass, and we know what transit operations teams actually need to see.