Business-Qlik for Restaurants

Business of BURGER KING in Russia develops very dynamically that requires special attention to a situation in each of restaurants of network. With respect thereto the company management at some point came to a conclusion that the existing system of obtaining analytical data cannot satisfy need of specialists – first of all, it concerned analytical data on sales in outlets.

Project Task

"In BURGER KING reports were formed in the MS Excel format in the forms developed in the company, – the Development director of information systems of company BURGER KING, Sharapov Maxim tells. – There was many information and it constantly increased therefore files with the reporting were very heavy and long opened that slowed down work and it was extremely inconvenient for specialists of the company. In process of growth of network of restaurants this problem was only aggravated. Certainly, users wanted flexibility and an opportunity to see interpretation of revenue to a dish and transactions – as a result we made the decision on business analysis system implementation as she could solve our problems"

Besides, in the company several IT systems from which information required consolidation were used. Specialists of BURGER KING had a need to keep track of integrity of data and to perform reconciliation between systems, however tools for this purpose were not – the new BI solution had to solve also these problems.

In BURGER KING approached the choice of an analytical system very deliberately, having formulated a number of the most important requirements. First of all, the solution had to provide the automated data loading from the information systems sources, without requiring intervention in process of users and IT specialists. A BI system had to provide setup and performing procedures on normalization of data: lead the loaded data to a uniform format, create and save communications between the data obtained from different sources.

Besides, a new BI system had to perform unloading of systems sources given from the information systems sources by the direct appeal to DBMS. The incremental loading allowing to unload only the new and changed data was one of requirements, providing storage of earlier unloaded. Also requirements to a format of the received reporting were essential – work with two types of report forms had to be supported. First of all, users had to have an opportunity to continue work with the fixed forms of the reporting of the set sample, however also interactive reports with which it would be possible to work with the help of the graphic designer were necessary. At the same time, it was necessary to save a possibility of export of the created reports to Excel files both in manual, and in the automatic mode. Besides, the user interface of reporting system had to be intuitive.

QlikView The Business Discovery platform and Business-Qlik for restaurants for benefit of which a choice was made became the only solution which could correspond completely to requirements of BURGER KING. The company became the partner in implementation BI Consult (Bee Ai Consult).

Tasks:

• Consolidation of separate analytical data
• Providing the simple and convenient tool to users for work with analytics
• Detailing of analytical information to the most bottom level
• Fall forward of obtaining analytical data
• Setup and performing procedures on normalization of data

Data sources

• Specialized automation system of R-Keeper restaurants
• ERP system of Microsoft Dynamics AX (Axapta)
• Tables MS Excel

Project Results

In a project deliverable which lasted 3 months applications for the analysis of sales with detailing to the check were created. The QlikView applications obtain data from three sources: from the R-Keeper system for the analysis of checks and revenue, from the ERP system of Microsoft Dynamics AX (Axapta) from which data on attributes of restaurants and revenue for reconciliation are taken and also from Excel tables where information on plans and budgets is stored. In particular, the application for reconciliation in R-Keeper recalculates 20 million lines, on its creation two months left.

As a result quite essential amounts of data are loaded into QlikView. So, information on transactions from 2014 contains 170 million lines, aggregated data on restaurants, since 2011, hold 600 thousand places. Reconciliation of transactions is performed on 16 million lines, and reconciliation on restaurants – on 140 thousand lines.

During implementation for financial department of the company the control panel with key indicators was created. Specialists had an opportunity to carry out contrastive analysis of revenue on restaurants, regions and territorial managers and sales by a dish, to analyze execution of budgets for regions and restaurants and also to perform reconciliation of data between the accounting systems.

"Thanks to implementation of QlikView and Business-Qlik for restaurants we increased efficiency of formation and fault tolerance of regularly created reports on revenue for decision-making by top management of the company, – the Development director of information systems of company BURGER KING, Sharapov Maxim comments – the Solution was very flexible and easily configured under our requirements. Now we can look at interpretation of revenue up to the check or a separate dish, carry out contrastive analysis of work of each restaurant on the selected period or all restaurants on the region.".