Basket Analysis

Best Answers

• Options

  jacobcybulski Member, University Professor Posts: 391 Unicorn

  January 2021 Solution Accepted

  You will need to define your "basket" first! Is it a month in a given year? Or, is the same month in 2019 and 2020 different baskets? Or perhaps, a basket are all products purchased by a customer in different months? There are many more possibilities of course, it all depends on your problem. Once you know what is your basket, you can then aggregate your sales into such basket-groups and apply the association analysis. 

  0
• Options

  jacobcybulski Member, University Professor Posts: 391 Unicorn

  January 2021 Solution Accepted

  In this case you already have the representation suitable for market basket analysis.
  
  Now we have two choices depending on your business objective. One to aggregate and perform the analysis of all transactions month-by-month, if your question is to do with demand on your products (what products are being ordered monthly). The second is to perform market basket analysis month-by-month, if your question is to do with giving recommendation to customers for purchasing additional products in a given month (what products may be suitable in a given month). I assume the latter fits better the purpose of market basket analysis. 
  
  In the latter case, what is needed is to filter all transactions for a specific month irrespectively of year, day or time. To do this you may need to replace your date-time with its month component using Date to Numerical operator, and then use Filter Examples for each month 1 (Jan), 2 (Feb), ..., as required, before undertaking the FP Growth and Association Analysis. It seems like a lot of work but you will be able to extract the MBA rules of use to the company month-to-moth marketing of products. You may find that in some months, depending on your support and confidence, you will get only a few rules (e.g. during the summer holidays) and in other months lots of rules (e.g. around Christmas time). If monthly analysis seems like a lot of hard work (12 separate MBA analysis sessions), you can use a quarterly MBA analysis.
  

  1