JEAN D’ARCEL automates reporting from Qlik Sense with Mail & Deploy
“With Mail & Deploy, we are for the first time able to provide report recipients with the figures that correspond to their information needs. Automatic and up to date. The tool enables us to answer around 90 per cent of inquiries very quickly.”
Head of IT, JEAN D’ARCEL group
The family business JEAN D’ARCEL Cosmétique has stood for high-quality, effective skincare for 60 years, which is designed according to the current state of science and the demands of modern cosmetics users. The distribution is carried out through a wide-ranging partnership network of cosmetic institutes, hotel SPAs and beauty lounges. The JEAN D’ARCEL products are currently available in more than 40 countries. Around 200 employees of the group of companies look after more than 1,300 customers together with the partners.
“Due to the expansion of the corporate group in recent years, the amount of corporate data has grown significantly. We wanted to use the potential of this data better and above all faster, for example for the optimization of processes and business decisions”, explains Stella Weibel, Head of IT at JEAN D’ARCEL GROUP.
“Until now, reporting was characterized by manual and, above all, time-consuming efforts. We wanted to change this with software for automated data analysis and reporting that can directly access Microsoft Dynamics NAV as the central data platform. ”
Qlik Sense as a BI tool, report distribution with Mail & Deploy
The well-known cosmetics manufacturer integrated together with B.i.TEAM the powerful, flexible and user-friendly data analytics software Qlik Sense®. So they got up-to-date and flexible analyses of data from the ERP system and additional XLS files. The analysis results were made available with Mail & Deploy. The reporting extension solution for Qlik Sense® provides various reports to recipients automatically and individually tailored to their respective information needs and authorizations.
Extensive filtering methods and cycle functions make it possible to compile a dynamic number of reports. Qlik-Sense® applications can be adjusted by automatically reloading, reducing or setting variables before generating the report. Reports can also be generated and distributed in various formats (PDF, Excel, PowerPoint, HTML, etc.).
With the integrated option of an FTP upload, reports can be automatically made available on the intranet or Internet. “Above all, the reports look really good – the resolution is very good and the presentation is meaningful. The reports are accordingly understandable for the report recipients”, confirms Stella Weibel.
Daily reports with 80% time-saving
The group of companies benefits from the possibility of automated reporting and distribution from significantly higher transparency. For example, in the past, sales representatives only received a finished report with the relevant figures once at the end of the month. The data is now available every day. In addition, the time required for reporting and distribution was reduced by 80 per cent.
Thanks to our Mail & Deploy Partner B.i.TEAM. They took care of the conception and implementation of the project and have won a new and satisfied Mail & Deploy customer.
Read about the perfect interaction between Qlik Sense® and Mail & Deploy at the Jean D’Arcel Group. You can find the detailed reference story: Jean D’Arcel Use Case by B.i.TEAM (in German)