One of the largest private equity firms headquartered in the UK acquired portfolio companies in the business of managing warehouses for elite people across the US and Europe. The private equity firm wanted to evaluate overall performance of all acquired portfolio companies with the intention to optimize processes and facilitate growth. To achieve this goal, they envisioned building analytical solutions of a unified data warehouse that aggregates diverse data from all portfolio companies, with the objective of developing dashboards and reports.Deploying and configuring client and server agents to all portfolio companies. Client agents fetch diverse data from sources and transfer it to the data lake. The server agent then initiates the data pipeline to ingest data into the data warehouse.