Getting Data Mining results into SQL Tables

I’ve been seeing lots of questions about how to get data mining results into SQL tables.  Most times the answers are “use the prediction query builder save button” or “build an SSIS package.”  Both of these have issues among them being that the former is really only suited to single-use, small jobs, and the latter…

1

How can we mine? Let me count the ways…

Recently I received some customer feedback that SQL Server Data Mining "doesn’t have enough algorithms."  More specifically, the comment was that we have the same capabilities are other Data Mining providers, we just "hide" many facilities as algorithm parameters rather than separating out each as a named algorithm.  So let’s count the Microsoft algorithms a…

1

Automatically Label Clusters using Analysis Services Stored Procedures

I just found this awesome posting on CodePlex by furmangg to automatically label the clusters generated by the clustering algorithm.  It examines the cluster content to generate human-readable descriptions and then changes the labels appropriately.  Check it out – it might just save you a bunch of time figuring out what all the clusters mean.


Wisconsin Breast Cancer Dataset available

Frequently I use the Wisconsin Breast Cancer Dataset for demonstrating the Data Mining Addins for Office – enough people asked, so I made it available as an Excel 2007 file (free login required).  For purists, the original data is available at the Machine Learning repository, which is a great location for many sample datasets. Here are some screenshots…