Picture: VISCONTO GmbH

VISCONTO GmbH

Optimization of the billing process with QlikView

“Our customers have a right to information and we have a duty to deliver it quickly, accurately, and without errors. This is exactly what QlikView allows us to do in a simple fashion without consuming much time.”

Wolfgang Krug, Managing Director, VISCONTO GmbH

Company profile

Visconto is a joint service company of Stadtwerke Ansbach GmbH, Licht- Kraft- und Wasserwerke Kitzingen GmbH, the energy supplier Lohr-Karlstadt and Umgebung GmbH & Co. KG, as well as E-werk Sachsenwald GmbH. They were founded in 2010. VISCONTO employees centrally take care of customer care, billing and data management tasks at the headquarters.

Initial situation

The utility companies need an up-to-date overview of the respective billing situation analogous to the individual deadlines. For this purpose, readout data must be correlated with contract data and evaluated according to various aspects. In addition, the billing service provider runs a call center that handles end-user requests for contracts, prices, current consumption, and more. Here, too, the employees need a quick overview of the respective data in order to provide precise information.

So far, the required data has been retrieved from the SAP® supplier solution implemented by VISCONTO and matched with customer service data to get real, reliable figures. This would take two to three hours and thus clearly too long for the quality requirements of the service providers. A query about the payroll run of all the headquarters for monthly reporting was not possible for performance reasons. To do this, individual queries had to be compiled manually into a complete overview in Excel. This was not only time consuming, but also prone to error.

Solution

COSMO CONSULT BI therefore recommended the company the business discovery solution QlikView. Unlike traditional BI solutions, which are essentially IT-driven, QlikView focusses on the users with its business discovery concept. The solution has an app-like structure and offers the possibility of compiling information according to your needs and sharing it with others. Not only the solution was convincing, but also the integration partner. “COSMO CONSULT really impressed us with its combination of industry expertise and in-depth expertise in SAP® and QlikView,” Krug confirmed. “Despite time consuming authorizations with the responsible SAP® IT service provider, the entire implementation of QlikView took only six weeks. If adaptations of the applications or new developments are necessary, they will be completed by COSMO CONSULT within a very short time.

Areas of use and benefits

The employees are currently evaluating SAP® data from about 200,000 end customer contracts. In addition to analyses of the individual payroll runs per headquarter, overall monthly reports were implemented by which information from other systems is evaluated as well. This includes data from the mySQL database of the telephone system, historical data from Excel, and a system developed by VISCONTO for workflow processes. Subsequently, clear reports including graphics is available within minutes.

“A great load was taken off our minds with QlikView,” concluded Krug. “We are now able to act much faster and in a more targeted fashion in many areas.”

Future

In future, it is planned to train VISCONTO employees to the extent that these tasks can also be assumed internally. In addition, quality assurance and process optimization projects, as well as the German Renewable Energy Act (EEG) topic and the associated messages to the transmission system operators in QlikView are going to be shown.

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