Market Basket Analysis in easy 3 Steps
Market basket analysis is a data mining technique used by retailers to increase sales by better understanding customer purchasing patterns. It involves analyzing large data sets, such as purchase history, to reveal product groupings, as well as products that are likely to be purchased together.
For example, they might notice that people who buy bread often buy butter too. This helps the store put these items closer together or offer special deals on them. So, when you go to buy bread, you’re more likely to pick up butter as well. It’s like a little trick to make you buy more.
Step 1: Make relation of order id like this.
And then make relation of sub-category and sub-category(orders1) as sub category is less or equal to sub-category(orders1).
Step 2: Drag the sub-category to rows and sub-category(orders1) to columns.
Step3: Drag the order ID to text.
And now, convert the measure of order ID into count.
Step 3: Change the automatic text into square boxes.
Also, Drag the order ID to color self.
We now know what all products to bundle together to increase the top line for store.
