National Rail UK Exploratory Dashboard [Challenge Winner]

This report provides a comprehensive analysis on National Railway UK performance focusing on Passenger Rail Usage, Sales Performance, Railway Performance and Route analysis from January to April 2024. Key metrics are visualized through various metrics, including journey trends, peak hours, revenue trends, refund analysis, delayed reasons analysis, cancelation and delayed services analysis.

The key findings are as follows

1. From January to April 2024, there were 31,653 journeys with 1,880 cancellations. January had the highest journeys of 7,636 and February had the lowest 7,212 resulting in a -4.36% decrease overall.
2. The busiest travel periods are from 6 AM to 9 AM and 4 PM to 7 PM. The peak time slot is 6.30 AM and 6.45 PM, with the highest activity recorded at 1,337 and 2,300 journeys respectively.
3. 2/3 of passengers do not use a rail card. Among rail card holders, the Adult rail card type is the most popular, accounting for 16% of total passengers.
4. Standard class tickets make up 90% of sales, with Advance tickets being the most common type within this class.
5. Net revenue peaked at £188K in January, dropped by 20% to £151K in February, and recovered to £185K in March. The overall net revenue for the period is £703K and total refunds accounted to £39K.
6. On-time journeys contribute 81% of the net revenue totaling to £570K, while delayed and cancelled journeys contribute £101K and £33K, respectively.    
7. Revenue from the sale of Advance tickets increased significantly in February by 40%, but overall monthly net revenue decreased by 20%. Advance ticket revenue is £294K, Anytime £200K, and Off-Peak £209K.
8. Shorter delays result in higher refund percentages, with delays <=1 minute having a 76% refund rate. Longer delays (>60 minutes) have significantly lower impacts, with 0% refunds.
9. Out of 19,871 planned services, 18,019 were on-time, 1,062 were delayed and 790 were cancelled. The overall cancellation score is 4%.
10. The primary reasons for cancellations are signal failures , staffing issues and weather-related disruptions. These factors significantly impact service reliability and passenger satisfaction
11. Weather-related delays were the most common but had a 0% refund rate. Technical issues caused 268 delays with the highest refund rate of 67%, while traffic delays had the fewest occurrences delays of 52 but a significant refund rate of 54%.
12. Most delays fell within the 30-60 minute range, with the highest passenger delay minutes of 46,396 and a lower refund rate of 11%. Shorter delays (<=1 minute) had the highest refund rate of 64%, while delays over 60 minutes received no refunds.

Refunds were also provided for train services with 0 min delay, therefore, to address these issues, a revised refund policy is recommended:

• No refunds for delays less than 15 minutes.
• 25% refund for delays between 15-30 minutes.
• 50% refund for delays between 30-60 minutes.
• 100% refund for delays over 60 minutes.