BI City

Most Popular

QlikView to Analyze Eurotunnel's Data from Its SAP System

By SiliconIndia   |   Thursday, 12 July 2012, 10:17 Hrs
Print Email

Bangalore: Train operator Eurotunnel, which runs Le Shuttle, is using business analytics applications built with QlikView, to analyse data from its SAP system.

QlikView is being used by the sales team to help Eurotunnel Le Shuttle understand its customers better; their purchasing methods and patterns, geographical location and the impact of marketing campaigns.

It is used to assess business demand to plan capacity at the most effective times, including allocating additional shuttles to manage demand, measure business performance against budget and targets on a daily, weekly and monthly basis.

The business intelligence tool was selected over SAP Business Objects, due to cost and limitations of the SAP BI product. "We wanted our analysts to build their own reports, rather than rely on IT. With Qlikview our analysts can build their own queries, rather than use a SAP consultant. My analysts create the applications. The whole ethos is about self-service," said Paul Lymath, Strategic Planning & Analysis Manager at Eurotunnel.

QlikView offered Eurotunnel the flexibility to pull in data from multiple sources, including SAP BW, spreadsheets, the HR system and e-mail response data, stored as a flat file.

The deployment of QlikView started as a pilot project. "We didn’t have buy-in from our IT department," said Lymath. One of the barriers he faced was that IT wanted him to use a specific method to extract data from the SAP system using SAP BW with OLAP (online analytical processing) extraction, which did not work.

This would have allowed his team to extract only the data from the SAP system that had changed. Since the interface was not functioning, he had to scoop all data the SAP data on a daily basis instead using QVD, the QlikView file extractor. The data is extracted from SAP and loaded into QlikView.

 “This does put a large load on SAP, but it was the only way we could extract the data,” said Lymath.

Once in QlikView “I can see sales from yesterday and compare to last year, and see, for instance, which tickets were sold, how they were bought, when are they are travelling, is it for the Olympics?” he added.

Once SAP BI 7.0 is fully implemented at Eurotunnel Lymath plans to use the method IT prefers for extracting SAP data based on OLAP.

Experts on BI
Sanjeev Kumar Sharma
Managing Director
Harish   Pandey
BD Manager
Niranjan  Rout
Tata BlueScope
Rohan Anil Bhatt
Business Consultant
Dinesh Kumar Mehta
V P Operations
Roop Polymers
Gaurav  Mittal
Solution Architect
YASH Technologies
Jayant R Joshi
Delivery Manager
Tech Mahindra
Pramod Kumar Sharma
Project Manager
Suntec Web
Write your comment now
Small and medium-sized businesses stand to benefit from business in...
Data warehouse appliances that bundle analytic databases with serve...