Project

Dashboarding & reporting

IndustryBIGeography

For ProRail, the rail network operator in the Netherlands, Lynxx develops a wide array of dashboards and reports. Lynxx works together with stakeholders throughout the ProRail organization to define KPI’s, transform data, and provide up-to-date and correct insights to both internal and external stakeholders. Over 2000 unique users view our dashboards each year.

For ProRail, the rail network operator in the Netherlands, Lynxx develops a wide array of dashboards and reports. Lynxx works together with stakeholders throughout the ProRail organization to define KPI’s, transform data, and provide up-to-date and correct insights to both internal and external stakeholders. Over 2000 unique users view our dashboards each year.
Project
Dashboarding and Reporting in QlikSense
Expertise
Industry, BI, Geography
Client
ProRail
Industry
Project type
Geography
Year
Website
https://prestaties.prorail.nl/

Challenge

As the government-owned company responsible for maintaining and improving the railroad network in the Netherlands, ProRail needed a modern business intelligence solution to unify their analytics and reporting. With over 4000 employees, and a budget of more than 1 billion euros, ProRail has a wealth of useful data spread throughout the organization.

There was a need for a central platform where up-to-date and correct data is presented from all corners of the organization, ranging from finance, rail operations, security, incident response, HR and asset management. Furthermore, this platform should be flexible enough to allow for rapid development to accommodate changes in the data and organization. The final challenge was to create user acceptance, and to center reporting and decision making processes around the platform.

Our solution

Lynxx developed a central QlikSense portal where users can navigate to a wide range of pages. In total, more than 600 dashboard well ordend pages currently run in production, accessible to all employees within the organization. Moreover, in order to communicate critical KPIs to the ministry of transport, as well as the public at large, Lynxx developed a webpage (https://prestaties.prorail.nl/) where up-to-date information is shown on punctuality, goods transport, outages and other KPIs.

In order to get the most out of the data, we sit down with the data owners, domain experts and end-users. Together we discuss the needs and possibilities available. Often data is not in a usable format, or the exact data needed is not available. Lynxx helps here by doing what we love: combining and transforming data sources, and discussing alternative definitions and solutions. 

Because we understand the business needs in addition to the data, we are able to come up with creative solutions that help the organization further, and wrangle every last drop of insight from the data. We use our expertise to make sure that the dashboards contain clean and insightful visualizations, and that they are molded to integrate seamlessly with end-users’ workflow, so that they can do their job faster and more efficiently.

Results

Lynxx developed in total more than 600 QlikSense dashboard pages across all facets of the ProRail organization. Yearly more than 2000 unique users (half of the ProRail organization) view our dashboards, and 100s of gigabytes from countless data sources are centralized and processed. Every month tens of automated reports are generated and sent to many layers in the organization, including the management team.

Unlocking the data is an important step for ProRail, as it allows it to pivot to a much more data-driven approach: ProRail now has a central platform where insights are available, which is also used in automated reports, saving ProRail time and money. The organization has confidence that up-to-date and correct information is available to base decisions on, and that can be used to communicate to external stakeholders such as the ministry of transportation and the wider public.

 

Travelers don’t have to use another platform or ticket machine to buy a ticket

Kim de Groot

Consultant
@ Lynxx
Nullam finibus in mauris eget malesuada. Pellentesque ipsum ante, elementum non dui sed, vehicula euismod ante. Proin efficitur diam dui, luctus congue mauris rutrum at. Etiam vel velit hendrerit, lobortis ligula vel, posuere magna. Sed aliquet convallis ipsum, nec molestie ante ultricies in. Aliquam eu odio egestas, pharetra ante at, pellentesque nulla. Fusce ac gravida ante, id volutpat neque. Nunc ut leo sed lectus ullamcorper convallis convallis vitae odio. Suspendisse potenti.
Travelers don’t have to use another platform or ticket machine to buy a ticket

Kim de Groot

Consultant
@ Lynxx
Nullam finibus in mauris eget malesuada. Pellentesque ipsum ante, elementum non dui sed, vehicula euismod ante. Proin efficitur diam dui, luctus congue mauris rutrum at. Etiam vel velit hendrerit, lobortis ligula vel, posuere magna. Sed aliquet convallis ipsum, nec molestie ante ultricies in. Aliquam eu odio egestas, pharetra ante at, pellentesque nulla. Fusce ac gravida ante, id volutpat neque. Nunc ut leo sed lectus ullamcorper convallis convallis vitae odio. Suspendisse potenti.