I used Alteryx Analytics individually for some research that I was doing for one of the data projects that I had. It has an intuitive workflow for data blending and analytics. It makes all the processes much faster compared to what it was before.
Alteryx was surely a better option compared to RapidMiner but when compared against IBM SPSS it is behind for advanced analytical techniques and model scoring, visualization capabilities and neural networks functionalities. SPSS also has a diverse range of analytical techniques and models compared to Alteryx. RapidMiner provides a Studio component for design, a Server component, a Hadoop connector called Radoop and a component for stream processing.
It is well suited where the user likes to write some code from time to time and also in cases where machine learning is required. Alteryx uses R for its machine learning which makes it life easier. Scenarios where maps need to be created for visualization are the examples. It lags a lot compared to other similar softwares for visualization but is very friendly for data analysis.