National Rail Train Analysis

The dashboard provides a comprehensive analysis of the National Rail services in the UK for the period January to April 2024. This project, conducted as part of the Maven Rail Challenge, leverages Power BI to visualize key performance metrics and trends in railway operations.

Key Metrics and Insights

1. Journey Status
   • On Time: 27.5K journeys
   • Delayed: 2.3K journeys
   • Cancelled: 1.9K journeys
2. Railcard Usage
   • None: 66.1%
   • Adult: 15.3%
   • Disabled: 9.8%
   • Senior: 8.8%
3. Revenue by Ticket Type
   • Advance: £309K
   • Off-Peak: £223K
   • Anytime: £209K
4. Revenue by Month
   • January: £205K
   • February: £154K
   • March: £195K
   • April: £187K
5. Reasons for Delay
   • Weather: 758 incidents
   • Signal Failure: 451 incidents
   • Technical Issue: 472 incidents
6. Payment Method by Ticket Class
   • First Class: Predominantly credit card (6%)
   • Standard Class: Mostly debit card (55%)
7. Ticket Purchase Trends
   • Peak Hours: 7-9 AM and 5-7 PM
   • Days: Consistent purchase behavior throughout the week with slight variations
8. Revenue by Ticket Class
   • Standard: £592,522 (90.34%)
   • First Class: £149,399 (9.66%)
9. Popular Routes and Metrics
   • Manchester Piccadilly to Liverpool Lime Street: 4628 trips, £17,310 revenue
   • London Euston to Birmingham New Street: 4209 trips, £50,349 revenue
   • London Kings Cross to York: 3922 trips, £183,193 revenue

The dashboard successfully highlights operational performance, passenger preferences, and financial metrics. The insights can be used to improve service reliability, optimize ticket pricing, and enhance customer satisfaction.