Phone:

+420 257 288 211

QlikView tool helps to manage production at the multinational SKB group

The interlinking of companies from various countries into capital multinational groups is among the outcomes of globalisation. The resulting much larger scope of business represents a challenge for managers: direct experience “from the field” no longer suffices for their decision-making as it had previously in the environment of a medium-sized enterprise with a long history, where everyone knew each other; managers must now orient themselves in data and numbers to a far greater degree. However, in order to do this, it is necessary to have available a tool that ensures data collection in one place and makes it possible to examine the data in the required view, quickly and without the necessity of involving programmers. This is not as easy as it seems.

Client:

PRAKAB Pražská kabelovna, s.r.o.

Characteristics of the customer

PRAKAB PRAŽSKÁ KABELOVNA, s.r.o., a manufacturer of electrical and telecommunications cables, is a member of the SKB group, which is owned by the Austrian company SKB Industrieholding GmbH. PRAKAB operates on the European market as the group’s production centre.

The history of cable manufacturing at this company headquartered in Prague’s Hostivař district dates back to 1921. It became part of the SKB group in 1992. Today PRAKAB is a modern industrial enterprise with more than 31,000 m² of production spaces and 360 employees, and it ranks among the most important companies in its field of business.

The SKB group has other manufacturing plants in Nitra, Slovakia, and Kiev, Ukraine. The group has been expanding continuously in recent years.

The customer’s initial situation

The growth of the company and the entire group over the past decade (2005 – establishment of the SKB group and construction of the plant in Slovakia, 2007 – construction of new production facilities in Prague, 2008 – new production equipment substantially increasing production capacity) increased the necessity of prerequisites for decision-making of the Prague company’s management as well as that of the entire group in Austria. One of the measures leading to this objective was the project focused on building a management information system processing especially data from production and sales. In May 2011 the Prague company thus issued a tender for a BI – MIS solution for the entire SKB group.

Our solution

KOMIX’s solution was derived from a successful process employed in other, similar cases: the unique properties of the QlikView product enabled us to very quickly develop and put into operation a pilot solution, which was tested at PRAKAB in November 2011, when three pilot applications for three companies in the group were placed on PRAKAB’s server. The pilot project was successful, even in the demanding conditions of the gradually developing commission.

Later, when users could concretely familiarise themselves with the advantages of this pilot solution, a draft of the optimum licensing model for the entire group was formulated, followed by the roll-out of a solution for the SALES area within the entire SKB Industrieholding group containing, among other things, localisation in the Czech Republic, Austria and Slovakia. Part of the project comprised migration of historical data for the past three years.

Evaluation – benefit for the customer

Thanks to this management superstructure, the customer’s operational application gained great value also for the company’s management, as it now enabled assessment of sales in relation to time periods, dealers, customers, types of products and costs of input materials and status of stocks.

The project was interesting for the customer also due to the fact that it obtained a comprehensive, unified solution for the entire multinational group through specific individual steps (from the beginning, the vendor’s contractual partner was the parent company in Austria).

The realised project was focused on processing data from the operational production system, i.e. on monitoring of production, sales, movement of material, semi-finished goods and finished products in warehouses. The company’s management preliminarily approved the expansion of the MIS solution’s scope of operation to accounting, logistics, etc.; realisation of this vision at present helps to reduce the impact of high prices of input raw materials (metals) as well as other fluctuations in the course of the business cycle in the sector.