, based in Ireland, is a dedicated Industrial Drives supplier offering a service which can be as simple as identifying and supplying replacement drive components such as Electric Motors, Reduction Gear units, Electronic Motor Controllers and Power Transmission equipment, or assisting in the design, selection and subsequent supply of complete new drives from prime movers to dedicated turnkey control systems. Technidrive supply international manufacturers and OEMs of industrial machinery.
Before Introducing a Power BI Solution
All orders were handled through their accountancy package Sage and excel spreadsheets, however, visibility was poor and it required a lot of manual communication.
The primary issue was this limited visibility. Working from spreadsheets that needed manually updated meant that it wasn’t easy to see when an order was due to be shipped, the order status, who was looking after it and if it had been sent. Sometimes an order delivery date came and went, and nothing was flagged up as a late delivery as the office employees were relying on delivery notes coming back from the warehouse
Allsop developed a solution using Power BI to visually display information relating to Technidrive orders. The Power BI dashboard is connected directly to a Sage database and refreshed every 5 minutes using Power Automate and Power BI Premium capabilities. This allows employees to see data that is current but also data that can change quickly.
The dashboard shows at a quick glance the status of current orders and allows employees to work off this screen, while the report shows the more detailed information relating to orders.