Picture: Josera GmbH & Co.KG

Josera GmbH & Co.KG

Optimization of the complete value chain with QlikView

"With QlikView we can visualize our company situation, making it tangible and taking decisions based on well-founded information."

Christian Sommer, Head of IT & Services, Josera GmbH & Co.KG

Company Profile

Josera GmbH & Co. KG is a medium-sized family business based in Kleinheubach near Aschaffenburg. Since 1941, the company has produced and sold healthy, high-quality food for livestock and, for over 20 years, also for dogs, cats and horses. The company is internationally oriented and currently employs around 240 people. The products are sold in more than 25 countries. Two years ago, Josera Polska established a subsidiary in Poland exclusively producing mineral feeds for the Eastern European market. The topics of process optimization and quality management are accordingly important in this context.

Initial situation

The process optimization approach requires the ad-hoc availability of valid data and key figures for the company situation. The rapidly growing need for information could no longer be met by the evaluations available so far. Above all, analyses of the overall situation were needed.

Solution

"We were looking for an evaluation solution that could be used in-house from the data model to visualization," summarizes Christian Sommer, Head of IT and Services at Josera. "User-friendliness was particularly important for us as we intend to provide individual Lean Six Sigma project stages with BI applications to all employees in their working area that they can use independently." Furthermore, the evaluation of data from different sources such as Excel, Microsoft Dynamics NAV , Wanko warehouse management and tour planning as well as internet log files may be possible.

With the support of COSMO CONSULT BI, Josera finally decided to employ the QlikView business discovery solution from QlikTech GmbH that combines all wishes.

Areas of use and benefits

"QlikView convinced us with its basic concept of user-driven Business Intelligence. All data can be directly examined directly and questions can be asked spontaneously - the answer is given immediately," says Mr. Sommer. Production, for example, knows how long before the loading process the goods were produced. Marketing receives, among other things, the necessary information about how many visitors have visited which website.

The simple and fast implementation was also impressive. "It only took half a day until QlikView was running on our virtual machine. In addition, I had already created a first application with the first available free trial version, which I could easily import. Furthermore, we use some QlikView applications that have been previously programmed by COSMO CONSULT. We can create new requirements in IT to 90 percent without external support. If there are any questions, they can usually be clarified very quickly with COSMO CONSULT. We can implement around 70 percent of the requirements on the same day."

In total, around 50 users from different departments access QlikView on a project-specific basis. These include employees from the areas of quality assurance, sales, marketing, production, operations, controlling, logistics, IT and the company management. "The solution has been absolutely proven successful for us. With the help of QlikView, we get a performance indicator that shows us where we stand and what we need to address to get even better," Mr. Sommer concludes.

Future

The use of QlikView should be further expanded. Consequently, there are considerations to introduce the analysis and reporting solution also at the affiliate company, Erbacher Food Intelligence GmbH & Co. KG. Eco-efficiency measurements should also be possible in the future.

Contact Us!

COSMO CONSULT International

COSMO CONSULT SI GmbH
Lothringerstraße 14
1030 Wien
E-Mail
COSMO CONSULT
201 rue Carnot
94120 Fontenay-sous-Bois
+33 1 83010360
E-Mail
COSMO CONSULT
Schoenebergerstr. 15
10963 Berlin
+49 30 343815-0
+49 30 343815-111
E-Mail
COSMO CONSULT KFT.
Rétköz utca 5. 1118 Budapest Magyarország
+36 1 899 9000
E-Mail
COSMO CONSULT Business Solutions SRL
Intrarea Gadinti nr. 1 Sector 1 RO-011066, Bucuresti
+40 21 224 5516
E-Mail
COSMO CONSULT SPAIN, S.A.U.
Vallespir, 19 4ª Módulo 2
08173 Sant Cugat del Vallès, Barcelona
+34 902820242
E-Mail
COSMO CONSULT AB
Ralambsvaegen 17
11259 Stockholm
+46 8 7998660
E-Mail
COSMO CONSULT
Ruetistrasse 13
8952 Schlieren
+41 44 8306465
E-Mail
COSMO CONSULT CHILE SaP
Mardoqueo Fernández 181
Providencia - Santiago de Chile
+562 2382 8050
E-Mail
COSMO CONSULT COLOMBIA SAS
We Work - Calle 26 # 92-32, Oficina 3-131
Bogotá - Colombia
+57 3004846267
E-Mail
COSMO CONSULT Business S.L
Checoslovaquia E10-105 y Eloy Alfaro
Quito, Ecuador
‪+593 99 608 4180
E-Mail
SOLUCIONES EMPRESARIALES COSMO CONSULT MÉXICO S.A.P.I de C.V
Arquímedes 15, Col. Polanco V Sección
Delegación Miguel Hidalgo
Ciudad de México C.P 11560
+521 55 83109660
E-Mail
COSMO CONSULT PANAMA & CENTRO AMERICA S.A.
Trump Tower, Piso 2, Oficina 210
Punta Pacífica
Ciudad de Panamá, República de Panamá
E-Mail
COSMO CONSULT PERÚ SAC
Avenida Javier Prado Oeste 757
Magdalena del Mar - Lima, Perú
+51940225294​​​​​​​
E-Mail