AON Human Capital Solutions needed to give their clients trustworthy insights into sales teams’ performance and incentivization.
Getting it wrong results in delays, inaccuracies, and loss of productivity causing reputational damage, fines, and legal risks.
- 01
The challenge
The project needed to address immediate issues and set up the company for long-term success:
- Reduce reliance on manual data processes resulting in inconsistent analysis across teams and hampering the ability to scale data use.
- Free up analysts’ time and effort to enable them to undertake valuable advisory work.
- Make it easier to work with complex data sources and analytics to ensure solutions remain competitive.
- 02
The approach
Working with the client’s technology partners: Databricks, AWS, and PowerBI, Kubrick created a centralized solution to provide insights into their client data, including:
- Automated ingestion of data into cloud storage via SFTP.
- Development of Databricks Spark pipelines to load data into Snowflake, operating on a daily refresh via Databricks Workflows.
- Adaptable Power BI reports covering analytics on pay for performance, account sales and market benchmarking.
- 03
The impact
In 6 months, the project delivered five high utility products covering differing reporting requirements, leading to a 33% reduction in reporting run time compared to previous processes.
The all-in-one solution increased revenue-driving advisory work. This created opportunities such as a modern subscription-based model.
Speak to an expert
Find out how we can help your organisation turn data and AI into performance, resilience and growth.
