1 Reply Latest reply on Jan 24, 2013 1:00 PM by 409233

    Market Basket Analysis in Retail

      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
          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.