Dorner Electronic: Processes and figures at a glance – with QlikView
"QlikView is an integral part of our daily work - in some departments even as the main tool. The software gives us a much better transparency. If you want to merge and analyze data from different systems, QlikView is the ideal tool."
Dorner Electronic develops innovative, reliable and user-friendly software solutions for the building materials industry. Based in Egg in the Austrian province of Vorarlberg, the company specialises in the planning, manufacture and installation of industrial process control systems for ready-mix concrete and precast concrete plants, precast plaster and dry mortar plants. The product portfolio also includes networked modules such as disposition, laboratory and invoicing programs. Today Dorner, with its 90 employees, is the market leader in Europe and has supplied prominent construction sites all over the world, including the Gotthard Tunnel, the Panama Canal and the Millennium Dam in Ethiopia.
Innovative, reliable and user-friendly – these attributes should not only apply to the software solutions Dorner offers its customers, but also to the applications used in the company.
Dorner was looking for a business intelligence solution with which data from various source systems could be combined and evaluated. The aim was to find a platform to which systems for PDA time recording, project management, ERP, support and ticketing could be easily connected.
The data discovery solution QlikView won the race. Its memory-based basic technology makes it particularly easy to connect third-party systems of almost any type. In addition, the solution is very flexible when it comes to application design and can be used directly in specialist departments thanks to its high level of user-friendliness.
In its search for a suitable implementation partner for the project, Dorner kept to the old saying “Why wander far away when the good is so close?” – and commissioned ppmc AG, based in neighbouring Liechtenstein. The Qlik Solution Provider specializes in customer-specific business intelligence solutions for medium-sized companies in the Alpine Rhine Valley. Within just a few weeks, the BI professional developed the data model, implemented QlikView and provided the first productively usable application.
Once you got a taste for it, the QlikView application landscape was continuously expanded – always supported by ppmc. “We meet about every four weeks to discuss ideas and wishes with ppmc, which are then usually translated into practicable solutions within a very short time,” says Dion Barelds, Head of Finance and Controlling, Dorner Electronic GmbH. “The cooperation is really excellent, professional and always at eye level”.
Areas of application and benefits
QlikView applications are now used by around 48 employees in almost all areas of the company. Around 100 million data records from source systems such as proAlpha, Echolon, ClockWork, MS Excel and MS Access are analyzed according to a wide variety of questions.
In purchasing and shipping, for example, vehicle and telephone data are evaluated as well as warehouse movements, stock and location. In addition, QlikView provides simple invoice control.
In the area of finance and controlling, the down payment business is evaluated. In addition, unfinished projects are evaluated by calculating the degree of completion.
In addition, individual FiBu accounts can be viewed and evaluated. A search for the sales tax identification number (VAT ID number) can be used to check whether the customers’ VAT ID numbers are complete and correct. Open documents such as orders, invoices, deliveries etc. can also be called up.
The HR department uses QlikView to summarize field time and check the data for any operational data collection errors (PDA errors). Employee reporting can be used to retrieve information on absenteeism according to criteria such as vacation, illness, time compensation, or training. A productivity application is also available that contains information on productivity per product, product group or employee. Logistics uses the BI solution to check material movements, among other things.
The sales department evaluates master data and uses a comprehensive sales cockpit that maps the entire sales business. Comparisons of sales budgets and current orders, the sales pipeline and the customer’s plant history can be called up – each according to different criteria such as region, customer and sales employee. There is also an open item evaluation.
In the service area, QlikView is used to evaluate support contracts and support per product, product group, customer, and telephone support. Project management maps the project costing in QlikView. This includes, for example, sales, material consumption and times at project level. Employee access is controlled by an easy-to-control rights concept. “Like other colleagues in management positions, I myself have access to all applications, otherwise employees can use exactly the applications they need for their work area,” adds Barelds. QlikView is fully integrated at Dorner and an integral part of everyday work. New employees are usually trained immediately on QlikView.
The QlikView applications are continuously adapted and expanded with the support of ppmc AG. Extensions in the FIBU area are planned.
In addition, the mapping of services abroad as well as foreign deliveries to Dorner for statistical purposes, such as submission to STATISTIK AUSTRIA, is being planned.