Corporate IT solutions and services

Home
NDA (Restaurant chain, 3 locations)

A chain of 3 restaurants operating in the catering industry in a city of millions. Restaurants are oriented toward a wide audience. All three restaurants are similar to each other (transport accessibility, traffic, menu, number of seats)

TOP IMAGE: NDA (Сеть из 3-х ресторанов) - 1

TOP IMAGE: NDA (Сеть из 3-х ресторанов) - 2

TOP IMAGE: NDA (Сеть из 3-х ресторанов) - 3

Need

An outdated information system from a local developer was used to manage restaurants. The IS was no longer supported by the developer, but at the same time, it solved the operational tasks of restaurant management. The implementation of popular solutions with wide functionality has not been considered by the client.:

The task is to develop management reports and combine data from several sources in one place.

Solution

Implementation of the BI system Qlik Sense based on the SAAS version of Qlik Sense - an application for data visualization, research, and monitoring

Result

After the project was launched, cooperation with the client continued for 8 months in the form of subscriber service, within the framework of which changes were made to existing reports and new ones were added. Currently, the customer utilizes all developed information panels autonomously.

Details of implementation

A number of interactive information panels have been developed for restaurant managers and chefs. A mechanism has been developed for daily uploading data from restaurant management information systems to the corporate data warehouse.

One of the feedback questions involved descriptions in a free form. Using Chat GPT, such responses were analyzed and categorized. In semi-automatic mode, a problem was identified: visitors often remained dissatisfied with the long wait for certain dishes to be prepared. It turned out that not all waiters warned guests about the time of cooking the dishes, and there was no such information in the menu. An additional briefing for the employees was conducted by the manager, and a corresponding note was entered into the electronic menu.

In the course of work:
- Identified a correlation between seasonality and demand for dishes, different from those determined by chefs;
- Introduced an electronic menu instead of a paper one in one restaurant. This made it possible to quickly manage positions and analyze the popularity of dishes. Two dishes and one drink were identified that were frequently viewed but rarely ordered. The dishes used a spicy sauce, which was not warned about on the menu, and the drink was sour, which was also not warned about because visitors often refused to pay for it. After the problem was detected and identified, the customer decided to remove all three items from the menu;
- To assess customer satisfaction with service and cuisines, we have developed a Telegram feedback bot. The data was visualized in the information panel.