Challenge
Even before the pandemic struck, CEO Calvin Guyer was working both offsite and onsite, and he’d found the company’s data source, Sage 100, was easier to manipulate onsite than off. Therefore, when he wanted to get information out of it while working from home, he would typically download data into a spreadsheet and then use pivot tables and other utilities. Not only was this time consuming, when the pandemic hit which forced him offsite even more frequently, the process became more and more inefficient.
The company deployed Power BI and started looking for online data warehousing products, favoring the idea of automation of connections and flexibility. The need to update manually had to go, particularly when accessed through a slow VPN, and the case for a cloud solution had become obvious.
It was at this stage that Guyer stumbled across Sage Data & Analytics.
Solution
Sage Data & Analytics appealed to him immediately because it instantly got rid of manual elements and had analytical capabilities without the need for extra coding and development. QualiTru is a family business (although Guyer is not part of the family) so the ability to update the dashboard and provide the family and other directors access to vital data about their business in real-time was key.
Another benefit was the accuracy of the data, said Guyer. “Data in Sage gets a little dirty; there’s full stops, commas, mis-spelled names and other messy things.” However, thanks to the connector built into Sage Data & Analytics which enabled the data to be consistent, due to it being entered once rather than multiple times, the scope for human error was all but eliminated.
The business has seen a significant improvement as a result of implementing the new system. “We were never really tracking this detail of data before – when we made sales, who we sold to, when they would be likely to buy again and what markets we were in,” said Guyer. In fact that was only the start; the company wasn’t looking at what it had sold to particular clients the previous year either, but it now has a better defined budget cycle based on facts.
But this is only the start; QualiTru is able to apply analytics and forecasting to individual products and is looking at new markets and goal-setting for 2022. It’s going to be based on solid data and facts about the company’s performance – and this is thanks to deploying Sage Data & Analytics.
Outcome
- Out-of-the-box data on cash conversion cycle, days of inventory and a great many other business elements for better insight
- Access to close-to-real-time reporting for family, directors and other stakeholders
- Ability to forecast more confidently and make substantiated plans for business development
“Thanks to Sage Data & Analytics, I’m now relieved of a lot of my ongoing reporting requirements to the board as they can simply go and view it themselves in the system real-time as and when they need to.”