Consolidating Financials for Multiple Acquisitions

This Holding Company offers various services related to travel, business, and government. It is the mother company of various subsidiaries and affiliates with an almost 2,000 strong workforce. To continue to grow the business, management needed an accurate and timely picture of finance and operations across all their subsidiaries. They needed experts in analytics to modernize their data to give them the visibility they required.

Up until now, they did not have a system for managing data from all their businesses in one place.

The group wanted consolidated views of the financial position of all their subsidiaries in a single dashboard, where they could see profit and loss, balance statements, etc. at an individual and a full group level. Currently, their businesses executives did not have a clear picture of the business challenges, pain points and wins of all their investments in one place. They were also unable to see level of profit, and how much they would get at the end of the year, without time intensive manual efforts.

The biggest challenge was to harmonize data from 5-10 companies. As is common with acquired companies, they all did not share the same data source. Additionally, the data quality was not standard across the board.

The acquisitions are varied businesses (such as IT consultancies, airport security, contact centers, corporate cleaning services, etc.) so the data types were varied as well, yet needed to be streamlined.

Lastly, in order to harmonize everything into a single visualization (like the P&L), the executives also had to agree on what they wanted to see on both a consolidated and individual view per company.

Pomerol Partners creates and delivers meaningful, business-focused data solutions. We are not general technologists; we specialize in data and data-driven projects. Our team of consultants and data engineers have a depth of experience across the full analytics supply chain –  from initial data extract, through transformation and modelling, to dashboarding and operational alerting, and, onward to machine learning and predictive analytics. We also integrate data into customer facing portals. We work in a wide range of industries across a wide range of business functions including sales, operations, finance, manufacturing, marketing, and, more. Our clients include the Fortune 100 to 100 employee companies.

Our consultants are in Australia, United States, United Kingdom, and Portugal.