Supply chain / logistics

The customer is a beer distributor, with products coming from 30 breweries. There are frequent stock issues because of the lack of information sharing between him, the breweries and the logistics platform.

The goal was to build dashboards to share logistics data between people involded in the project, for example:

• Outdated products in stock
• Products in stocked close to being outdated
• Stock with quality issues
• Returned products
• Daily deliveries / orders

Today, these dashboards are an operational tool for these 3 partners.

This project was achieved by one of our partner, the consulting company Adameo.

One difficulty was the diversity of the information systems to query. Data is coming from the ERP M3 One, from Microsoft Dynamics and from the WMS Locus.

Technically, these imports are done through a SOAP API and from CSV exported to an SFTP server. Then, steps of datapreparation clean and gather this data in the Serenytics internal datawahouse.

Then, dashboards have been created and shared to several users (with different permission). They are mostly showing tables with filters.

One Serenytics strength for this type of project is that it does not increase the workload for any IT team. Everything is available on our platform (the datawahouse, the SFTP server, the dataviz).

The feature to run Python code was also very important to load data from the SOAP API.

The permission settings allow to easily restrict data accesses among users.

And because Serenytics is simple to use, a consultant did the project setup without any difficulty. We only provided support when needed.

You want to know more on this type of project? Contact us at contact@serenytics.com.