views:

263

answers:

2

How to use DataMining feature of SQL Server 2008 with ASP.Net

+1  A: 

Take a look at SqlServerDataMining.com, a site run by Microsoft's SQL Server Data Mining team.

jeffm
A: 

In a nutshell, you want to:

  • Build cubes to model your data
  • Build a prediction calculator (or whatever kind of calculator you're looking to use)
  • Expose that via a web service
  • Call the web service in your app

For example, if you want to model whether or not a customer is likely to abandon their shopping card, you would figure out what characteristics of a shopper you want to capture and analyze. You set up your cubes to model what characteristics are indicative of a soon-to-be-bailing-out shopper. During the shopping process, your web app would send the shopper's characteristics to the SSAS server, which would return back a guess about whether or not the shopper is going to abandon the cart. Then your web app can take proactive measures before they leave.

All of the steps in here are kinda complicated - your best bet is probably to refine your question to focus on the areas you're responsible for.

Brent Ozar