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 S.L.
Vallespir, 19 4ª Módulo 2
08173 Sant Cugat del Vallès, Barcelona
+34 902820242
+34 943313002
E-Mail
COSMO CONSULT AB
Ralambsvaegen 17
11259 Stockholm
+46 8 7998660
E-Mail
COSMO CONSULT
Ruetistrasse 16
8952 Schlieren
+41 44 8306465
E-Mail
COSMO CONSULT Business S.L.
Presidente Riesco 5711, Oficina 802b
Las Condes, Santiago de Chile
+569 73769126
E-Mail
COSMO CONSULT Business S.L.
Avenida Cra. 45 # 114-78, Piso 6
Bogotá - Colombia
+57 320 7935148
E-Mail
COSMO CONSULT Business S.L
Checoslovaquia E10-105 y Eloy Alfaro
Quito, Ecuador
‪+593 99 608 4180
E-Mail
COSMO CONSULT Business S.L.
Rodolfo Gaona 81 Piso 7
Colonia Lomas de Sotelo
México, D.F. 11200
+52 55 2452-9200
E-Mail
Edificio Magel, Segundo Piso
Ave Samuel Lewis, Urb. Obarrio,
Ciudad de Panamá, República de Panamá
+507 62800343
E-Mail