CLIENT SUCCESS STORY
Industry: Outsourcing/Offshoring Consulting – Travel and Tourism focus
Client Function: Financial, Operations
Introduction
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.
Business Problem
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.
Challenges
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.
Solutions
Pomerol Partners created solutions for both Data Engineering and Data Visualizations. Since they did not have previous solutions in place, we built both from scratch. These solutions are in place and being used today. See examples of these solutions below.
Solution #1: Data Engineering
We created data engineering ELT pipelines to ingest data from the data sources across the different subsidiaries. These pipelines cleaned up and standardized the data across the firms to create a consistent picture across the whole holding group. A data warehouse provides a single location for data across all the subsidiaries in an analytics ready format for use in data visualizations.
Solution #2: Data Visualizations
We created a single financial and operational dashboard that shows all of their businesses consolidated, or just one at a time. By doing so, they are now able to see how the companies are performing, and if they are achieving their goals. The dashboard automates the population of financial reports such as profit and loss and balance statements. It also enables historical trend analysis of revenue, costs, and spend vs budget. We created filtering options, so each executive could select the data points important to them, to derive their own unique conclusions focused on what matters most to them.
Examples:
Balance Sheet
Receivable Aging Report
Fixed Costs
Revenue
About Pomerol
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.