sql server data mining: Which data mining technique should I use? -- sql server data mining

Which data mining technique should I use?

Glenn Vassallo
6/29/2006 2:32:23 AM

sql server data mining:

I am attempting to utilise data mining in an effort to determine what role
price has played on the consumption of a particular food product.

I have historical data that includes the sales of the product (how much was
consummed), the price of the product (price per a specific weight). I also
have the sales of competitive products and the competitive product price.

What would be the best data mining methodology to use to determine the role
of price on the consumption of this product?

Would it be beneficial to include other dimensional data for example when
holidays occur, as it is likely that there is an increase on certain public
holidays?

Thanks!
Glenn.

RE: Which data mining technique should I use?

jamiemac NO[at]SPAM online.microsoft.com
7/7/2006 5:00:24 PM

This is a typical price-elasticcity problem, even though you want to determine consumption, not price. You need to predict a continuous output using Decision Trees of consumption based on everything else. For price, you need to mark the price as a forced regressor to make sure that the regression formula includes price. FORCE_REGRESSOR is a model parameter available when you right click the model and choose "Set Parameters" in the mining model pane of the data mining designer.

-Jamie

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server data mining group.