Adobe Stock 231915693

Hamelin Group

Report sell out selection of management tools

Hamelin Group

The Hamelin Group is a family business of French origin, leader in the school and office supplies market.

It distributes its products through well-known brands such as Oxford, Elba, Unilux and Enri, among others. Globally, it has 2,400 employees in 19 different countries and a turnover of more than €400M.

  • Aim of the project:

The fundamental objective of the Hamelin Group in this project focuses on obtaining homogeneous information from the sell out reports received from different clients in Spain and Portugal, and making a commercial scorecard from this.

  • Work done:

From the Data Analytics team we have planned the project in two distinct phases:

  • Phase I: homogenisation of the information received from the different clients. This information is received in a totally different way, both in terms of file format and file structure. Phase I was therefore a challenge insofar as a common database had to be generated from totally different sources of information.
  • Phase II: preparation of the commercial dashboard itself, the biggest challenge of which was to tackle, in the same dashboard, a very executive vision together with another totally detailed one (going as far as point-by-point analysis).
Do you have any questions?
Baker Tilly newsletter
Find out about the latest developments that could affect your business
Subscribe here