DAX Patterns: Basket analysis

These are in-depth video lectures of the Basket analysis pattern.

The goal of basket analysis is to analyze relationships between events. A typical example is to analyze which products are frequently purchased together. This means they are in the same “basket”, hence the name of this pattern. Two products are related when they are present in the same basket. In other words, the event granularity is the purchase of a product. The basket can be the most intuitive, like a sales order; but the basket can also be a customer; In that case, products are related if they are purchased by the same customer, albeit across different orders.

Collapse allCurriculum

  • Basket analysis

    • About the Basket analysis pattern
    • Introduction
    • Defining association rules metrics
    • Optimizing the calculations

Collection

This content is also available in the collection:
DAX Patterns collection
Student Rating
5.0
4 ratings
0%
0%
0%
0%
Student Reviews (2)
  • Genadiy Tsvetkov (Dec 27, 2023)

    Very complex calculations, not easy to follow, but very useful also. It would be great if the pattern for categories comparison could be explored further. E.g. in Finance, when you need to compare different plan versions with each other (where plan version is originally the same Category in the data model)

  • Ivan Yu (Jun 15, 2021)

    It is very good that you have Excel version of the Code as sometimes, organization don't use POWER BI but Tableau. But they still use Excel all the time.