Very user-friendly ETL with mining capabilities. Will save you a lot of time with your data.
Pros
- RapidMiner is really fast at reading all kinds of databases. We read and merge databases like SQL Server, Informix, MySQL, and Oracle. Configuring access is easy, some drivers are inbuilt, but it's not difficult to find new java drivers to allow RapidMiner to connect to other databases.
- Performing all kinds of transformations, calculations (date, percentages...), joins, and filters without coding. We have several different databases and this makes my life a lot easier. Knowing that this part is 80% of analyst work, you know that you can work more on the analyses itself and not on cleaning and preparing data.
- You can clone transformations to reuse on new analyses, so you save a lot of time. There's a lot of add-ons to make different things (text, image analysis, recommender systems, etc).
- Training is easy, the tool is intuitive and there's a lot of videos on the internet. The community is very active.
Cons
- Sharing RapidMiner Studio analysis is not easy. You may think that the RapidMiner Server does that work but no. It's more automated job oriented or useful to run models on a web site. If you need to use it for Business Analytics dashboards, this is not the tool. It's more a backstage tool for analyst. Some charts are good but other not so much.
- The free edition allows you to work with 10,000 rows, but if you need more, it's not cheap (100,000 rows - 2,500 USD/year, 1,000,000 rows - 5,000 USD/year).
- The commercial team is not very reactive. I've asked for a RapidMiner Education Program and Rapidminer Server quotation with no answer. I guess that's because they were changing from an opensource company model to a more commercial one.
Return on Investment
- Very high positive impact because it's very fast to work with data with no coding need. You save a lot of time.
Alternatives Considered
KNIME Analytics Platform, Pentaho and SQL Server Business Intelligence Manager
Other Software Used
TIBCO Spotfire, KNIME Analytics Platform, Pentaho



