Overall Satisfaction with Alteryx Analytics
Alteryx use began in the marketing department to help automate data prep pre-Tableau from data sourced from Salesforce. It is now also being used by the IT department to help join multiple data sources to automate data munging for some standard report generation. The primary business problem Alteryx helps our team with is helping analyst move much more quickly by building data workflows visually instead of creating hundreds to thousands of lines of code to move and prep the same data.
- Data ingestion: Alteryx is capable of connecting with a multitude of data sources from SQL databases to cloud-hosted solutions like Salesforce, Tableau, or Google Analytics. Also supports OleDB & ODBC connections.
- Dynamic data munging: Alteryx has a great variety of processing tools to clean and prep data including: dedupe, formulas, joins, union, sort... Performing these functions really quickly on even moderately equipped laptops or desktops. It's dynamic in that it can easily handle changes in data by allowing extra columns to flow through.
- Macros: have a process that you are consistently running in separate workflows? Build a macro, be it a batch or iterative, Alteryx can do it. I've built 40-50 macros and use at least 4+ in every workflow I design so data is handled the same way in every workflow for consistency and cutting down on copy/pastes.
- I've had issues with the scheduler tool getting frozen or stuck in previous versions. For about the last 2-3 months the latest software version has been much more reliable. Previously I had to restart the Alteryx service on my machine at least once a week, which meant my workflows weren't running while the service had been stuck and data wasn't moving.
- Some of the connectors, like the Tableau Online connector, should become supported by Alteryx. The online community is fantastic and has created a ton of useful macros and it would be great if Alteryx would adopt, support, and enhance some of the most widely used and useful.
Alteryx's UI is fantastic insomuch that training can really be self-driven, albeit with several Google searches a day and visits to the Alteryx community. The other solutions we looked at were much less intuitive and not nearly as flexible, automated, and didn't give you the capability to watch the data be changed through every step of the process like Alteryx can do through browses and data samples.