Power BI Report using HSP data

58 views
Skip to first unread message

Flávio Meneses

unread,
Jul 5, 2022, 4:15:22 AMJul 5
to A gathering place for the Open Rail Data community
I've created a Power BI report this community might find interesting. 

With this you can gauge the likelihood of your next train being on time. 

Due to data volumes, data from Jan'22 to Jun'22 was used to evaluate train performance (on-time arrival) in the UK's West Coast Mainline; this is limited to the main stations along the line, for a representative full week in each month, during peak hours (06:00-09:00 and 16:00-18:00).

For the data used, we can see that 50% of trains didn’t make it on time, so this report can actually be useful to pick a train with high likelihood of getting you from A to B without being late!

Data also shows that the North is more severely affected by delays – Warrington, Lancaster, Carlisle or Wigan will all, on average, see trains delayed more than 60% of the time for peak hours during the week.

Report link: https://www.linkedin.com/feed/update/urn:li:activity:6949993005198041088?utm_source=linkedin_share&utm_medium=member_desktop_webThumbnail.JPG

Video music by Benjamin Tissot at bensound.com

Reply all
Reply to author
Forward
0 new messages