Basket Analysis using Power BI - Intermediate DAX Power BI Project | Power BI Mastery
HTML-код
- Опубликовано: 21 июл 2024
- In this video we will be learning all about basket analysis and how to perform it in Power BI, in the form of a complete project.
This is an intermediate level project, with focus on learning and writing a bit complicated DAX formulas and functions, to to data analysis required in order to effectively perform basket analysis.
--------------------------------------------------------------------------------------------------------
✅ DOWNLOAD PROJECT FILES:
Download Microsoft Power BI file: tinyurl.com/2s4575zn
Download the project dataset: tinyurl.com/sscw2z9t
--------------------------------------------------------------------------------------------------------
⏱️TIMESTAMPS:
00:00 Introduction to the Power BI Project
01:19 What is Basket Analysis? Definition and Applications
03:00 Learn the 3 key concepts: SUPPORT, CONFIDENCE and LIFT
11:19 Step-by-step - Data Preparation
15:46 Step-by-step - Data Analysis
36:50 Format DAX using DAX Formatter
38:26 Step-by-Step - Data Visualisation
52:18 RECAP of the project and the key learning
🙏🏽 REQUEST VIDEOS
forms.gle/4BFcH6msQEwuBrEU9
--------------------------------------------------------------------------------------------------------
🔔 SUBSCRIBE!
Do you want to become a Data Analyst or a BI Analyst? That's what this channel is all about! My goal is to help you learn the skills, knowledge and tools to successfully launch a career in Data Analytics. Be sure to subscribe to not miss out on any content!
--------------------------------------------------------------------------------------------------------
🔽 CONNECT WITH ME:
- Instagram: / biwithgurpreet 
Наука
![Jelly Roll - Dead End Road (From Twisters: The Album) [Official Music Video]](http://i.ytimg.com/vi/_Mb8CqKW4R8/mqdefault.jpg)
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!
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
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.
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 👍🏽
Wow! Very resourceful. Much appreciated sir. I now understand the basket analysis concept better. Thank you so much!
Glad it was helpful!
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
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
going back to this!! hands down!! the best!
Thanks John. Glad it has been of help to you
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.
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.
This is amazing! Thank you for sharing! 🌟🌟🌟🌟 Can't wait until your channel will have superthanks function!
Thank you so much!
Thanks for making us understand Basket Analysis....God Bless You
Thanks a lot
This was outstanding...I learned so much and gained an understanding of DAX
Really glad that it was beneficial for you. Best wishes
Wow, this is not an easy topic but you delivered it so well. Thank you
Thanks Ross
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?
Amazing job! thank you so much!
Thanks Fabio
What a content and concept sir. Really I like the way of your explanation and your English.
@vasuitc2007 Thanks for the feedback and appreciation
Very helpful content ! Thank you for sharing !!!
Glad it was helpful!
Great Video Gurpreet! well done!
Thanks a lot
Hi Sir, congrats for 1k Subscribers. Yours explanation is really good. We are expecting more such videos from you sir.
Please do a series of tutorials on DAX.
Thanks a lot. New updates and videos coming soon
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
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 ?
Hi may i ask what kind of method are you using for the basket analysis? is it FP-growth method?
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?
Gurpreet Sir your explanation is really good ... Please continue
Thanks Amol
Thank you soooooo much
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
Great video, thank you so much :)
Thanks for the appreciation
this was outstanding sir
Thanks Aakash. I am glad it was useful for you
Really help full content 👌👌👌
Thanks
Hello Sir @ 22:44 if we do [Product1]
Hi, Can we use Product1product2 (not equal) instead greater than. How greater than works here?
Hello Sir, i can't find the Network Chart on Power BI , has it been changed or renamed?
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?
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 , the Advanceed Network Filter light is no longer an option. Is there an alternative way to access this? thanks
PROJECT FILE LINKS:
Download the project dataset: tinyurl.com/sscw2z9t
Download Power BI (PBIX) file: tinyurl.com/2s4575zn
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 👍🏽
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 :)))))
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 🙏🙏
Sir can we add this project in resume
Sure 👍🏽
Sir everything Good but text was too small to read and understand.