Witty Trade is a major electronics distributor, with revenues in the order of billions of crowns. It supplies its goods, which cover many brands – Xiaomi, Amazfit, Cubot and others – to practically all electronics retailers in the Czech Republic, and also operates its own e-shop.
In this segment it is vital to ensure that your commercial partners receive perfect service and reliable deliveries. Companies such as Alza, OK, Vodafone or Globus don’t tolerate gaps in deliveries – while at the same time, you can’t buy more warehouse stock than you’ll sell because unsold stock would make your goods more expensive and make you uncompetitive.
To allow Witty Trade to estimate future demand and order goods accordingly, it works with sales reports that its partners regularly e-mail to it.
These reports are different for every partner, and most are generated automatically, although a minority of partners create them manually, and they are usually sent as e-mail attachments in XLS, CSV or PDF format.
Witty Trade used to process these reports manually, and from this would create a complete report on all products that allowed it to determine the turnover rate of individual products and make a limited estimate of how much of which product would have to be ordered additionally.
The creation of these reports resulted in errors and was fairly labour-intensive due to the differing formats and data used (e.g. vendor’s internal ID rather than the product ID, etc.). Realistically, this activity would take up half the working hours of the employee assigned to the task.
Furthermore, the report was only updated once per week, even where continually updated data was available. Additionally, only one report was available, even though Witty Trade has several product managers responsible for various product series and customers, and therefore primarily need to see their own data.
To find a solution to all these problems, Witty Trade consulted Revolt BI. We adopted a comprehensive approach to the issue and created a completely new system with many advantages:
The data obtained allowed us to create many useful Tableau reports that help Witty Trade achieve better commercial results and a higher degree of client satisfaction.
Are you troubled by data, processes or the entire analytical environment?
We’re here for you.