Data Mining - Mining

Question

We are looking at the acquisition of Data Mining software in order to primarily run the mining processes.

How does SQL Server Data Mining compare with other solutions like IBM SPSS?

Since SQL Server DM is included in the SQL Server Enterprise license - what would be the excuse to spend an extra couple of 100K to buy separate software just to make a DM?

Answer 1

Depending on what you want to accomplish, and obviously your budget, there is certainly something wonderful in R. Check out Rattle for R and Revolution Computing.

I am a big fan of SPSS and, unfortunately, have not used their Modeler package, but it seems worth considering. I used SAS Enterprise Miner, and although it is powerful, I am not a big fan.

I didn't do much with Weka, but I found that RapidMiner has a steep learning curve, but it has a lot of features.

Answer 2

I will also consider open source options, including R, RapidMiner, Weka

I would recommend checking out the Rexer poll as it shows popularity and satisfaction metrics for various data mining products:

http://www.kdnuggets.com/2010/03/f-annual-rexer-analytics-data-miner-survey-results.html

Answer 3

If you want to keep everything on the Microsoft stack, visit www.predixionsoftware.com, which plans to release the corrupted Excel add-in as an update to existing MS DM add-ons.

Answer 4

You might want to give KNIME a try before paying for something else. Works well with databases and is great for research analysis.

Answer 5

I would suggest checking out the open source data mining software. There are very good open source programs that are free.

Answer 6

I would start by creating some data mining models in SSAS using both multidimensional and tabular, and then get an account for Google Analytics. I created a social networking site that was created when members had to join Google Analytics and use Google Analytics to create dashboards and probably built about a thousand. A good starting point, R is good, Omni used to be a top dawg, but Adobe bought them, clicks, viewing quilk, Sisense, Tableau, Actuate, however I would wait and see how the Microsoft product is released. Most likely, he will leave, as in the BI market, and reached the 2nd in the market share and the 1st in growth in the database market.