Personalization rather than Association

I'm trying to figure out how to build a personalization engine.

If my structure is built with users as case, and products as nested - I’d like to predict best products per user (rather than associated products), and If possible, ignoring products he already bought.

How do I do it?

After building the Association model with Users as Case, Products as Nested, a Prediction join query on the model with the same dataset as the training case will give you a set of suggested products for every user, ignoring the products he already brought (since they will be part of the input case for each user). This might be what you're looking for.

Please let me know if this does not work for you

|||As Shuvro says, associative prediction is personalization as you need it. If you build an associative model and then perform a prediction based on an individual's product list, you will get the "personalized" list of products for that user by default excluding the items already in the basket.|||

Shuvro

I don't have the DMX skills, yet, to do this directly. Can the same results be achieved using the DM wizard? If not could you please point me to an example of the statement that would be required?

Geoff

|||

Yes, you can get the results using the DM query wizard by joining the model to a case table which contains per user products. Open the "Mining Model Prediction" tab, select the Association model and the Case/Nested table under Input Tables, verify that the column mappings are correct and select the function "PredictAssociation" under Field.

You can also look at the tip posted at http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/1861.aspx for an example on how to perform a DMX query for this scenario.

|||Thank you!