Effective planning with complete import of existing BI data

Effective planning with complete import of existing BI data

DewertOkin GmbH, headquartered in Kirchlengern, is an international manufacturer of drive technology and system technology. In order to ensure a smooth planning process within the group, a centralized sales planning system was required. With the successful implementation of antares planner, various processes could be optimized and made more efficient.

Download Success Story

At a glance

Industry: Drive technology
Company size: approx. 240 million euros annual turnover
Requirements: Centrally managed database-based planning tool
Users: 40 users
Project category: Planning software antares planner for ad hoc and self-service BI

DewertOkin GmbH

DewertOkin GmbH, headquartered in Kirchlengern, is an international manufacturer of drive technology and system technology. The company is part of the Swiss Phoenix Mecano Group. In close cooperation with its customers, DewertOkin develops, manufactures and distributes single and double drives, lifting columns, operating elements and control systems. Drive technology from DewertOkin is used in the Bedding, Seating, Medical and Office sectors. The drive technology is installed in variably adjustable desks, armchairs, chairs and beds - for private and commercial use as well as in the care and medical sectors.

Task

Centralized sales planning was required to ensure a smooth planning process within the Group. Using a central database, 40 authorized DewertOkin employees from 14 production and sales companies around the world were to have access to the relevant company information and thus be able to participate in the processes on an ongoing basis. Planning should be based on both the top-down and bottom-up principle and be able to generate comparative scenarios taking into account relevant influencing factors.

Solution

Previously, the complex planning process was carried out using the Microsoft classic Excel. However, as this tool quickly reaches its limits with such complex processes and is therefore not effective, DewertOkin opted for the proven planning tool antares planner for adhoc and self-service BI. The software can be easily connected to adhoc BI platforms and existing upstream systems and, in addition to the ability to plan at all levels (sales, financial, condition planning, etc.), also offers extensive distribution functions as well as multidimensional top-down and bottom-up planning. The BI evaluation tool QlikView was also used for even more meaningful data visualization.

Practical benefit

With the successful implementation of antares planner, various processes at DewertOkin have been optimized and made more efficient. Not least because time-consuming and error-prone Excel files were replaced by standardized processes that could be easily mapped in the antares solution. One of the main criticisms of the previous procedure was the time-consuming, error-prone input in Excel files, which also had to be sent several times and manually reconciled. Today, the workflow-based solution can be accessed via any standard browser with individual profiles and authorizations stored in the application. This was necessary for global and direct access to the new planning platform. The challenge of incorporating exchange rates was solved just as efficiently as, for example, various distribution algorithms in splashing, pronounced planning depths in very fine granularity or process support for the top-down/bottom-up approach chosen by DewertOkin. The bidirectional connection to the existing self-service BI tool QlikView ran smoothly and without any technical barriers. Automation without manual intervention also made things easier for everyone involved in the project. Today, DewertOkin summarizes that a secure, reliable and traceable planning process can be completed in a significantly shorter time, worldwide and without restrictions.

Dewert Okin: Planning levels

antares planner for ad hoc and self-service BI maps the entire planning process on the basis of existing analysis platforms. The application allows the user to run through freely selectable planning scenarios and compare them directly with each other. Easy connection to existing upstream systems and data structures as well as a short implementation time are what make antares planner stand out.

Advantages

Monitoring data consistency

Parallel working thanks to fixing options

Problem-free connection to the existing IT structure

Short implementation time

Intuitive user interface

Authorisation concept

What our customers say

"In antares planner, we have found a web-based planning software that perfectly complements our existing BI landscape."

Andreas Depenbrock | Head of Controlling | DewertOkin GmbH

"We appreciate the short response times and the solution-oriented approach."

Andreas Depenbrock | Head of Controlling | DewertOkin GmbH

Download

Discover the success stories of our customer projects. Download the success story "Effective planning with complete import of existing BI data" from DewertOkin GmbH directly and free of charge as a PDF.

Download success story