This dataset, provided by Maven Analytics for a Power BI dashboard contest on LinkedIn, showcases a comprehensive analysis of the U.K. railway system. The dashboard provides insights into railway volume, customer behavior, revenue trends, and route performance using visually striking and interactive visualizations.
Dashboard Overview:
The dashboard is divided into four pages, each offering a distinct perspective on railway operations. Key metrics include total tickets sold, canceled and delayed trains, and the total number of scheduled trains. The analysis incorporates customer segmentation based on purchasing types and methods, peak period and time slot trends, and detailed revenue and performance metrics. Easy navigation is facilitated by buttons located in the header, allowing seamless movement between pages.
Page 1: Route Volume Analysis
This page features an engaging and interactive network graph that maps the connections between railway stations, showcasing total scheduled trains, total tickets, total delayed, and total cancelled tickets. Allowing for deep insights on total network performance and targeting of problematic routes. A field parameter slicer allows users to filter the network graph by key measures such as total tickets sold, canceled routes, delayed routes, and total trains. The combination of dynamic filtering and the visual appeal of the network graph makes this page both insightful and enjoyable to explore.
Page 2: Passenger Segments & Peak Period Analysis
This page dives into passenger statistics, segmenting data by ticket type, purchase methods, and demographic categories such as adults, disabled passengers, and seniors. Key insights include:
Ticket Trends: Ticket purchases are analyzed by peak months, revealing seasonal trends, as well as detailed breakdowns of first-class vs. standard tickets.
Peak Period Analysis: A heatmap and bar chart detail peak travel periods by hour and day of the week, providing a clear understanding of passenger flow throughout the day.
Ticket Class and Purchase Periods: Pie charts and bar graphs highlight the split between standard and first-class tickets and analyze ticket purchases during peak, off-peak, and advance periods. This page provides a granular understanding of customer behavior and peak usage patterns.
Page 3: Revenue Analysis
This page provides a financial deep dive, focusing on revenue generation, refunds, and ticket pricing:
Net Revenue Trends: Revenue performance is tracked monthly, showcasing how revenue fluctuates across peak periods and how delays or cancellations impact financial outcomes.
Revenue vs. Refunds: Visuals compare the breakdown of revenue generated from on-time journeys with refunds due to delays or cancellations. This includes detailed refund categories by journey status.
Top and Bottom Routes for Revenue: Bar charts rank the top revenue-generating routes (e.g., London Kings Cross to York) and the least profitable routes, providing actionable insights for optimizing operations.
Revenue by Ticket Type and Purchase Channel: The dashboard separates revenue generated online vs. at stations and further categorizes by ticket class (standard vs. first class), highlighting key revenue drivers.
Page 4: Route Performance
This page examines the operational reliability of train routes, focusing on delays, cancellations, and their root causes:
Route Reliability: Monthly trends show the percentage of routes completed on time and overall reliability scores.
Cancellations by Cause: A breakdown of cancellations due to signal failures, staff shortages, technical issues, traffic, and weather conditions. Heatmaps highlight the impact of each cause on refunds and revenue loss.
Delay Analysis: A detailed table links delay durations to the number of affected passengers, the proportion of refunds, and financial impact. This analysis identifies where operational inefficiencies are most costly.
Proportion of Route Interruptions: A pie chart highlights the share of planned, delayed, and canceled routes, presenting an overview of service reliability.

Welcome to JGAnalytics, we offer services for hire for Data Analytics, Data Engineering, and Machine Learning.
Copyright © JGAnalytics 2024