We Unified fragmented data in Qlik Sense for live insight into delays, passenger flows and ticket revenues.
A regional passenger rail operator in central Sweden, where punctuality, passenger comfort, and infrastructure reliability are key to success, needed better insights into how services were used and how performance could be improved. A modern BI solution was developed in Qlik Sense, supported by automated ETL pipelines.
The train operator needed deeper, actionable insights into:
Train punctuality and delay causes – pinpointing where improvements were needed
Passenger behavior – identifying where travelers boarded, train occupancy levels, and station usage patterns
Sales performance – tracking ticket revenues, passenger volumes, and travel patterns
Maintenance optimization – focusing maintenance efforts where passenger usage and train wear was highest
Data was fragmented across different systems, making it difficult to get a comprehensive view or act on insights.
A fully automated analytics environment was built using Qlik Sense, supported by ETL pipelines created with PowerShell scripts and REST APIs to integrate multiple data sources. The solution included:
Punctuality dashboards – detailed analysis of delays and operational performance
Passenger flow analytics – identifying boarding patterns, train usage, and occupancy
Station-level insights – pinpointing exactly which stations and platforms passengers used most
Sales analytics – breaking down revenue by ticket type and passenger category (adult, child, senior, etc.)
Maintenance analytics – data-driven identification of areas needing proactive maintenance
The organization gained immediate business value through:
Enhanced passenger insights – better understanding of how, when, and where passengers use services
Targeted maintenance planning – optimized allocation of maintenance resources based on real passenger traffic
Improved punctuality and reliability – with clearer data on delays, causes, and areas for improvement
Stronger sales analysis – tracking revenue streams and forecasting passenger demand with greater accuracy
The solution delivered clear, actionable insights, allowing the rail operator to proactively manage operations and offer passengers a smoother, more reliable travel experience.