Guilherme Ferreira, Strategic Partnership Manager at Alfaloc’s parent company Glaxus, attended one of the Dashboard in a Day workshops our team hosts throughout the year when he learned about PowerBI Robots. Guilherme saw what DevScope’s report automation tool could do and realized that PowerBI Robots’ ability to schedule and send customized Power BI reports could potentially eliminate the need for the company to have someone working long hours issuing and sending internal reports. After some testing, Alfaloc decided to adapt its many Power BI reports to the automation provided by PowerBI Robots.
Automatic shipping and sales reports were Alfaloc’s priorities and PowerBI Robots made these processes much faster: once billing is done, the analytics team only needs to refresh the database and use PowerBI Robots to send the latest report to SharePoint and via email to all recipients who need it.
“Instead of sending individual emails to each user, I only click two buttons: one to update the database, the other to send the reports.”
– Guilherme Ferreira, Strategic Partnership Manager at Glaxus
After dealing with its most pressing needs, the company found other innovative ways to use PowerBI Robots to tackle other problems, such as the automation of their input errors report. When goods are audited, data is entered manually, thus prone to human error. In the past, Alfaloc only detected these errors during billing, which happened only every 15 days, and the company had to send over 200 emails when that happened to find the source of the error. With PowerBI Robots, the auditing team receives an email as soon as errors are detected to correct them, translating to tremendous savings in emails, time, and effort.
Alfaloc is also taking advantage of PowerBI Robots’ audit evidence capabilities in sync with a sales forecast system based on Excel. Whenever data is updated in Excel, it’s also updated in Power BI, and PowerBI Robots saves the report at that point.