Our client wanted to assimilate data from companies across their portfolio to create a centralised hub where advanced analytics and machine learning models could be applied to the consolidated data.
We were required to build out the data hub and begin to generate insights that could be leveraged by the individual portfolio companies and the wider group.
What we did
✔︎ Extracted, cleansed and standardised subsidiary company data into a central repository
✔︎ Enriched the repository with open datasets to provide a richer view of customer coverage across the portfolio
✔︎ Delivered two machine learning models focused on identifying cross-selling opportunities and credit risk scoring
rows of data across 6 portfolio companies used to generate cross portfolio insights.
How we did it
We worked with a small team who serve the two sides of the business: private equity and lending. They wanted to better understand their customer base and coverage across the UK, and use machine learning to explore use cases around credit scoring, risk management, fraud detection and price optimisation. In order to deliver such projects, we need to create a central data repository and onboard analysts within the company who could deliver future projects.
To achieve this, we built a ring-fenced Azure environment closely tied to the existing infrastructure where the raw data is stored as flat files in Azure blob storage, and ETL pipelines created in Azure Data Factory to move the datasets into a SQL Server database. The infrastructure and pipelines were thoroughly documented and presented back to the client in an on-site workshop.
After sourcing and loading data into the environment, we built and tested a cross-selling propensity model and an enhanced credit-scoring model, handing over reproducible code and whitepaper reports to internal stakeholders. The company is now able to rapidly iterate on analytical ideas and is at the forefront of technological innovation.
ADSP were able to quickly evaluate and integrate data from multiple sources, with minimal demand on the portfolio businesses. Their machine learning expertise enabled them to rapidly complete multiple proof-of-concepts, ensuring the wider group project could proceed at pace, and prove the value of the combined data sets.
Alison Collins, Private Equity Director
Download our case study
Start a conversation
Take the first step by speaking with one of our data experts today.