Reduction in manual inputs
hrs/week saved through process automation
A leading UK insurance company who wished to create a new solution that would allow them to automate an allocation modeling process.
Historically, this allocation process was run using a series of SQL scripts which were created and operated by an analyst. Over time, this process had become complex and unwieldy, and required the regulatory reporting team to work closely with this analyst to generate their quarterly returns.
To create a more robust and transparent process, and to bring the control of the modeling into the remit of the regulatory reporting team, Keyrus made the decision to rebuild the process using Alteryx. Due to the very large data volumes, Power BI was also used to allow users to examine the results of the allocation in detail (visualization). Keyrus was able to automate the following stages of the modelling process: • Data cleansing according to many pre-defined business rules • User-defined manual replacements of invalid data • Allocation of modelled data with multiple allocation approaches • Preparation of CSV files for direct submission to the regulator
The allocation model process is now fully owned by the regulatory reporting team, reducing their dependency on other teams and improving time spent on quarterly returns. The visual Alteryx Designer interface can now be used to easily explain the flow of data throughout the complex process. Collaboration between the client and Keyrus consultants has resulted in a streamlined and more robust process, which requires less manual input and fewer iterations to complete. End users can now access and run the allocation model process directly via the self-service Alteryx Gallery apps.
Alteryx automates analytics, data science, and processes in one unified platform to accelerate digital transformation. Organizations rely on Alteryx to rapidly upskill their workforces and deliver strategic, high-impact, business outcomes.
120+
certified consultants
8+
years of partnership