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
Répartition des sorties
Top utilisateurs
Top produits
Top distributeurs
Produits — progression & baisse
En progression
En baisse
2024 → 2025, 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.
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.
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.
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
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
What this project demonstrates
Tools: Power Query · Advanced Excel
