Calculating route and section train speed

Analytics and delivery of work on calculating route speed across divisions and section speed, accounting for stop time at intermediate stations.

Discuss a similar project → ← All case studies

2 metricsroute and section speed

Backendscoping the calculations

Frontendscoping the forms

JSC "NIIAS" / Russian Railways · project context

Train formationDivisionsIntermediate stationsBreakup

Route speedAverage train speed from formation to breakup.

Section speedAverage speed along the section, accounting for stop time at intermediate stations.

Rail datainfographic, not a product interface

Calculation context

Two speed metrics with different logic

Route speed is calculated from train formation to its breakup. Section speed accounts for the train's time on the section, including stops at intermediate stations, acceleration, deceleration and delays between stations.

Route speed

Calculated across divisions, from train formation to breakup.

Section speed

Average speed on the section, calculated accounting for stop time at intermediate stations.

Data

Analysis of database tables for scoping the calculations.

What we did

Four blocks of analytical and technical work

Route speed, backend

Scoping the backend task for calculating route speed across divisions, and analyzing database tables.

Route speed, frontend

Scoping the frontend task for building the corresponding forms.

Section speed, backend

Scoping the task for calculating section speed and analyzing database tables.

Section speed, frontend

Scoping the frontend task for building the corresponding forms.

Infographic

Workflow logic: from database tables to analysis forms

The diagram below visualizes only the elements of the work explicitly stated in the project document. This is not a reconstruction of the interface.

01 · dataDatabase table analysis

02 · backendSpeed-calculation logic

03 · frontendAnalysis forms

04 · metricsRoute and section speed

Section speed

Σ (number of trains × section length, km) / Σ train time on the section, h

Outcome

Calculations worked out at the data, backend and frontend level

The work included analyzing database tables and formulating backend calculation and frontend form tasks for route and section speed.

Database

Data analysis

Analysis of database tables for the metric-calculation tasks.

Backend

Scoping calculation tasks

Calculating route speed across divisions and calculating section speed.

Frontend

Scoping form tasks

Building the corresponding forms for analyzing both metrics.

Route and section speed in one analytical task

The work connected data analysis, backend calculation logic and frontend forms for two railway speed metrics.

Discuss a project → View other case studies