Acterys combined with Microsoft Azure and Microsoft Power BI delivers financial analytics and consolidation for 30 Worms Safety group companies

Building advantage through consolidation

Worms Safety is a leading global alliance of specialist companies with expert knowledge of regulatory compliance, safety, and quality. It is focused on helping clients meet their compliance goals, exploit business potential, explore new quality growth opportunities, and develop an essential competitive advantage.

Following the company’s introduction of a new Xero financial management system, it sought a solution that would automate consolidation for 30 group companies and improve management reporting with interactive dashboard capabilities. After an extensive evaluation phase, Worms Safety chose Acterys based on its proven track record, Acterys’ ability to completely automate the process, and the integration with market-leading Azure SQL Server and Power BI.

Acterys quickly brings it all together

Within a day, an initial solution that consolidated all companies was live. Shortly after, a comprehensive solution with interactive dashboards and specialized reports that Worms Safety required was in place. The ease of Acterys enables the Worms Safety team to maintain and modify their data models themselves instead of relying on outside help. The handling of accounting mappings, new scenarios, calculation metrics, and more is now tailored exactly to their needs.

The new solution saved Worms Safety 10 days of work spent on manual spreadsheet maintenance a month, and it significantly improved analysis options in Power BI with:

•    Consolidated views across companies and segments

•    Cash flow and accounts receivables simulation

•    Ability to drill down to transaction level

•    Interactive visualizations of KPIs and financial results

“We couldn’t believe that within only one day Acterys enabled us to have an initial consolidation of 30 companies,” said Antoine Meunier, Worms Safety head of investment team. “We have the same flexibility for reporting in Excel, but all data is automatically updated from the central data mart for all companies. Power BI is seamlessly integrated with the solution and provides us now with enormously improved insights and visualization.”