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

A six hours project to automate data quality checks for client reporting

4

hrs / day saved for client reporting team

100,000+

£ saved in financial penalties

Background

Keyrus was asked to help a financial services client reporting team, who were tasked with creating daily reports for their clients. These reports must meet certain pre-agreed standards and there are financial penalties in place if the standards are not met.

Challenge

The previous approach involved analysts manually checking in Excel. This meant it was not only time consuming but also prone to human error. A solution was needed to be developed to replace the manual process of checking, which in one day had missed a series of issues that racked up to a fine of hundreds of thousands of dollars.

Approach

Despite the repetitive nature of these daily checks and reports, it took two analysts over two hours each day to ensure data quality measures were sufficient for the reports, as new data was inputted daily. Given this structure and well-documented process, Keyrus felt that this was a perfect challenge for Alteryx. It took just six hours in total for Keyrus to understand the requirements, build an Alteryx app, and present back to the team.

Key results

01
Reduced daily time to perform checks by over 85%
02
Eliminated any human error in the checking process
03
No further fines for data quality issues

Benefits

Consistent data quality checks performed by the Alteryx app has reduced the overall time needed for these tasks and has stopped fines for missed data quality checks since its inception.

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