UK National Rain - Sales and Performance

Sales & Revenue

1. With 5.94% of trips canceled, only 1.81% requested a refund for cancellation and 1.72% for delay.
2. There's a 31.8% decline in net revenue from Jan to Feb, followed by a 20% increase in March and a 5.6% increase in April.
3. Total ticket sales decreased by 23.9% from Jan to Feb, then increased by 8.6% in March and 2.6% in April.
4. There's a 31.8% decline in net revenue from Jan to Feb, and a +20% in Mar and +5.6% in Apr.
5. Ticket sales decreased by 23.9% from Jan to Feb, +8.6% in Mar, and +2.6% in Apr.
6. Route Manchester Piccadilly - London Euston has the highest Refund Request (27.83%).
7. Liverpool Lime Street - London Euston has paid the highest Refund Amount (13k).
8. Standard class tickets account for 88.4% of the total net revenue, while First Class tickets contribute 11.6%. Among ticket types, Advance tickets generate the highest revenue at 41.6%, followed by Off-Peak at 30.1%, and Anytime at 28.3%.
9. +67% refund made on delays than cancellations
10. Credit card (63.2%) is the most preferred method of payment followed by Contactless (29.58%)
11. Almost Equal usage of online/offline purchase methods.

Routes & Performance

1. The majority of trips (65.99%) are made by those with no card, followed by 15.53% using a Disabled railcard, and 9.74% each for Adult and Senior railcards.
2. Weather condition is the most common (40.45%) reason for the delay, followed by Technical issues (20.59%) and Signal failure (19.68%). Signal Failure and Staffing resulted in the highest average delay of > 50 minutes.
3. Peak hours 6-8 am and 4-6 pm contribute to 51% of overall passenger traffic.
4. London is the primary railway hub with the highest passenger traffic, while cities like Liverpool, Leicester, Reading, and Bristol are also significant hubs. The thickness of the lines indicates passenger flow, with the heaviest traffic between London and other major cities. The map highlights extensive connectivity in southern England, with lesser connectivity in the northern regions.