Our next data analytics monthly virtual forum is happening on Tuesday 4th June 2024

What are you looking for...

Great Rail Journeys embark on a journey to the cloud to find one version of the truth.

Great Rail Journeys

Case Study: Azure Data Warehouse & Power BI

Client Overview

When the private equity group, ECI Partners, acquired a controlling stake in Great Rail Journeys. With an eye for adding value, they sought to unleash the capabilities of the business through the power of robust, trusted management information.

The answer replaced several disparate legacy systems with a new business-wide Management Information System (MIS), using Microsoft Analysis Services and Power BI together with a Microsoft Azure data warehouse.

Simply no single version of the truth

As the new CEO of Great Rail Journeys, Peter Liney soon realised that there was simply no single version of the truth; he found there were six different uses of a ‘year’ and twenty-two variants of a ‘booking’and the opportunity for error was clear. The inevitable consequences hampered the smooth running of the business – time wasted debating which department had the correct numbers;  less confidence in decisions made;  less transparency of outcomes; and limited ability to analyse in depth in order to understand variances from plan and then agree the appropriate response.

As CEO, Peter’s own requirements were for high level commercial information drawing together data for marketing demand, sales conversion and commercial profit, plus an ability to ask and answer questions of it quickly. Finally, he needed it delivered in a format that could be accessed by everyone in the business, without generating additional layers of administration.

Sales, Costs and Margins : Phase One

When Peter first sought ‘a single version of the truth’, the ensuing project proved challenging for what, in hindsight, proved all too understandable reasons. With motivated senior managers highly capable of driving their area of the business forward, seeing the benefits inherent in a single version of the truth was easy; but agreeing the definitions of key terms and metrics was not. The project benefited from a robust change management process driving that decision making process. With that fundamental shift in approach, the impossible became merely difficult.

This first phase delivered full visibility of the profitability of each rail tour, be that the number of  bookings at any point in time (as at); the number of existing customers that had booked versus the number of new customers; the headline revenue, costs and margins of each tour and the comparison versus any chosen time this year versus last year for the same tour. All of this is available to the business every day and all can be analysed at any level and by any perspective (dimension). This pulled data from six unique data sources providing a much needed coherent architecture.

Martin Johnson, – Finance Director

Campaigns, Enquiries and Spend : Phase Two

Great Rail Journeys’ marketing had always performed well but its ability to move forward was compromised by how their data was siloed. Phase 2 was more challenging purely because of the amount of work needed to curate the data to define common definitions, common processes and agree the measures and KPIs.

Marketing now operates with a far higher level of personalisation; customers can be spoken to about potential holidays based on their own history. Not only is this more effective, it is less wasteful and therefore lower cost.

Detailed interrogation of real-time data has enabled the team to be more responsive to events as they occur and take the decisions to improve performance. The end result has been a marked improvement in marketing conversion rates – a core goal for all digital marketing teams.

Alex Roberts
Marketing & Sales Director

Operations – From frustration to happiness: Phase Three

When a Great Rail Journeys’ customer requests a variation to an aspect of their travel package it creates a real moment of truth for the business. The ability to request a hotel room variation; an additional excursion; or a flight upgrade may be a key aspect of any customer’s holiday experience.

At the most basic level, cost and time taken are the two ways in which that experience is judged by the customer. Great Rail Journeys did not have the information on hand to manage both, generating customer complaints and a potential loss of business.

Following the implementation of phase 3, that situation was completely reversed. A team passionate about customer service was finally able to set about delivering on the promise – they now have full visibility of the status of every customer requested variation resulting in fewer complaints and higher ancillary sales.

Knowing that a customer is dissatisfied quickly enough to do something about it, helps turn potential bad experiences and loss of business into great experiences and brand promoters.

Noeleen Pritchard – Operations Director

Dealing with the owners – no surprises.

As owners of Great Rail Journeys, ECI has a simple goal: to improve the business for the short and long term. To make progress towards that goal, ECI managers actually have an uncomplicated reporting need. They like to know what is happening, good or bad and they don’t like surprises, so a single version of the truth matters.

With the MIS in place, Great Rail Journeys is sharing the same data that they actually use to run the business. ECI can see the key trends of margin and profitability becoming more accurate. This gives confidence – about the business and the ability to derive future value.

KPIs – accuracy with timeliness [As at]

Performance versus last year is a common measure of progress; getting it in detail and right up to date is more of a challenge. MIS incorporates an ‘as at’ level of functionality that allows just that: the performance ‘as at’ close of business yesterday versus the exact same period in the previous year, that is always up to date, for any attribute, segment, product, or division.

Timeliness is no longer compromised for accuracy. Over and underperformance are rapidly identified, allowing the business to respond accordingly. It has created a common way of thinking, using a common language across the business.

Martin Johnson
Finance Director

Platform stability provides a flexible delivery

IT Director, Mark Taylor, was clear that the data warehouse layer was of primary importance – a clean data layer first. The software used to analyse the data, and serve it up to the various departmental users could come afterwards, potentially even using third party agencies. In fact, a planned spend to procure Business Intelligence software was shelved as the power of Microsoft Analysis Services (SSAS) and PowerBI built upon the SQL Server data warehouse was realised.

Hosting was a key issue and on-premise, albeit with its accompanying hardware capital investment requirements, remained an early option. However, sizing it to scope the costs was difficult, given the unknowns in the early stages. Cloud, in the form of Microsoft Azure was the other option, allowing the company to get moving very quickly.

Mark Taylor
IT Director

Releasing the power of IT

Great Rail Journeys’ IT department now delivers for the business in a very different way. Using Microsoft Azure means that all the IT processing takes place outside of the business, directly reducing the IT maintenance and performance management burden.

As for supporting the decision-making processes of the company, the days of hourly requests to create SQL queries as a mainstay of IT activities are long gone. The key focus today is delivering an international web-based trading system that enables the company to do business around the world in multiple currencies.

Peter Liney – CEO


  • Every departments’ daily, weekly, monthly and annual reports all agree with each other
  • The board and owners use the same reports and dashboards that are used to run the business
  • Marketing spend is producing lower cost per sales conversion
  • More satisfied customers, as Operations can respond effectively to customer requested variations
  • IT resources deployed on building customer facing capabilities, not writing reports
  • More leverage in supplier negotiations, driven by aggregated spend analysis

As a Microsoft Gold Partner for Data Platform and Analytics and a Cloud Platform partner, Simpson Associates have the necessary skills and experience to help. Find out more about our Microsoft BI Consultancy Services here or contact us to discuss your current requirements and book a demonstration.

How can we help you?

Let’s discuss how we can transform your disconnected data into actionable insights for better outcomes.

Call: 01904 234 510

Contact Us Form