National Express replaces spreadsheets with QlikView for data analysis

Provides insight on 100 million company records

National Express Coach is using QlikView business intelligence tools to improve fleet management and monitor customer service, replacing legacy spreadsheets systems.

The UK coach operator, which supports 18 million journeys on its network each year, deployed the QlikView Business Discovery platform in August 2013 to provide insight into the 100 million records collected across its operations.

The software has now been rolled out across all departments, providing a number of operational benefits.

For example, it allows the National Express commercial team to examine coach route data more easily, helping to identify the most profitable routes. It also enables the customer services and service delivery teams to analyse customer feedback to target areas for improvement.

"It affords us the flexibility to explore the data in the ways we need to, and allows us to cut through the data to look at statistics for every individual journey, something that wasn't possible when we relied on basic spreadsheets alone," said Frank Kozurek, business intelligence manager at National Express.

The QlikView software has opened up data to all staff involved in National Express' BI programme, rather than just the IT department, offering business units a broader view of the company.

National Express said that the ability to access market data has also allowed the business to adapt its pricing, leading to a six figure increase in revenues.

"It's been a novelty to find analytics software that can actually be used by everyone across the business - rather than just specialists in data," added Helen Blaikie, head of business planning at National Express.

The implementation forms part of a wider project to enhance National Express' BI capabilities, and the company also plans to upgrade from Windows SQL Server 2008 to the 2012 version in the next six months.

Going forward, National Express intends to add more functionality to its QlikView deployment, including a social media analysis module.

The value of the deal, which was carried out with QlikView partner Data Technology, was not revealed.

QlikView has been used by a number of enterprise firms, including Volvo UK, car rental company Sixt and building firm Taylor Wimpey.

This story, "National Express replaces spreadsheets with QlikView for data analysis" was originally published by Computerworld UK.

To express your thoughts on Computerworld content, visit Computerworld's Facebook page, LinkedIn page and Twitter stream.
Windows 10 annoyances and solutions
Shop Tech Products at Amazon
Notice to our Readers
We're now using social media to take your comments and feedback. Learn more about this here.