Data Engineering Template:

Understanding Purchase Patterns Better with Market Basket Analysis

Market basket analysis Flow The flow view of this template

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.

New user?

If your data is mostly on Google Cloud Platform, please use Dataprep. Otherwise, choose Designer Cloud.

Use in Designer Cloud Use in Dataprep