Jungle Juice Bar is growing by leveraging data

Jungle Juice Bar uses two ready-made connectors (Procountor and Quinyx) and a tailored solution for their Point of Sales data. For them, data related to work shifts is particularly important, for example the start and end times of work shifts, which are collected from the Quinyx shift planning system. Similarly, sales data is imported at the receipt line level from the Winpos point-of-sale system. The receipt data reveals which products are sold and at what times, while the work hour data helps optimize shift planning. Accounting data needed for profit margin calculations is also fetched into the system to further complement the other data.

What was the situation like before QuickBI?

Before partnering with QuickBI Jungle Juice Bar had started building its reporting system with another partner. However with the previous partner, the scope of Jungle Juice Bar’s business and reporting always seemed to get overshadowed by larger clients. The flexibility and quick support from the partner were critical when it was necessary to validate the accuracy of reports or when something temporarily broke under the hood. There were challenges with the previous partner in the collaboration in this regard, which was not ideal.

What benefits has QuickBI provided?

Shift planning has been taken to a whole new level with the help of QuickBI. Opening hours for locations and shift schedules can now easily be optimized to match demand peaks, and tracking work efficiency is easy, fast, and up-to-date.

QuickBI has been the right partner for Jungle Juice Bar and has been able to meet the faster-paced development needs of the company. The agile working model has suited both companies well, and the collaboration has been seamless and enjoyable.

What types of reports are in use?

The same key performance indicators are being monitored and the same report templates used by both; Jungle Juice Bar’s juice bars and its executive team. However, there are some differences, such as in the tracking periods of the different reporting metrics. Typically, the Juice Managers - who are the heads of juice bars along with their teams, track sales on an hourly and daily basis, comparing actual sales against location-specific targets.

In turn, work efficiency reports help the area managers and country managers in decision-making and shift planning at the location level, with hourly-level detail. Reporting also enables higher-level monitoring based on specific pre-defined regions as an example.

The QuickBI system collects all different work hour types from the shift planning system, making it easy to track hours spent on different work hour types (training for example).

Product and location based profit margin reporting helps optimize waste amounts and helps identify location-specific differences and anomalies efficiently.

How has the collaboration been? What’s next?

The executive team at Jungle Juice Bar and the area managers leading sales have received the new reports made by QuickBI very well, and the feedback has been positive, as reflected in one of the feedbacks received from the customer: the new reports have caused quite a “wild” frenzy in the jungle!

Customer service has been excellent, and Jungle Juice Bar has quickly received answers and assistance to its questions. The new reports have been rolled out on an extremely tight schedule which has been a possibility because all the necessary data is easily accessible through QuickBI’s data pipeline.

The future focus will be on expanding the profitability perspective to various dimensions, such as day of the week, time of day, product, location, and region -dimensions. In other words, the goal is to integrate new data sources into the system and create more added value to business management and planning.

From identifying business needs to efficient reporting

Starting the collaboration required only a few meetings from Jungle Juice Bars’ side, during which the current state of the company and its reporting initiatives was efficiently reviewed. The meetings mostly focused on listening to the customer; where they thought improvements could be made in reporting, what data was still missing from the reports, and what new reports might need to be developed. It was also crucial to get answers to the following questions during the initial assessment; what metrics does the company currently use, which metrics are working well, which metrics are not working, what needs to be improved and what does the customer want from its data? In addition to the initial assessment in the start, the kickoff meetings also defined common goals for the collaboration and discussed questions that may not yet have clear answers.

QuickBI’s customers have the ability to design and implement their own reports using QuickBI’s technology, or alternatively they can choose to share information about their business and reporting needs - giving QuickBI the responsibility to handle report creation for the customer instead. In addition to technical expertise, QuickBI has experience across different industries.

Jungle Juice Bar’s first reports were ready two weeks after the collaboration began.