Optimizing Basket Analysis

Basket Analysis is the analysis of sales by basket (or transaction). It can be useful in understanding questions such as

• What is the total value of sales for transactions that include products x (and y, and z...)?
• What is the average transaction value for transactions that include products x (and y, and z...)?
• What proportion of transactions include products x (or y or z)? And what proportion of transactions that include products a (and b, and c...) also include products x (and y, and z...)?
• How did the attach rate of product x change during the sales promotion series? And was there a lasting effect.
• etc. etc.

Traditionally basket analysis has been achieved by running SQL queries on very large, highly scalable, databases that dynamically summarize by transaction id.

Read more...