Logo de la société
Boehringer

Ensuring the quality of the annual balance sheet of sales to veterinary economic interest groups.

Ensuring the quality of the annual balance sheet of sales to veterinary economic interest groups.

Logo de la société
Logo de la société
  • 1
  • annual review
  • 15.000
  • veterinary clinics
  • 30
  • GIE

Context

The Animal Health department needs to produce an annual review of its sales and relations with the veterinary EIGs that buy from Boehringer. They work with 15,000 veterinary clinics and 30 MSEs. Problems encountered each year: Very different file formats that are difficult to use as they are No or few common reference systems between the EIGs. Even the most obvious identifiers (structure name) are not common. A lot of time is spent for a result that is qualitatively unsatisfactory

Need

Group veterinary clinics into EIGs, commercial contracts based on consolidated turnover and calculation/payment of individual rebates. It is essential to identify which clinics belong to which EIG! Lists of members (GIE) to be reconciled with our customer database.

How did Adobis Group

DataChain® allowed to build :
  • A working method and analysis elements
  • Processing chains for GIE files
  • Identification of the best reconciliation keys (GIE ERP base)
  • Enrichment of the customer file (SIRET, SIREN, other codifications)

Results

Operations :
  • Time saved and shorter lead times
  • FTE workload divided by 20
  • 95% of perimeters integrated in 1 month
  • Very satisfactory qualitative gains
  • Improved image of the department, both internally and with customers
  • Acquisition of directly usable files
  • Very good feedback following an internal audit
  • 1

Before

20 people over 2 months

Many incidents/errors

Complicated identification of remaining rejects

A lot of laborious file handling

After

3 people over 3 weeks

Over 85% reduction in incidents/errors

Simple identification of remaining rejects

Greater convenience: virtually no more laborious file handling

  • "Before DataChain®, our data reconciliation process was a real headache. We would spend weeks compiling and analysing files from different sources, with a high margin of error and endless delays. Within the first year of working with DataChain®, we were able to build a working method tailored to our needs and automate a large part of our data processing. Identifying reconciliation keys and enriching our customer file were pivotal steps in improving the quality of our data. We have seen the tangible benefits of DataChain®. The time saved is phenomenal: we went from 20 people working for over 2 months to just 3 people over 3 weeks! This represents a 20-fold reduction in workload. What's more, data quality has improved considerably, with a reduction in incidents of over 85%. We have also gained in comfort and brand image. To sum up, DataChain® has enabled us to: Increase efficiency and productivity. Improve the quality of our data. Reduce errors and processing times. Increase the satisfaction of our teams. We are extremely satisfied with DataChain® and highly recommend it for any optimisation of data management."
  • Pascal Dubois
  • Rp. CRM and Strat. Customer FR at Boehringer

Our other case studies

Logo de la société
Logo de la société
  • "I was positively surprised by DataChain®'s ability to automate data processing. The data analytics, data visualization and data science functionalities offer vast possibilities."
  • XAVIER QUILLIET
  • CIO | Ayming
See case study
Logo de la société
Logo de la société
  • DataChain® was selected by the State of Geneva in a call for tenders named “Data Virtualisation platform”
See case study