Delivering Translink’s Modern Data Platform
Translink is Northern Ireland’s public transport provider, and is responsible for over 81 million bus and rail passenger journeys each year.
Translink’s mission is to deliver transformation in public transport by providing integrated services which connect people, enhance the economy & improve the environment.
The transportation industry has experienced transformative change within the area of data in recent times, with the introduction of on-board sensors, data collection points, vehicle location, ticketing, fare collection, and scheduling management systems. Translink, with its vision ‘To be your first choice for travel in Northern Ireland’, wanted to gain maximum value from the huge amounts of data captured from these different sources.
Version 1 was engaged to find a way of quickly transforming raw data into information that would be useful to Translink staff and customers.
Delivering a Data Solution
Version 1’s Data and Analytics team worked quickly and collaboratively with Translink to deliver a solution to help Translink achieve their business goals, developing a centralised data repository using Microsoft’s technology stack.
The solution, completed within 10 weeks, gave Translink a single source of truth in the form of a Data Warehouse. This allows reporting to be removed from Translink’s line of business systems; a future-proof, robust, and scalable on-premise Business Intelligence solution; personal, team, and organisations level reports, KPIs, and dashboards. The solution is also Cloud-ready and can be readily migrated to Microsoft’s Azure platform.
The Version 1 team implemented a robust ETL (extracts, transforms, and loads data) using SQL server integration services. The ETL connects with a multitude of data sources across the different technologies that exist in Translink’s data landscape. Configuration of Microsoft’s Power BI tool allowed connecting to over 70 data sources, to help simplify data prep and drive ad hoc analysis.
Translink’s data is now accessible, meaningful, and usable across its different data systems and all data is of much-improved quality.
Translink now has access to reports that are consumed on the web and mobile devices. Staff can create personalised dashboards with a unique 360-degree view of their organisation, helping inspire better-informed decision making.
Translink can now operate more efficiently – with Version 1’s solution providing a 95% reduction in data report preparation time.
News & Insights
Blog, Culture, News: March 7, 2023
Version 1 Named a Best Workplace™ for Women in Ireland – Nancy Hendy Interview
8 min read Version 1 is thrilled to be listed as one of the Best Workplaces™ for Women in Ireland 2023. This news comes shortly after our welcome recognition as Ireland’s #1 Best Large Workplace™,...
Digital Guides, Downloadable Content: February 24, 2023
AWS Strategies for Cloud Migration Success
Are you thinking of moving your applications to the cloud? Version 1 has unrivalled experience in helping our customers to understand the technical makeup and customer value of their applications and make...
News: February 15, 2023
Discover Your Carbon Emissions Savings with our Calculator
It is a positive sign that technology companies large and small are monitoring their carbon emissions. Organisations have pledged to become net zero in the next few decades by setting ambitious sustainability...