Trifacta wins the Best Data-Driven SaaS Product award at the 2021 Annual Cloud & SaaS Awards

Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Summer of SQL

A Q&A Series with Joe Hellerstein

See why SQL is Back
All Templates

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?

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