Home All Groups Group Topic Archive Search About
Author
11 Aug 2006 2:31 PM
Andy
Sorry of this is an odd question, but I’m trying to see if SQL Server
Analysis Services can help us out.

Basically we want to recommend products to customers based on
Three random titles that they have rated highly themselves in the last 3
months
Using these 3 titles,
Look at others customers who also rated these 3 titles highly, and then
provide some more recommendations (that they haven’t already bought).

Not rocket science, but quite involved nevertheless.

We’re currently doing lots of number crunching, but is this something that
we should be turning to SSIS for? We haven’t used SSIS before so I don’t want
to spend time looking into it if it’s not really what it’s for..

Many thanks,
Andy

Author
11 Aug 2006 2:59 PM
David Browne
Show quote
"Andy" <A***@discussions.microsoft.com> wrote in message
news:93611D96-2748-4EC6-8926-91FB12F42CC2@microsoft.com...
> Sorry of this is an odd question, but I'm trying to see if SQL Server
> Analysis Services can help us out.
>
> Basically we want to recommend products to customers based on
> Three random titles that they have rated highly themselves in the last 3
> months
> Using these 3 titles,
> Look at others customers who also rated these 3 titles highly, and then
> provide some more recommendations (that they haven't already bought).
>
> Not rocket science, but quite involved nevertheless.
>
> We're currently doing lots of number crunching, but is this something that
> we should be turning to SSIS for? We haven't used SSIS before so I don't
> want
> to spend time looking into it if it's not really what it's for..
>

This is a common Data Mining task.

SQL Server Analysis Services (SSAS) has Data Mining.

http://www.microsoft.com/sql/technologies/dm/default.mspx


David
Author
11 Aug 2006 3:51 PM
Andy
Many thanks.

AddThis Social Bookmark Button