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

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

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.

Share this key play