__STYLES__

National Rail - We All Slow Down. The TRAINS Don't.

Tools used in this project
National Rail - We All  Slow Down. The TRAINS Don't.

Tableau

About this project

Key Findings :-

Popular Routes -

  1. Total 4628 (14.62%) passengers travelled from Manchester Piccadily to Liverpool

Lime Street in last 4 months which is highest in all the routes.

  1. Total 30,535 passengers travelled during the entire time duration.

  2. Total 1118 passengers cancelled the ticket.

Journey Details -

  1. Total 304 passengers travelled on 19/04/2024 which is highest.

  2. On 2/02/2024 total 504 passengers travelled & total revenue generated on that day is GBP 10,569 which is highest.

  3. 18:45 Hrs is the peak travel time.

Revenue & Other Details -

    1. Max. tickets payment was done by Credit Card that is 61.35% (18733) & revenue generated is of GBP 4,60,480 (65.48%).
  1. Max. tickets are purchased by Online Method i.e. 58.51% (18,521) & revenue generated is of GBP 3,82,754 (51.59%).

  2. Max. passengers doesn't use Railcard i.e. 20918 (66.09%) & revenue generated from there is GBP 5,73,697 (77.33%).

  3. Only 15.31% (4846) passengers are Adult which use Railcard, 9.76% (3089) passengers are Disabled & 8.85% (2800) passengers are Senior Citizen which use Railcard & revenue generated from all of that was GBP 86,330 (11.64%) from Adult passengers, GBP 52278 (7.05%) from Disabled passengers & GBP 29616 (8.85%) from Senior Citizen.

  4. Only 3.53% (1118) passengers raised refund request & refund amount was GBP 38,702.

  5. Total Revenue generated was GBP 7,03,219 from 30535 passengers.

  6. Cancelled ticket price was GBP 38,702.

Delay Reasons -

  1. 23.85% (995) reported that Train is delayed by Weather conditions, 23.25% (970) reported that Train is delayed by Signal Failure, 12.54% (523) reported Train is delayed by Technical issues, 9.83% (410) reported Train is delayed by Staffing.

  2. 90.34% (28,595) passengers travelled by Standard Class, average price of Standard Class ticket was GBP 20.72 & Revenue generated was GBP 5,92,522 (79.80%).

  3. 9.66% (3058) passengers travelled by First Class, average price of First class ticket was GBP 48.86 & Revenue generated was GBP 1,49,399 (20.14%).

Travel & Delay Time -

  1. The max. Avg Price of ticket was GBP 114 & that is from Manchester Piccadilly to London Paddington.

  2. The min. Avg Price of ticket was GBP 2 & that is from Birmingham New Station to Wolverhampton.

  3. The max. travel time is 3812 Hrs which is from London St Pancras to Birmingham New Street.

  4. Max. Delay time is of 475.52 Hrs which is from Liverpool Lime Street to London Euston.

Discussion and feedback(2 comments)
comment-1317-avatar
Samuel Nwanne
Samuel Nwanne
4 months ago
Why are your projects not getting any likes
2000 characters remaining
Cookie SettingsWe use cookies to enhance your experience, analyze site traffic and deliver personalized content. Read our Privacy Policy.