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

Social Network Analysis with SQL Server 2005 Data Mining

A few years ago John Hancock spent some time with our team and did some interesting work around using the Association Rules algorithm and some custom Analysis Services stored procedures to implement link analysis (a.k.a. social network analysis).  His implementaion was extremely novel, and the product team (self included) was duly impressed by what John…


Predicting based on rules alone and getting everything you always wanted

In this post I explained how to couch an associative prediction that omitted predictions that were based solely on marginal statistics.  The one catch was that if you asked for 5 items, you might not get 5, you could get 4 or 3 or even down to 0, since all predictions without a corresponding prediction node…

1

Predict based on rules alone

I’ve been asked this question a few times and never thought of an answer until I was asked again today on the data mining newsgroups.  We’ll be posting a tip or trick on sqlserverdatamining.com on this, but since it’s fresh in my mind I’ll let everyone have it now. The problem that some people are having…

1