Back to Portfolio

Rail Transport Dashboard: Optimizing SwiftRail Operations

February 20, 20248 min read
Transportation
Share:
Rail Transport Dashboard

SwiftRail Transport Dashboard

Introduction

SwiftRail Transport, a major rail service provider, sought to optimize their operations through data-driven insights. This project involved analyzing their extensive operational data to identify patterns in passenger behavior, route performance, revenue generation, and delay factors.

Project Overview

The Rail Transport Dashboard project was developed as part of the Maven Analytics challenge. The goal was to create a comprehensive visualization tool that would help SwiftRail make informed decisions about resource allocation, scheduling, and service improvements.

Business Challenge

SwiftRail faced several operational challenges:

  • Identifying high-demand routes and peak travel times
  • Understanding factors contributing to delays
  • Optimizing ticket pricing and revenue generation
  • Improving resource allocation across their network
  • Enhancing overall passenger experience

Dataset Overview

The dataset included detailed information on train operations over a one-year period:

  • Route information (origin, destination, distance)
  • Schedule details (departure time, arrival time)
  • Passenger counts and demographics
  • Ticket sales and revenue
  • Delay information and causes
  • Train types and capacities
Sample of the dataset

Sample of the SwiftRail Transport dataset

Project Details

Category

Transportation

Date

February 20, 2024

Tools Used

Power BI
Excel
Maven Challenge

Key Metrics

Total Routes Analyzed

24

Highest Revenue Route

London-Manchester ($4.2M)

Average Delay Duration

18 minutes

Peak Passenger Load

Friday 5-7 PM

Feature Highlights

  • Interactive route performance map
  • Time-based passenger flow analysis
  • Delay cause breakdown visualization
  • Revenue optimization modeling
  • Passenger demographic insights