Alteryx
Case Studies
Streamlining Transaction Matching in Large Datasets
Overview
Streamlining Transaction Matching in Large DatasetsAlteryx |
Analytics & Modeling - Big Data Analytics Analytics & Modeling - Data-as-a-Service | |
Equipment & Machinery Finance & Insurance | |
Sales & Marketing | |
Machine to Machine Payments | |
Operational Impact
The solution provided a significant improvement in the efficiency and accuracy of the transaction matching process. It eliminated the need for manual matching of transactions, which was time-consuming and prone to errors. The solution also allowed for the analysis of the entire dataset of 24 million rows of data, rather than just a piece of it, improving the completeness of the task. Furthermore, the solution was able to handle the large dataset in a single file that could be opened on a basic corporate machine, making it more accessible and easier to manage. The solution also reduced the risk of human error, such as forgetting to delete a transaction from one dataset or accidentally pasting a transaction multiple times in a separate dataset. Overall, the solution significantly streamlined the transaction matching process, making it faster, more accurate, and more efficient. | |
Quantitative Benefit
The workflow ran in less than 6 minutes with only 8GB of memory. | |
The solution was able to handle 24 million records of data in a single file. | |
The solution eliminated the need for manual matching of transactions, saving significant time and reducing the risk of errors. | |