Re: Analysis Services and creating a market basket analysis
Date: July 09, 2013 02:39PM
Hi,
An association rule mining algorithm will find association between groups of items occuring in a transaction transaction database, where a transaction is a set of items. Each item can be either present or absent (0 or 1).
In your table, the products are represented as binary values which is good.
For the other columns, the data is not binary. If you want to include these columns in the associations that you want to discover, then you would need to convert them to binary or to use an association rule mining algorithm that accept non binary attributes (there probably exists some). Or you could just ignore them. It depends on what you want to do with the patterns.
Hope this helps a little bit,
Philippe