This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I know this isn't a workflow question but.. What is the benefit of Alteryx over Access? My manager is challenging Alteryx saying that he can run a million row Item in almost the same time as alteryx in Access. How do I prove him wrong and show him the true benefit of my Alteryx over Access with Facts?
You could tell him that Alteryx has no limit on the records.
Also the chance of typing some SQL formula wrong is impossible given that you don't need to type the commands, just use the tools. You can also check the results after every tool which helps you in case there was a mistake on some part to correct it easily.
You could also enable performance profiling just to give him real numbers and showing him the time alteryx needs to process the data. To enable it go to your workflow canvas, then on the right configuration window go to 'Runtime' and activate the last checkbox.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In addition to the above, I'd would add that our first use case with Alteryx involved a process originally designed in access.
The original process took over two hours to load data, modify and run multiple queries, and then get an output.
in Alteryx that process now runs in less than 5 minutes and does additional error checks and outputs to multiple formats including a tableau server.
Oh, and the original process was two separate access dB due to table size.
outside of processing, to me the speed is also in development and then additional analytic capabilities The possibilities are endless with what you can accomplish. Web scraping, api downloads, python code, predictive analytics, the list goes on and on...