National Rail BI Dashboard

🎯 My Mission: I was tasked with creating an exploratory dashboard to assist my manager in:

• 🌐 Identifying the most popular routes
• 🕒 Determining peak travel times
• 💰 Analyzing revenue from different ticket types & classes
• 🚉 Diagnosing on-time performance and contributing factors

📊 Dashboard Overview: I I developed a multi-page dashboard featuring comprehensive analyses:

Executive Summary

• Month-over-Month (MOM) for Number of Passengers, Revenue, On-Time Rate, and Cancellation Rate
• Top 7 Most Popular Routes with On-Time Rates
• Peak Time Analysis of Passenger Volume
• Revenue Contributions for Each Passenger Group

Route Analysis

• Daily Frequency
• Route Durations in Minutes
• Top 15 Routes with On-Time Rates

Performance Analysis

• Analysis of Delay Root Causes and Performance Impacts
• Total Passengers Affected by Each Cause
• Total Passengers Affected by Delay Duration

Revenue Analysis

• Weekly Revenue & Week-over-Week (WoW) Growth
• Ticket Type vs. Purchase Method Analysis
• Class and Railcard Revenue Distribution Analysis

📈 KPI: I applied specific KPIs with monthly targets:

• Number of Tickets Purchased: 8,000 tickets sold per month
• Revenue: $180,000 per month
• On-Time Rate: Achieving 85%
• Cancellation Rate: Below 7%