UK Training General Trip Analysis

Analyzed UK railway trip data using SQL to uncover trends in transactions, revenue, delays, payments, and ticket usage. Key insights included:

Top departure/arrival stations and busiest travel days.

Delay patterns by station, route, ticket type, and time of day.

Payment method trends, refund rates, and revenue by ticket class.

Seasonality, booking behavior, and monthly revenue trends.

Tools: SQL (queries, joins, aggregations, window functions), Excel (visualization).