BUSINESS IMPACT OF THE NEW BI SOLUTION: 4% INCREASE IN SALES
In Slovenia, Marche Gostinstvo employs 197 people and is among the larger companies in the SMB segment. The management board in Slovenia with 2 members reports directly to the representative office in Switzerland. One of the business challenges the management in Slovenia faces every day is how to provide fast and accurate data about the business to foreign owners.
“We know we have data that we can use more effectively. In our company, it’s details that matter. For example, bad weather during a weekend can reduce our business results by the factor of 2.”
- Aleksander Sinkovič Jurca, CFO, Marche Gostinstvo
"Several years of experience with implementing and developing BI solutions and the intuitive Qlik technology enabled us to complete the implementation in the shortest time possible. To ensure the overall success of the BI tool, an important factor is the ability to adapt the solution to the company’s specific requirements. I believe this is where Adacta is doing a really good job and it’s why our customers really get what they need from our solutions.”
- Anže Mis, Head of BI Department, Adriatic Region, Adacta
“A very professional team that speaks IT and business language combined with a modern and intuitive BI solution was exactly what we needed for our business.”
- Aleksander Sinkovič Jurca, CFO, Marche Gostinstvo
Marche Gostinstvo d.o.o. is a member of the worldwide chain Marche International AG and Mövenpick Holding AG. Marche is recognized as a supplier of fresh and quality food, with its main European markets being Switzerland and Germany.
Like in other countries, the core business of Marche in Slovenia is the preparation and supply of fresh and seasonal food with the focus on locally produced food. Mostly local and freshly prepared food is offered in the 16 restaurants located on the Slovenian motorway network. Food offered by Marche varies significantly based on micro-location - in the Styria region, cremeschnitte is an important part of the offer while the offering on the southern motorway varies depending on the travel direction - in the direction of Koper, breakfasts are the main business, and in the direction of Ljubljana, the focus is on lunch.
Since the ratio in sales volume between the best summer month and the worst winter is 1: 6, the main challenge for the Marche management is how to deal with such high seasonal fluctuations. The company is aware that the optimization of procurement and supply at individual locations and in different periods (working week vs. weekend, summer vs. winter) can make an important contribution to the optimization of production and sales as well as overall business.
How to lower material waste, how to adapt the offer to the micro-location, how to prepare reports on time and efficiently and how to optimize planning were the company’s challenges. The local management was convinced that custom business intelligence and analytics could help them overcome the above-mentioned challenges to drive better business results.
Looking for an optimal solution
Like in every other company belonging to an international chain, business and technological solutions used in Marche Gostinstvo are centralized. For the general ledger SAP ERP is used worldwide and for its centralized business intelligence tool, the group uses the SharePoint platform with advanced predefined layouts and templates. Before Qlik Sense was introduced, the company locally used an Oracle business intelligence solution, which was seen as too rigid and not agile enough to support the flexibility the company needed for reporting.
After the test period of using Qlik Sense Desktop application, the management realized Qlik is the solution that can help them successfully face their business challenges. By working with Adacta’s BI department the management demonstrated the use of Qlik Sense in the company with live data. The demonstration convinced the owners that Qlik Sense is a good investment.
Only a couple of days needed for the implementation
The company was thrilled by the very short implementation period – from the final definition of business requirements only 5 days were needed for the management to start using the BI tool. Such a short implementation time was made possible by the effective cooperation between Adacta's BI department and the IT company that provides IT support services to Marche Gostinstvo (back-office software and cash register). A joint team successfully managed to consolidate all databases and tables. To make the new BI tool as effective as possible, the company imported business data from 2012 on and the current business data is imported into the BI system with a single tool.
Qlik Sense is adapted to enable efficient comparison between individual accounts, expenses and revenues, between individual production entities and sales units and selected time periods (hour, day, season). Sales analysis can be performed to the level of an individual product sold. The BI solution is integrated with the document system and the management can see where individual pieces of data in the report come from at any moment (»drill-down« data).
The company sees the user-friendly interface as the main benefit of Qlik Sense – using Qlik Sense is easy and intuitive and each business user can create their own reports by merely clicking. Users’ own creativity or the ability to ask question is the only limitation to the BI solution, meaning Qlik Sense is able to give an answer to every business question.
In addition, business users benefit from independence to add more dimensions to queries and creating customized reports. Another benefit of working with Adacta as seen by Marche management is the option of additional training offered by Adacta to end users. The purpose of training courses is to educate end users and provide them with as much knowledge about the software as possible so they can leverage the BI tool to its fullest.
Solution, adapted to the business needs of the company
Specific additional upgrades were developed and incorporated into the new BI software, such as:
- A detailed overview of the holidays, which have a major impact on the business
- An overview of the motorway traffic volumes in real time, which enables Marche to adapt its offering and minimize waste
Custom analyses, adapted to the industry and the company are additionally developed for Marche: an analysis for each restaurant, time period and custom analyses for financial and operational controlling.
Decreased time for reporting and improved business decisions
After several months of using Qlik Sense, the management points out following benefits of the new BI solution:
- Fast and accurate overview of the business in real time – every minute, every hour, every day the company knows how much of each product is sold and written off in each of its 16 restaurants
- The ability to drill-down enables business users to see the origin of the data that’s included in the report
- Significantly decreased time needed to prepare consolidated reports
- Clear visual representation of data and the ability to refresh data within each chart
Business impact of the new BI solution: 4% increase in sales
In 2015 the company Marche Gostinstvo was able to increase sales by 4% in the industry with a high price pressure and with fixed number of locations. Marche believes that the growth is entirely a result of continuous monitoring of sales across all micro-locations, which enables them to adjust the offering and reduce the amounts of waste.
Plans for the future
In 2016, Marche Gostinstvo wants to continue its investments in the BI solution with additional descriptions and overviews. At the end of 2016, the company wants to implement the solution into the subsidiaries in Croatia alongside the upgrade of the rest of the IT infrastructure.