Witty Trade is a major electronics distributor with a turnover in the billions of crowns. It supplies its stock of many brands - Xiaomi, Amazfit, Cubot, and others - to practically all the electronics retailers in the countr, while also operating its own eshop.
In the consumer electronics segment, it is crucial to provide ibusiness partners with perfect service and delivery reliability. Companies such as Alza, OK, Vodafone or Globus will not tolerate any disruptions with deliveries, but at the same time you cannot afford to buy more stock than you can quickly ship, since unsold stock makes your goods more expensive and your firm uncompetitive.
In order to estimate future demands and order goods accordingly, Witty Trade works with sales reports that their partners send them regularly by email.
These reports vary by each partner, most of which are handled automatically, while a smaller number of partners create them manually, usually in email attachments, typically as XLS, CSV or PDF.
Reports from vendors contain basically 3 important pieces of data:
Witty Trade used to manually process these reports and create a complete report of all products, from which we could determine the turnover of each product and make a limited estimate of how much to reorder.
The creation of these reports was subject to errors and quite laborious due to the different data formats and labels (e.g., using an internal vendor ID instead of a product ID). In practice, this activity took up half the time of a dedicated staff member.
Worse, the report was updated only once per week, even where continuous data was available, and only 1 type of report was generated with an overall view, even though Witty Trade has several product lines with their own managers who primarily just need to see their own product movements and customer behavior.
To solve all of these issues, Witty Trade turned to Revolt BI. We took a holistic approach and created an entirely new system with a multitude of benefits:
From the data we collected, we were able to prepare many useful Tableau reports that help Witty Trade achieve better business results and higher satisfaction with their customers.