All Case StudiesSupply Chain Analytics

Decision cockpit for PPE dispensers

The data existed. The decisions didn't.

Consumption data from the PPE dispensers already existed, but was scattered across several sources with no real overall view. Spotting an anomaly, anticipating a stockout, or catching a warning sign required repeated manual extracts — slow and unreliable. This cockpit centralizes this real, anonymized data, automatically calculates key indicators, and delivers in seconds what used to take hours of analysis — making it possible to optimize consumption, track dispenser activity, spot trends, and support day-to-day operational decisions.

145,000+

movements analyzed

48

anonymized companies

2022–2025

history covered

100%

real, anonymized data

Try the tool — the demo is interactive

Cockpit Supply Chain — EPI

Données réelles · 48 sociétés anonymisées · Zone/Site non disponibles dans le fichier source

📦

1 207

33%

Sorties totales

👤

131

Utilisateurs actifs

🖥️

4

Distributeurs actifs

📊

402

Moyenne mensuelle

2025 : année en cours (3 mois) — évolution comparée aux mêmes mois de l'année précédente.

Évolution mensuelle

Jan 2025 : 394 sortiesFév 2025 : 446 sortiesMar 2025 : 367 sortiesAvr 2025 : 0 sortiesMai 2025 : 0 sortiesJuin 2025 : 0 sortiesJuil 2025 : 0 sortiesAoût 2025 : 0 sortiesSep 2025 : 0 sortiesOct 2025 : 0 sortiesNov 2025 : 0 sortiesDéc 2025 : 0 sortiesJanFévMarAvrMaiJuinJuilAoûtSepOctNovDéc20252024

Répartition des sorties

Masque Maskline 540 : 124 (10%)Gant Flexium 408 10 : 113 (9%)Gant Nitrilo 639 9 : 104 (9%)Gant Protecta 107 9 : 88 (7%)Masque Airflow 570 : 83 (7%)Autres produits : 695 (58%)1 207sorties
Masque Maskline 54010%
Gant Flexium 408 109%
Gant Nitrilo 639 99%
Gant Protecta 107 97%
Masque Airflow 5707%
Autres produits58%

Top utilisateurs

1Utilisateur 00149
2Utilisateur 00244
3Utilisateur 00342
4Utilisateur 00438
5Utilisateur 00633

Top produits

1Masque Maskline 540124
2Gant Flexium 408 10113
3Gant Nitrilo 639 9104
4Gant Protecta 107 988
5Masque Airflow 57083

Top distributeurs

1VM-002715
2VM-003381
3VM-001103
4VM-0048

Produits — progression & baisse

En progression

Gant Protecta 609 11+13
Gant Protecta 546 11+11
Combinaison Bodyshield 173 5+7
Gant Safegrip 645 T9+5
Masque Purex 514+5

En baisse

Masque Maskline 540108
Lunette Optishield 79473
Gant Handguard 882 973
Gant Flexium 408 1057
Gant Handguard 232 1056

20242025, 3 premiers mois comparés.

Analyse

🏢

Entreprise la + active

Entreprise 01

🖥️

Distributeur le + utilisé

VM-002

📦

Produit le + distribué

Masque Maskline 540

👤

Utilisateur le + actif

Utilisateur 001

📈

Plus forte progression

Gant Protecta 609 11 (+13)

📉

Plus forte baisse

Masque Maskline 540 (−108)

Real, anonymized data, with indicators calculated automatically: the cockpit is fully interactive — switch company or year to explore the results in real time.

01

The problem

Every PPE dispenser produced its own consumption records, with no link between them. Answering a simple question — which product is running low, which site is consuming abnormally, which user is exceeding the norm — meant cross-referencing several files by hand, every single time. Anomalies were often caught too late, once the problem had already taken hold, and decisions relied on one-off extracts rather than a continuous, reliable read of the activity.

02

The solution

The cockpit brings all these movements together in a single interface, where every company, dispenser, and product can be analyzed individually. Key indicators — monthly trends, rankings, products gaining or losing ground — recalculate automatically with every filter change, with sensitive identities (companies, dispensers, users) systematically anonymized. The result: a tool that replaces hours of manual extraction with an immediate, reliable read of activity.

03

How it works

  • Automatic data import
  • All information centralized in a single dashboard
  • Consumption analysis by dispenser, site, user, or period
  • Identification of top-consumed products and the least used ones
  • Trend visualization through interactive charts
  • Dynamic filters for quickly analyzing a specific situation
  • Simple updates as new data becomes available
04

The results

  • Significant time savings on data analysis
  • Immediate, overall view of activity
  • Fast identification of anomalies
  • Optimized replenishment
  • Better stock management
  • Decision support through reliable indicators
05

What this project demonstrates

Data analysisSupply ChainBusiness IntelligenceAdvanced ExcelInteractive dashboardsKPIsData visualizationStock optimizationDecision support

Tools: Power Query · Advanced Excel