Logo - Keyrus
Logo - Keyrus
  • Playbook
  • Services
  • Insights
  • Partners
  • Careers
  • About us
    Company purpose
    Innovation & Technologies
    Committed Keyrus
    Regulatory compliance
    Investors
    Management team
    Brands
    Locations
  • Contact UsJoin us

How can you automate allocation modeling and regulatory reporting in insurance?

100%

Reduction in manual inputs

80

hrs/week saved through process automation

Background

A leading UK insurance company who wished to create a new solution that would allow them to automate an allocation modeling process.

Challenge

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.

Approach

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

Key results

01
Improved the transparency and reliability of the process
02
Reduced the amount of manual intervention required to run the process

Benefits

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.

Technology partners

Alteryx

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. First Alteryx Global Premier Partner.

2019

Partner of the year - North America

120+

expert consultants

8+

years of partnership

Share this key play

whatsapptwitter
linkedinfacebookworkplace

More key plays

How a retail firm saves $30,000 each week with Alteryx for supply chain
Eliminating manual data work with a SaaS data platform
How to improve Snowflake data load times by developing custom Alteryx connectors
Using Alteryx to automate processes at an international bank
Empowering a leading beverage company with self-service analytics
Predict customer churn with artificial intelligence
Consolidate your data assets into a single point of truth
Automating regulatory reporting with self-service analytics
Automating risk management KPIs with advanced analytics
Modernizing investment performance services through data governance
Logo - Keyrus
London

Warnford Court 29 Throgmorton Avenue London EC2N 2AT

Phone:+44 (0)20 3553 4900