Case Study

The Data Express: How Hopton accelerated RTS data journey with Power BI

Details

Company Name: RTS Infrastructure
Date: July 2023
Website: www.rtsinfrastructure.com

RTS Infrastructure provides rail depot services to major UK rail companies, with flexible and innovative solutions for train presentation, maintenance, and overhaul.

About RTS Infrastructure

RTS Infrastructure is a leading provider of rail depot services in the UK, offering flexible and innovative solutions for train presentation, maintenance, and overhaul. They work with major rail companies and have over 20 years of experience in the industry.

RTS Infrastructure has a team of skilled and qualified staff, who operate across the UK with depots in London, Manchester, Birmingham, Glasgow, and Edinburgh. They are committed to excellence, innovation, and customer satisfaction, and aim to provide cost-effective and reliable rail depot services.

RTS Infrastructure

“Working with the team at Hopton was an absolute pleasure. Their expertise in Power BI and their ability to translate our business concept into a reliable report have been invaluable. Moreover, their responsiveness throughout the project and beyond has been fantastic. I know we can count on Hopton!”

Chris Reid

Managing Director, RTS Infrastructure Services Ltd

The Challenge

RTS Infrastructure is a leading provider of rail depot services in the UK, working with major TOC/FOC/ROSCO and plant operating companies. They offer flexible and innovative solutions for train presentation, maintenance, and overhaul.

As a growing and dynamic business, RTS Infrastructure needed a way to access and analyse their data from various sources, such as Power Apps, Excel and from their other financial systems. They wanted to have a comprehensive and near-real-time view of their performance, operations, and finances across different departments and projects. They also wanted to empower their staff with self-service analytics and reporting capabilities, so they could make faster and smarter decisions.

Achieving their data goals was not easy for them, as they faced several challenges along the way. Their data was scattered across different systems and formats, creating data silos and inconsistencies that made it hard to integrate and reconcile. They relied on manual data extraction and manipulation, which was prone to errors and delays. They had limited options to explore and present their data in a meaningful and engaging way and lacked insights and visualisation.

The Approach

RTS Infrastructure engaged Hopton Analytics to help transform their data into actionable insights. Hopton Analytics is a Microsoft partner specialising in data, business intelligence (BI), and the Microsoft Power Platform. 

Using Power BI Dataflows and Power Query, Hopton connected and transformed data from various sources, creating a semantic model that unified and standardised RTS’s data. They added business logic and calculations to enrich the model and improve insights for all business users.

They used Power BI Desktop and Power BI Service to create interactive and customised reports and dashboards, that displayed the data in various visualisation types, such as charts, tables, maps, and KPIs. They also enabled data exploration and discovery with features such as drill-through, bookmarks, and Q&A.

The data was to be delivered through a series of reports and dashboards accessible on any device and platform with Power BI Mobile and Power BI, plus via SharePoint in Microsoft 365.

The Results

Hopton Analytics quickly delivered the Power BI solution to RTS Infrastructure, using their agile and flexible approach. They also ensured the solution was adopted and maintained by the users, by providing ongoing support and training.

The Power BI solution enabled RTS Infrastructure to make data-driven decisions and improve business performance. They were very happy with the solution and the service from Hopton Analytics, and the partnership between RTS and Hopton continues.