Audit company (Data Automation)

Audit company (Data Automation)


An audit company was digitizing auditing by automating using data analytics solutions. Due to the nature of the work, the auditors were surrounded by huge pile of data most of the times causing the solution delivery to clients, thereby, affecting the cost to company.


Extracting dataset was a major issue as the auditors dealt with various sources – SAP, NetSuite, CSV, Excel, PDF, Txt, doc, ppt etc. The issue was the storage of this data and generating insights plus automate the who process of it. The major issue at the moment was to extract the data.


The data analyst extracted the data manually for one last time from all the sources to identify the structure of it. Using Alteryx, a macro was created which could extract data from any source which includes flat files, a second connector was created to extract the data from sources like SAP, NetSuite depending on the extension. This helped in automating the first part of the workflow.

Benefits Achieved

  • Extraction of data using one single piece of connector

Process Automation

More Case Studies
Accounting (Data Automation)
Overview: An accounting department of a large organisation had trouble matching the credit and debit data. An accountant was tasked […]
Facility management company (Data Automation)
Overview A facility management company had a system set for reconciliation and account receivables/ payables. The current process is a […]
Healthcare chain on supply chain management (Data automation, visualisation)
Overview The healthcare chain spent about one fourth of their overall operating expenses on the supply chain management. However, it […]
It’s free and easy to post your project

Get your data results fast and accelerate your business performance with the insights you need today.

close icon