The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Basket Analysis
Hello
I'm trying to do some exercises on Market Basket Analysis, but I couldn't figure out how to analyze the products per month (seasonal analyzing). Maybe someone can help on this.
Thanks, Anoon
Tagged:
0
Best Answers
-
jacobcybulski Member, University Professor Posts: 391 UnicornYou 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
-
jacobcybulski Member, University Professor Posts: 391 UnicornIn 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
Answers