Showcase your achievements in the Maveryx Community by submitting a Success Story now!
SUBMISSION INSTRUCTIONSWe pay and file employment related taxes and tax returns for approximately 500,000 employers across the country. Including local municipalities, this accounts for thousands of tax agencies. Each agency can assign their own tax ID number. Using this tax ID number when making payments and filing returns is essential to employers' accounts being properly credited and kept in good standing with the taxing authorities. It is imperative to identify our clients with missing tax ID numbers, and send correspondence to our branch locations so they can obtain and enter the proper tax ID number for each taxing agency.
With data being stored in clustered environments, hours were being spent sorting through several reports (one per cluster) that identified clients with missing tax IDs. More hours were then spent splitting these clients out into separate spreadsheets based on our locations that serviced them. And then even more hours were spent compiling and emailing these spreadsheets out to the various locations.
Create a repeatable app that can be run on-demand by the applicable business unit via Alteryx Gallery. The app would require no inputs (parameters) other than the “push of a button”.
THE MODULE
Step I
Step II
Step III
Step IV
THE APP
The process that once took about 5 hours to complete, now takes about 20 seconds from start (compiling the reports) to finish (emailing every effected location with a list of their missing tax ID clients). The app has eliminated all manual work involved with the process and can be run on-demand by the business unit.
I like the way you documented the solution. Thanks for sharing your use case.
You're welcome @papalow - glad you enjoyed it!