UK National Rail Analysis 2024

The "UK Train Rides Report" project aimed to provide a detailed and actionable analysis of railway operations in the UK, using data provided by Maven Analytics for a dashboard competition. Our primary goals were to enhance operational efficiency, reduce train delays, and optimize passenger satisfaction by leveraging data-driven insights.

Goals and Business Needs

1. Sales Performance Overview: Examine sales data to identify trends, patterns, and performance metrics.
2. Train Delay Analysis: Analyze train delays to identify root causes and areas for improvement.
3. Train Operations & Passenger Flow: Optimize schedules and operations to improve efficiency and passenger experience.

Approach and Insights

We conducted a monthly analysis with bookmarks to isolate the visualizations for focused insights. From the purchase, journey, and arrival dates, we extracted detailed date breakdowns and created a new exploration by 1-hour ranges. This allowed for both individual month-by-month analysis and a comprehensive overview. Our slicers included a bar slicer for easy navigation through the desired analysis period range.

We also focused on showcasing month-over-month variations to analyze behaviors and trends continuously. A flow map was incorporated to identify routes and destinations, providing a clear visualization of the most traveled paths and areas needing attention.

The combination of these analytical techniques enabled us to discover and present meaningful insights, which are crucial for making informed decisions to enhance the UK's railway network.

Summary

This detailed report provides a comprehensive analysis of train rides in the UK, focusing on sales performance, delay patterns, and operational efficiency. Our innovative approach using bookmarks, detailed date breakdowns, and month-over-month analysis offers valuable insights to optimize train operations and enhance passenger satisfaction.