leading multinational home appliance manufacturer with headquarters in Europe.
European country branch: 120 points of sales, 8 regional partners
500 sales data points weekly
Tools: Emails, Google Forms, Google Sheets, Excel, Ambassador Web-portal
Business operations team: 3 FTEs
1 FTE is solely dedicated to manual data requests, obtaining and summarizing sales data.
Weeks were wasted receiving and preparing clean data for monthly sales reporting.
Poor computer skills of sales representatives and distributors. Some can't use web tools to submit data.
Low data quality, need to request updates manually.
Manual analysis. Can’t perform online analysis