Start Free

Speed up your data preparation with Designer Cloud powered by Trifacta

Free Sign Up
 
All Templates

Understanding Purchase Patterns Better with Market Basket Analysis

Market basket analysis Flow The flow view of this template

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.

USE IN TRIFACTA USE IN DATAPREP

New user?

Use the buttons above and start your 30-day free trial. If your data is mostly on Google Cloud Platform, please use Dataprep. Otherwise, choose Trifacta.

Learn more about Dataprep