UK Rail Analysis

About this project

This project is about the UK Rail Survey giving the data of about First 4 months of 2024 January to April to analyze the Train Performances and Revenue Generated till date depending upon the different factors like Ticket Class and Ticket types. The dataset Includes 18 fields and 31654 records.

Objectives:

Identify the most popular routes
determine peak travel times
analyze revenue from different ticket types and classes
Diagnose on-time performance and contributing factors

Key Insights and Metrices:

Trips by Departure Time
Trips by Arrival Time
Total Revenue Generated
Revenue generated by Popular Trips
Top 5 Popular Routes
Trips Overview using cards( Total Trips, Successful , Delayed , Cancelled and On Time Trips)
Revenue Earned by On Time trains
Revenue Lost by Delayed and Cancelled Train Trips
Reasons for Delays and Cancelled trips
Ticket Purchase Type
Trips Percentage Analysis
Revenue by Payment Methods

Lets dive deep in the analysis to generate useful insights

1: Identify Popular Routes:

This bar chart is depicting the Top 5 Routes of the UK Railway, that Manchester Piccadilly to Liverpool Lime Street is the most travelled route with 4.3K trips followed by London Euston to Birmingham New Street with 4.0K trips. After that London Kings Cross to York route with 3.7K trips then London Paddington to Reading holding 3.6K trips and last in the top 5 list London St Pancras to Birmingham New Street with the 3.2K trips.

This graph shows the top 5 routes with most generated Revenue. Despite of the fact London Kings Cross to York route generates the most revenue of £179K but has a moderate number of trips (3.7K trips) compared to London Euston to Manchester Piccadilly (which has 4.0K trips) but revenue of £59K.Overall it can clearly be seen that the route London Kings Cross to York is the most profitable route by contributing the most in the revenue followed by Liverpool Lime Street to London Euston which generated £100K. While London Paddington to Reading which generated £64K revenue by carrying 3.9K trips till date .After that London Euston to Manchester Piccadilly which generated £59K of the revenue. Last in the list is London St Pancras to Birmingham New Street holding least 3.2K trips with least revenue of £52K.

Analysis:

These analysis helps in making data-driven decisions to enhance revenue, improve service quality, and strategically plan for future growth by understanding which routes are most profitable and most traveled.

2: Determine peak travel times :

These Column charts helps to identify the peak hours by the number of trips made. By analyzing the Trips by Departure Time it can be seen that at 6AM,7AM,8AM,4PM, 5PM 6PM and 8PM , the number of trips are made 2923, 2540,2031,2197,2704,2802 and 1022.

For chart Trips by Arrival Time , at 7AM,8AM,9AM,5PM,6PM &7PM with number of trips 2035, 2077,2587,2103,1439,3192 respectively.

To summarize the information it can be conclude that the

Peak hours for departures:

6AM-8AM (7.5K) in Morning

5PM-7PM (6.5K) in Evening

Peak hours for Arrivals:

7AM-9AM (6.7K) in Morning

5 PM- 7PM (6.7K) in Evening

Analysis:

These peak hours indicating the busiest times of the day which can be linked to the fact that people are going to work. Varying closing hours of most workplace reflects on the other time of the day. This information is crucial for planning and resource allocation such as staffing and train availability to manage the high volume of trips effectively.

3:Analyze Revenue from different Ticket Types and Classes:

Revenue plays a vital role in any type of business , even it is individual or in large scale.

The total revenue generated is £703K but there where many factors contributing in the revenue like Ticket Class and Types. To visualize this decomposition tree is being the best one which shows the best hierarchy of the revenue generated by Ticket class and Ticket Types

This decomposition tree gives the information about the Total Revenue generated and its division by ticket class and ticket types , Standard class contributes the most in generating the revenue around £560K is being generated by Standard Class and in Standard class Advance Ticket type is the most used Ticket type generating £229K followed by Anytime and Off-Peak. This highlights the popularity and financial impact of Advance tickets within the Standard class, indicating a preference for cost-effective travel options among passengers.

3.1: Revenue by Payment Method:

This donut chart depicts the percentage of Revenue brings out by Payment Method

The most revenue rises due to Payment made by Credit Card i.e 65.48% (£460K)
Second in the circle is Payment made by Contacles i.e 30.5% (£214K)
Least payment method used is Debit Card which contributes the least with .4.01% (£28K).

3.2: Revenue Analysis by Journey Statuses:

As given the major of the revenue is rises up because of the On Time trips £428K and , due to Cancelled and Delayed , it also lost the most of the Revenue as £35K and £97K respectively.

4: Analyzing On-Time Performance****

4.a: Journey Status/ Trips Status :

Around 27,481 trips, representing 86.82% of successful journeys (and 86% of all bookings), were on time. In contrast, only a small number of trips experienced disruptions, with 2,274 trips delayed and 1,880 trips cancelled. In summary Total Trips made are 31653 out of which 29755 were successful.

This high on-time performance rate highlights the overall reliability of the railway service, despite the challenges faced.

4.b: Reasons of Delays and Cancelling :

Most of the Trips which were Delayed are due to the Weather Conditions, 927 out of 2274

A total of 1,880 trips were cancelled, with ‘Signal Failure’ cited as the top reason (519 trips cancelled due to Signal Failure).

Recommendations :

Resource Allocations:

Allocate more resources (e.g., better trains, more frequent services) to high-revenue routes to maximize profitability. For routes with high passenger numbers, ensure sufficient capacity and service frequency to maintain customer satisfaction and avoid overcrowding.

Improve Reliability:

Focus on reducing delays and cancellations by addressing key issues like weather, signal failures, and technical problems. Enhance operational procedures and provide robust training programs for staff to handle disruptions more effectively.

Customer Service:

Enhance the online ticket purchasing experience with a user-friendly interface and secure payment options. Also improve station services to reduce wait times and encourage people to buy tickets in person.

Peak Hours Performance:

Increase train capacity and staff during peak hours (7-9 AM, 5-7 PM) to handle high demand. Offer discounts to encourage off-peak travel. Adjust schedules and maintenance to minimize disruptions and improve efficiency.