Implementation and operation of a comprehensive BI solution


«BSgroup Data Analytics AG has mastered the challenge of bringing together the figures from the different systems and making them cross-source analysts. We have found a strong partner in the BI environment who reacts quickly to our requirements.

BSgroup Data Analytics AG has understood how to respond to the needs of our controllers and create a reporting solution that is perfectly tailored to them.»

Adrian Bodmer, CFO Denner AG

«The technical know-how of BSgroup Data Analytics AG in the Microsoft BI stack has enabled us to build a stable and high-performance reporting solution for the entire company.

By using well-defined templates in development, changes can be implemented quickly and reliably.»

Manuel Fondo, CIO Denner AG


Denner AG is the leading discounter in Switzerland and is represented in all parts of the country. In around 840 Denner sales outlets, 570 of which are Denner’s own branches and 270 partner outlets, Denner AG serves around 140 million customers a year. The company currently employs around 5,800 people and is currently training 130 apprentices. In total, Denner stocks over 100,000 articles from around 2,800 suppliers from all over the world.

«We need a uniform and centralised view of the company data that unites all business areas of Denner AG and that is available and usable at all times for all relevant departments.»

Adrian Bodmer, CFO Denner AG

Our successful cooperation with Denner AG started with this order in 2014.

Our client on the Denner side – CFO Adrian Bodmer and CIO Manuel Fondo – had the vision, as part of the introduction of a new checkout system, to also set up a new, company-wide key figure reporting system in a short space of time, which would enable the use and analysis of management-relevant data across different departments.
On the one hand, the biggest challenge for the project team was to process the item data generated by the POS system in such a way that it was available in a centrally comparable form across the entire value chain.

Solution for Denner AG

With our solution, we have designed the data model in such a way that highly aggregated data can be analysed directly down to the smallest unit at item level without media discontinuity. With XL3 and XL3-Web, Denner AG is now able to provide around 1,000 employees with uniform and, if required, highly granular data. Both specific needs of controlling as well as those of the operational areas of purchasing and sales are covered with a very comprehensive data model.

Customer value

From more than 180 rigid reports, a portfolio of a total of 30 dynamic standard reports could thus be created for Denner AG. Among them is a supplier negotiation report with different views and levels of detail, as well as a price/quantity/mix report to show information from the sales price OP to the net margin at item level, or even a report for daily, weekly and monthly performance measurement of the outlets.
This approach has led to a significant increase in effectiveness and efficiency, and allowed controlling to invest more time in interpreting the data and less in preparing it.
The uniform data catalogue and integrated control have created the basis for better managing Denner AG in the digital age and further developing the existing analysis options.