Back to overview

Customer Story

Greatest customer proximity thanks to Power BI in the Cloud

A new cloud-based BI solution reduces costs and effort at Oswald Nahrungsmittel GmbH. In addition, a central platform makes information available quickly and easily.

In Short

CHALLENGE

The outdated infrastructure needed to be standardised and modernised.

SOLUTION

Migration of existing systems to the Azure Cloud and Service Level Agreement.

BENEFIT

The burden on the IT team was eased and project, license and operating costs were successfully reduced.

Our Solution

When it comes to direct sales, proximity to the customer and personal consultation are decisive for business success. Companies that sell their products without intermediaries therefore traditionally maintain close contact with their end customers. Accordingly, customer service is the top priority for Swiss seasoning manufacturer Oswald. 150 of the 250 employees at Oswald work in the field and advise their customers at trade fairs and at local trade stalls. Alternatively, products can be ordered online from the seasoning specialist. Customers of the company – both young and old – value the personal proximity and the great customer service.

Simplified Cloud infrastructure

To be able to continue providing this first-class service, Oswald employees depend on reliable data on customers and sales, products and delivery times. Oswald already implemented a BI portal with Trivadis 10 years ago, which provides in-house and field staff with the analyses they need. Oswald’s infrastructure had become quite outdated, so the time had come for it to be standardised and modernised. After extensive consultation with Trivadis, Oswald decided to migrate the existing systems to the Azure Cloud.

Trivadis migrated the 13 databases that used to run on an MSSQL server On-Premises to four virtual machines in the Azure Cloud, where they are now available for operation as IaaS. As part of this process, the outdated reports were modernised and simplified in order to offer better performance and implement expansions that had been pending for a long time. The access rights were also re-segmented so that access to the reports is restricted by department. An Oswaldspecific Silverlight in-house development for the sales force was also successfully ported to modern technologies and the foundation for further extensions has been laid.

More transparency thanks to a modern BI platform

Another requirement involved further development of the existing BI platform and the integration of new functionalities. The aim of this is to eliminate or clean up redundant reports. For this purpose, together with Oswald, we first analysed which reports are required in what form and whether the data required for this is reliably available. The modern infrastructure in the Cloud also offers noticeable relief for Oswald’s IT team, as they no longer have to take care of an infrastructure on the premises.

For the systems operation in the Cloud, we provide Oswald with support services under a service level agreement. Service requests are also no longer received, processed and logged by the in-house IT department; the Trivadis Service Desk takes care of this. Thanks to these measures, Oswald was able to reduce its project, license and operating costs.

Respond faster and more reliably to market requirements

With the new BI solution, Oswald’s employees receive all the information they need for their daily work via a central platform. Thanks to the simpler systems, the effort required to analyse the data is reduced and the IT team can concentrate on other tasks. All in all, the new solutions enable the company to react much faster and more reliably to market requirements and save costs at the same time.

ABOUT THE OSWALD NAHRUNGSMITTEL GMBH

Oswald GmbH was founded almost 70 years ago and sees itself as a specialist for seasoning products and bouillons. In recent years, it has developed from a small family business into a modern food company. The company employs around 250 people, 150 of whom are field staff. It sells products in Switzerland and Europe.

Technologies used

  • Microsoft Azure Cloud
  • SST to ERP and logistics system
  • Azure IaaS
  • Azure Frontdoor
  • Power BI Report Services Portal for users

More stories

AI Cloud IoT Analytics Data Platform Microsoft Health Care
How artificial intelligence helps children breathe
Data Platform Cloud Automation Microsoft Automotive Analytics
With central data plat­form to the self­driving car
Modernization Managed Services Microsoft Food
Fail-safe production with max­imum data avail­ability

Your contact