AON Human Capital Solutions wanted to streamline production of cutting-edge reporting to ensure their clients continued to receive powerful, trustworthy insights into sales teams’ performance and incentivization.
Reduction in reporting time compared to previous processes
High utility products delivered
From solution ideation to adoption
Ensuring reporting is efficient and future-fit in a fast-changing tech and operating landscape is critical to optimizing operations across organizations. Getting it wrong doesn’t just result in delays, inaccuracies and lost productivity but can cause reputational damage, fines and even legal action.
Kubrick33x reporting time reduction
The challenge
We were challenged to streamline productionization of cutting-edge reporting to help AON Human Capital Solutions provide their clients with powerful, trustworthy insights into sales teams’ performance and recommend effective methods of incentivization.
AON asked us to focus on:
- Reducing reliance on manual data processes resulting in inconsistent analysis across team members and hampering the ability to scale data use.
- Freeing up analysts’ time and effort enabling them to undertake value-add advisory work
- Improving the capability to work with complex data sources and analytics, increasing their ability to remain competitive with their solutions in the short, mid and long-term.
The solution
Harnessing the power of Databricks with AWS and PowerBI, we created a centralized solution to provide enhanced 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
The results
The all-in-one solution has enabled a significant increase in revenue-driving advisory work, creating new opportunities such as a modern subscription-based model for clients. Overall we delivered a 33x+ reduction in reporting run time compared to previous processes, delivered five high utility products covering differing reporting requirements. All in a six-month timeframe.
