Will your train be late?

FlavioMeneses — Tue, 05 Jul 2022 08:21:07 GMT

We can’t predict the future but we can look back at historical data to spot trends and inform our decisions – in this case, what train should I board to avoid being late!

This #PowerBI report uses official data from the National Rail Enquiries – the same data used in departure boards at UK train stations or phone apps.

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/posts/flaviomeneses_powerbi-activity-6949993005198041088-r3qw?utm_source=linkedin_share&utm_medium=member_desktop_webhttps://lnkd.in/gapKgvEn

More reports and Power BI content on LinkedIn:

https://www.linkedin.com/in/flaviomeneses/

eyJrIjoiMmFlYzVjY2YtMTViYS00ZmU1LTlhNDQtNmE3ZDQxYjc4YTQwIiwidCI6ImIwYjJkNGZlLWY4MmEtNGFkMS1iY2E3LWFjOWQzYzlkM2RlNiJ9

Re: Will your train be late?

Lyubov6932 — Sat, 09 Jul 2022 20:39:37 GMT

An interesting topic relevant to me. Good job

Re: Will your train be late?

FlavioMeneses — Sun, 10 Jul 2022 09:09:13 GMT

Thanks Lyubov6932, hope it helps if you work/are interested in this field!

topic Re: Will your train be late? in Data Stories Gallery

Will your train be late?

Re: Will your train be late?

Re: Will your train be late?