Understanding Purchase Patterns Better with Market Basket Analysis

Transformations:
list, nest, unnest, flatten, deduplicate, groupby (aggregate)

This example flow shows how you can do a market basket analysis (also known as an affinity analysis) that’s very common in analytic scenarios in the retail industry. It works by looking at combinations of items that occur together frequently in shopping transactions. It allows a retailer to identify relationships between the items that people buy.

The flow makes extensive use of object and array functions in Trifacta so it can create the object for extracting individual purchased items. You can use this technique for your own basket or affinity analysis use cases.