Monitoring NMBS Train Delays


NMBS is offering Public Open Data APIs with real-time train delay information every 30 seconds. This data is available through an Open Source API.

NMBS is offering Public Open Data APIs with real-time train delay information every 30 seconds. This data is available through an Open Source API.

The Open Source API used in this set-up is iRail which offers the GTFS real-time feeds as offered by the NMBS for integrators building apps and mobility services.

In addition to NMBS Data, we also leverage Weather data from the Darsky API to in our demo correlate weather with train Delay.
Get in touch with us if you want to know more about these data sources.

This Power BI is supported by an end-to-end Modern Data Platform on Microsoft Azure enabling this demo.

This Power BI is supported by an end-to-end Modern Data Platform on Microsoft Azure enabling this demo. Every 5' we call the Open Source API - through an Azure Web App - and get the train delay data for every train in Belgium. We send this data to an Azure Event Hub from where data is sent to a Azure Data Lake and partitioned per day, hour and minute.

Once per day, an ETL process powered through Azure Data Factory takes the data from the Data Lake and integrates it into an Azure SQL Database where we model data with various dimensions and fact tables. On top of this SQL Database, we build this Power BI dashboard through which users can browse the delays in all detail.



Continue reading about the element61's Modern Data Platform approach.

This demo is a fully-operatonal working data platform running with Microsoft Azure and Power BI. We see 3 key learnings as very relevant to share with you

This demo is a fully-operatonal working data platform running with Microsoft Azure and Power BI. We see 3 key learnings as very relevant to share with you

  1. Power BI is great to embed: As you see in above embedded, it's easy and user-friendly to embed Power BI in your own website or Customer Portal.

    Embedding Power BI can simplify and boost the use of reports and data: e.g., operators can use Power BI from within the software they use day-to-day (e.g. Dynamics, CRM, etc.)
  2. APIs unlock new data easily: In this demo we use 2 Public APIs - Darksky and iRail - to unlock new data easily. APIs allows us to always get latest data, work event-driven and easily access external data.
  3. Agile to develop: The NMBS data demo platform is built using various Azure existing services jointly enabling this end-to-end working set-up. Without re-building from scratch, we can configure the various Azure building blocks and build this demo platform in less than 30 days


« Back to homepage