A large public sector transport company running a plethora of transport services including trains, buses and car sharing schemes. Their trains business includes several Train Operating Companies (TOCs) and wanted to analyse the full lifecycle of passenger journey data – from the moment a ticket is purchased to the time the passenger has arrived at his destination – into comprehensive, useful intelligence.
A vast majority of national rail tickets purchased in the UK is available to the TOCs through Lennon – the UK rail industry’s central ticketing database. To derive any useful intelligence, the ticket data from Lennon needs to be enriched with business rules and earnings data that are exclusive to the TOC.
This enriched data can also be used to meet some common objectives across the industry – improve services, compliance adherence and provide a basis to the bid teams.
Once a combined dataset emerges, each TOC should ideally be able to:
In the absence of a combined data set, TOCs build several siloed reports which attempt to provide the basis for analysis. The following technical challenges prevent the TOCs from benefiting from a quick and reliable source of information:
UXLI was approached for a scalable, flexible and performant solution that would allow business analysis in multiple dimensions. Our solution involved the use of multiple cloud-based technologies architected to work seamlessly. Technologies used for the solution included SnapLogic, AWS S3 Service, AWS RedShift, and BIRST.
Energy Supplier Benefits from Fully Integrated Business Intelligence and Planning Solution