I rarely leave comments, but this is by far the best tutorial I've seen on this topic. Your explanations were clear and really helped me to understand the concept of basket analysis. Thank you!
Absolutely great video, exactly what I was looking for. The best thing about this is that you started off by explaining the key concepts of support, confidence and lift, which not a lot of youtubers do, since they focus too much on the technical aspects of data without realizing that the true value of such projects lies in the derived business insights. So, thank you for that!
Wonderful video. I was never aware of Basket Analysis. All I knew was customer segmentation using cluster analysis Please create more videos for data analysis using Power BI
Every videos of your channel help the aspiring data analyst like me. Honestly, I really want to learn more and it’s a great learning curve. Please do more videos, it’s really helping us.
Hi Mister, I'm writting you from Chile (SouthAmerica). The quality of your work is impressive, not only because of the quality of the video production but also due to the concept explanation. Thanks sir for your immensurable contribution for those of us who are learning.
Another top video Gurpreet. I have always struggled with DAX. Loved the way you have explained the DAX calculations. Made perfect sense. Thanks a lot for creating such high quality content. I hope more people your content and benefit from it.
This is just a top-notch walk-through of the whole concept. Complex concept explained in a simple way! I have never seen anyone explain the nested Dax functions in a simpler way than you did in this video. KUDOS! Keep it up & thanks for your time/efforts in putting together this tutorial.
Thank you for sharing your expertise and insights. i am actually struggling with DAX functions. My Column of Confidence of Prod1 and Prod2 are showing 100% in all the rows, what can be the mistake I'm making Thank you in Advance
Thank you once again for sharing your expertise and insights.Your dedication to spreading knowledge and making it accessible to a wider audience is truly commendable.
Quite helpful to import Association Rule basis analysis as relevant option with easy to follow way. Many Thanks and hope you share more various example of data mining cases on Power BI. Thank you.
@@biwithgurpreet I am working on the guided churn analysis and would love to share and link it back to you... Can you please share your LinkedIn handle or twitter sir ?
Great video. Tried following along but apparently, I couldn't get the "network" chart from Get More Visuals as they are all now paid. Please, is there any other available chart that isn't paid that I can use to visualize the basket?
Dear Gurpreet, many thanks for the explanation it’s really very useful and well detailed, thank you very much. Just one point, I’m struggling to understand the filter effect applied on the Crossjoin function. I’ve understood the result but the logic behind is a bit fuzzy for me, when we say [Product1][Product2] or [Product1]=[Product2] it’s more or less clear, but [Product1]>[Procuct2] or vice versa especially when we deal with a text fields. I’m a little bit lost regarding this point. Is their any logic behind or should I take it like that and move forward? Many thanks.
Hi Gurpreet, I love the explanation and walk through of the Basket Analysis Model, Thank you very much for the video. The model you show is based on the entire dataset using every transaction ID in the table. Is there a way to add a date-slicer to select transaction ID (dynamic selection) from a particular time period and perform the analysis for that subset of data?
Yes possible, you need to take those calculations out from the calculated columns and creating DAX measures and then use your slicers as we do normally.
@@majeedadil777 Hi Majeed, could you please give more details, cause when we have [Product1]=[Product2] or [Product1][Product2] as a filter criteria, it’s clear but when we have [Product1]>[Product2] or vice versa here my brain blocks. Based on what exactly?? Alphabet as the two columns are in text type, or base on positions. Many thanks for your help. Hicham.
Hi Gurpreet, thank you for your video it´s excellent! It´s straightforward and very clear. The problem I have is that my dataset y huge. I have 20,000 different SKUs. When I generate the table with all the different pairs of products as you did with the Corssjoin function as You did the table consists of 200 million rows, which is impossible to manage. I love your approach and I´m trying to implement the model the way you shared. Is there a way I can generate ONLY the different pairs of products that really exist in any ticket? I´m looking for a solution in DAX. I appreciate your help, Marcelo , Buenos Aires, Argentina
one thing I wanted to ask was ...are the DAX queries used here will be the same for doing market basket analysis of any data or will we have to write some different queries?
This part definitely needs improvement. I am trying different options to make it better. And I believe I have found a solution. Please review the next video (releasing tomorrow) and share your feedback. Thanks
@Taizoon and @Jai - Thanks for your feedback. It’s greatly appreciated. Checkout the latest video on custom sorting and let me know, if it is better than before.
I come from Vietnam. Thank you for your video, very helpful. I'm doing a project at school related to baskets. However, my TransactionID and Product columns are not in the same table as your example. It is located in 2 different tables. When calculating Support basket, I got an error "A single value for column 'TransactionID' in table 'Orders' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result." I wonder if you could offer some help?
I would love to help you out. Please email me at biwithgurpreet@gmail.com and I will schedule some time with you to help you out. It will most likely be during the weekend
Hi. Im working with a lot of data so when I want to create the Basket analysis Table it says that there is not enough space. Do you have any suggestions on what I can do?
Dear Tharun - I have already added your request to my content pipeline. I have limited time to create the free content for RUclips. And I also don’t cut corners on quality of content. Please bear with me while I get to your requests
Very cool, but what if I wanted to refer it to several stores and divide it into a specific date and store? In one word, I would have to add 2 columns to this example, but then the "index" column will not be correct because it should be counted differently for each store, maybe someone can link the example I gave because it is a bit more realistic :)))))
I rarely leave comments, but this is by far the best tutorial I've seen on this topic. Your explanations were clear and really helped me to understand the concept of basket analysis. Thank you!
Thanks Drez. Much appreciated
Absolutely great video, exactly what I was looking for. The best thing about this is that you started off by explaining the key concepts of support, confidence and lift, which not a lot of youtubers do, since they focus too much on the technical aspects of data without realizing that the true value of such projects lies in the derived business insights. So, thank you for that!
Wonderful video. I was never aware of Basket Analysis. All I knew was customer segmentation using cluster analysis
Please create more videos for data analysis using Power BI
Every videos of your channel help the aspiring data analyst like me. Honestly, I really want to learn more and it’s a great learning curve.
Please do more videos, it’s really helping us.
A fine example of knowledge sharing through clear and simple explanation with an amazingly useful use case. Thanks a lot.
Thanks for the commenting Usman. Much appreciated
Hi Mister,
I'm writting you from Chile (SouthAmerica).
The quality of your work is impressive, not only because of the quality of the video production but also due to the concept explanation.
Thanks sir for your immensurable contribution for those of us who are learning.
Thanks for the awesome feedback. I am glad you found the videos useful.
Another top video Gurpreet. I have always struggled with DAX. Loved the way you have explained the DAX calculations. Made perfect sense. Thanks a lot for creating such high quality content. I hope more people your content and benefit from it.
That’s great. Thanks for the appreciation 👍🏽
This is just a top-notch walk-through of the whole concept. Complex concept explained in a simple way!
I have never seen anyone explain the nested Dax functions in a simpler way than you did in this video. KUDOS! Keep it up & thanks for your time/efforts in putting together this tutorial.
You made my day with your comment 😊 Best wishes
Thank you so much for such an amazing video !!! You have explained it in the simplest way possible. Really Helped
Wow! Very resourceful. Much appreciated sir. I now understand the basket analysis concept better. Thank you so much!
Glad it was helpful!
Thank you for sharing your expertise and insights. i am actually struggling with DAX functions. My Column of Confidence of Prod1 and Prod2 are showing 100% in all the rows, what can be the mistake I'm making
Thank you in Advance
Wow, this is not an easy topic but you delivered it so well. Thank you
Thanks Ross
Thank you once again for sharing your expertise and insights.Your dedication to spreading knowledge and making it accessible to a wider audience is truly commendable.
I am glad that you got value out of my videos. Thanks for the kind words.
This was outstanding...I learned so much and gained an understanding of DAX
Really glad that it was beneficial for you. Best wishes
phew!!!, i got to the end. You are a really good teacher, very detailed.
This is amazing! Thank you for sharing! 🌟🌟🌟🌟 Can't wait until your channel will have superthanks function!
Thank you so much!
Quite helpful to import Association Rule basis analysis as relevant option with easy to follow way. Many Thanks and hope you share more various example of data mining cases on Power BI. Thank you.
What a content and concept sir. Really I like the way of your explanation and your English.
@vasuitc2007 Thanks for the feedback and appreciation
going back to this!! hands down!! the best!
Thanks John. Glad it has been of help to you
Thanks for making us understand Basket Analysis....God Bless You
Thanks a lot
Gurpreet Sir your explanation is really good ... Please continue
Thanks Amol
This is extremely helpful! How would I apply slicers (and where) if I want to look at a specific region or sales channel?
Great Video Gurpreet! well done!
Thanks a lot
Thank you for an excellent tutorial! Is there anything worth considering if I want to add products e.g. Prod 3 and Prod 4 in the basket analysis?
Very helpful content ! Thank you for sharing !!!
Glad it was helpful!
This is a masterful video. Thank you so much!!!
Thanks for sharing such a great content
Thanks a million sir,
For your value adding contents and your Large heartedness towards our growth and development...
Great to know that you are getting value from the content on this channel. Thanks for sharing your feedback
@@biwithgurpreet I am working on the guided churn analysis and would love to share and link it back to you...
Can you please share your LinkedIn handle or twitter sir ?
Amazing job! thank you so much!
Thanks Fabio
Great video. Tried following along but apparently, I couldn't get the "network" chart from Get More Visuals as they are all now paid. Please, is there any other available chart that isn't paid that I can use to visualize the basket?
this was outstanding sir
Thanks Aakash. I am glad it was useful for you
Really help full content 👌👌👌
Thanks
Why you stopped making video, we needed such great project in this tough time.
Dear Gurpreet, many thanks for the explanation it’s really very useful and well detailed, thank you very much. Just one point, I’m struggling to understand the filter effect applied on the Crossjoin function. I’ve understood the result but the logic behind is a bit fuzzy for me, when we say [Product1][Product2] or [Product1]=[Product2] it’s more or less clear, but [Product1]>[Procuct2] or vice versa especially when we deal with a text fields. I’m a little bit lost regarding this point. Is their any logic behind or should I take it like that and move forward? Many thanks.
Hi Gurpreet, I love the explanation and walk through of the Basket Analysis Model, Thank you very much for the video. The model you show is based on the entire dataset using every transaction ID in the table. Is there a way to add a date-slicer to select transaction ID (dynamic selection) from a particular time period and perform the analysis for that subset of data?
Yes possible, you need to take those calculations out from the calculated columns and creating DAX measures and then use your slicers as we do normally.
Hello Sir, i can't find the Network Chart on Power BI , has it been changed or renamed?
Thank you soooooo much
I LOVE YOU MAN!
Hello Sir @ 22:44 if we do [Product1]
So that the same product combination shouldn't repeat itself like (Milk --> Milk) or (Milk --> Bread) or (Bread --> Milk)
@@majeedadil777 Hi Majeed, could you please give more details, cause when we have [Product1]=[Product2] or [Product1][Product2] as a filter criteria, it’s clear but when we have [Product1]>[Product2] or vice versa here my brain blocks. Based on what exactly?? Alphabet as the two columns are in text type, or base on positions. Many thanks for your help. Hicham.
PROJECT FILE LINKS:
Download the project dataset: tinyurl.com/sscw2z9t
Download Power BI (PBIX) file: tinyurl.com/2s4575zn
Great video, thank you so much :)
Thanks for the appreciation
Hi Gurpreet, thank you for your video it´s excellent! It´s straightforward and very clear. The problem I have is that my dataset y huge. I have 20,000 different SKUs. When I generate the table with all the different pairs of products as you did with the Corssjoin function as You did the table consists of 200 million rows, which is impossible to manage. I love your approach and I´m trying to implement the model the way you shared. Is there a way I can generate ONLY the different pairs of products that really exist in any ticket? I´m looking for a solution in DAX. I appreciate your help, Marcelo , Buenos Aires, Argentina
Better to go with the Machine Learning path using Apriori, ECLAT or FP-Growth algorithm's
one thing I wanted to ask was ...are the DAX queries used here will be the same for doing market basket analysis of any data or will we have to write some different queries?
Hi , the Advanceed Network Filter light is no longer an option. Is there an alternative way to access this? thanks
Sir Once Suggestion, Your teaching is so good but screen is not visible can you zoom it and teach us so that it helps for better understanding
This part definitely needs improvement. I am trying different options to make it better. And I believe I have found a solution. Please review the next video (releasing tomorrow) and share your feedback. Thanks
@@biwithgurpreet Thank you Sir 🙏
@@taizoondean689 few weeks back I also shared the same concern with Gurpreet sir
@Taizoon and @Jai - Thanks for your feedback. It’s greatly appreciated. Checkout the latest video on custom sorting and let me know, if it is better than before.
@@biwithgurpreet Thanks sir will check and update you 🙏🙏
I come from Vietnam. Thank you for your video, very helpful. I'm doing a project at school related to baskets. However, my TransactionID and Product columns are not in the same table as your example. It is located in 2 different tables. When calculating Support basket, I got an error "A single value for column 'TransactionID' in table 'Orders' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."
I wonder if you could offer some help?
I would love to help you out. Please email me at biwithgurpreet@gmail.com and I will schedule some time with you to help you out. It will most likely be during the weekend
Hi, Can we use Product1product2 (not equal) instead greater than. How greater than works here?
So that the product combinations shouldn't be repeating like (Milk --> Bread) or (Bread --> Milk)
Hi. Im working with a lot of data so when I want to create the Basket analysis Table it says that there is not enough space. Do you have any suggestions on what I can do?
Hi may i ask what kind of method are you using for the basket analysis? is it FP-growth method?
Association Rules - arules - Apriori Algorithm
Sir can you please bring an end to end projects on FMGC, HEALTCARE, AND FINANCE. I have requested to you in previous video also..
Dear Tharun - I have already added your request to my content pipeline. I have limited time to create the free content for RUclips. And I also don’t cut corners on quality of content. Please bear with me while I get to your requests
@@biwithgurpreet
Sure sir.. I just wanted to remember you.
Thank you for accepting my request and added to your playlist..
Cool 👍🏽
Sir can we add this project in resume
Sure 👍🏽
Very cool, but what if I wanted to refer it to several stores and divide it into a specific date and store? In one word, I would have to add 2 columns to this example, but then the "index" column will not be correct because it should be counted differently for each store, maybe someone can link the example I gave because it is a bit more realistic :)))))
You need to create a concatenated column with the store, date and transaction id to make it unique
Sir everything Good but text was too small to read and understand.
+1 Subs Here!