This discussion is archived
1 Reply Latest reply: Jan 24, 2013 5:00 AM by 409233 RSS

Market Basket Analysis in Retail

user1299751 Newbie
Currently Being Moderated
Oracle 11g R2.

I have written a script to find out the frequent baskets through DBMS_DATA_MINING.GET_FREQUENT_ITEMSETS.

How can i find the below:

Number of Basket in the selection set for specific FREQUENT ITEM SET.
Sales during the selection period for a specific ITEM SET.
  • 1. Re: Market Basket Analysis in Retail
    409233 Newbie
    Currently Being Moderated
    Neither of these are captured within the associations model.
    The number of baskets in the selection can be computed if you know the number of baskets used to build the model (multiply by support).
    The aggregate information is more complex and would need to be computed by joining back the itemset of interest to the baskets.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points