Data Quality Automation
As brewery instant stock knowledge is key for production and sales decisions. Furthermore, in France, alcoholic beverage support taxes. Hence monthly reports has to be submitted to French Customs.
Objective:
Seamlessly and easily collect stock mouvement.
Model data to required dashboard and French Customs Report.
Result :
~90% of productivity gain.
~99% precision on production cost knowledge which had huge positive impact on EBITDA margin.
Methodology
Data reporting
Created and validated dashboard with French Customs. Set-up xml reporting for EDI transfert.
Data Analysis & Modeling
Analyse production through dashboard and accounting modelization to adapt strategy.
Data Acquisition
Set-up a sharable Google Form and normalized raw data for quality inspection and dashboardboarding
Skills
