Tableau Groups vs Sets - Comparison and examples (proportional brushing, top and bottom values)

Поділитися
Вставка
  • Опубліковано 1 січ 2025

КОМЕНТАРІ • 151

  • @vijayarjunwadkar
    @vijayarjunwadkar 3 роки тому +16

    WOW, It was worth the wait! You clarified the difference between Groups and Sets in such a simple, yet comprehensive way! Looking forward for more such informative and super useful videos! Love the way you explain and teach, keep up the great work! 😊👍

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Vijay!

  • @derekbelyea
    @derekbelyea 3 роки тому +9

    Recommended for all Tableau developers. Very clear and thorough coverage of these important topics. Thank you again for sharing your insights.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you so much Derek! Your feedback and comments are much appreciated! 🙂

  • @tariqa8962
    @tariqa8962 2 роки тому +1

    I just passed the Tableau Desktop Specialist certification Exam...and i owe you big time... Thank you :)

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Congratulations on the wonderful news, Tariq!

  • @cesargonzalez4935
    @cesargonzalez4935 3 роки тому +2

    WOW! Almost two years using Tableau and just now realize what SETS can do 🤯
    PLEASE DO more use cases for SETS! 👏

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Cesar! Glad you found it useful. And yes, I am planning to have more use-case based tutorials on groups, sets as well as LODs, table calcs and basic calculations 🙂

  • @MichaAtienza
    @MichaAtienza 9 місяців тому

    So glad to have found your channel and see Filipina-canadian representation in the space. I loved reading your website and blogs.

    • @sqlbelle
      @sqlbelle  9 місяців тому

      Thank you so much Micha! I appreciate your kind words and support ❤️

  • @senthil7590
    @senthil7590 Рік тому

    Sqlbelle is my all time favorite channel to learn more in depth of Tableau.

  • @piyushkulkarni8868
    @piyushkulkarni8868 3 роки тому +3

    Really nice video... Whenever I find any difficulty in tableau, i search for your video first... :)☺️

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you so much for sharing, Piyush! So happy to hear you are finding the channel helpful :)

  • @nagarajants8160
    @nagarajants8160 3 роки тому +1

    I have seen lot of your tableau video. Yes, Its really better than paid video courses.. Thanks for your wonderful teaching. I don't know how to thank you.. I never skip any Ads from your video only for you.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you so much Nagarajan, that's really kind of you. I am happy you're finding the videos useful. Thank you for your kind note and gesture, much appreciated.

  • @ahabweandrew
    @ahabweandrew 2 роки тому +2

    Thanks so much for creating these videos, you are far better than those selling their courses. I can say I wasted my money on Udemy

    • @sqlbelle
      @sqlbelle  2 роки тому

      I am glad you are finding the videos helpful, Ahabwe! Happy New Year!

  • @gauravtarapure4876
    @gauravtarapure4876 3 роки тому +2

    How gracefully you have explained minute details in simplest way ! More power to you.
    Thanks for such an incredible insights.

    • @sqlbelle
      @sqlbelle  3 роки тому +2

      Thank you so much Gaurav! :)

  • @Bob-mn7ob
    @Bob-mn7ob 2 роки тому

    I've been using Tableau for several years yet I still learn things from your videos. I like the way you sometimes go off-topic to add some useful side notes such as you did for set controls in this vid. you obviously spend a great deal of time on your productions.

  • @sreddibathuni
    @sreddibathuni 2 роки тому +1

    Thanks!

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you so much Srinivasa!

  • @trekwithwicky
    @trekwithwicky Рік тому +3

    Your videos are simply fantastic! The content was both informative and engaging, and your passion for the subject matter really shone through. I'm so grateful to have had the opportunity to watch it. Thankyou!❤❤❤

    • @sqlbelle
      @sqlbelle  Рік тому +2

      Thank you so much for the kind note, I appreciate it!

  • @souravanand932
    @souravanand932 Рік тому

    So detailed yet easily explained. Love your videos.

  • @siddhantghadage2439
    @siddhantghadage2439 2 роки тому +1

    WOW ma'am, love your teaching style.. worth to watch this video.. Thank you.

    • @sqlbelle
      @sqlbelle  Рік тому +1

      Thank you @siddhantghadage2439

  • @rxmendxmen567
    @rxmendxmen567 3 роки тому +1

    Yesterday I was looking for exactly this video and this morning I saw the upload. Perfect timing haha

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      I hope you found it useful, Simon! 🙂

  • @farzanakalluri3372
    @farzanakalluri3372 3 роки тому +1

    Very nice explanation on Groups and Sets. Its very clear and easy way to understand. Thanks to you much Belle.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Farzana!

  • @halleluyahpaul3334
    @halleluyahpaul3334 Рік тому +1

    I haven't completed the video but the introduction catch my attention well done @sqlbelle🙅

  • @Atharvao988
    @Atharvao988 2 роки тому

    Very nice, you explained the difference in very simple way ,Great

  • @russelllavery2281
    @russelllavery2281 2 роки тому +1

    this lady is brilliant!

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you Russell!

  • @sampathkavala6976
    @sampathkavala6976 2 роки тому +1

    All doubts are cleared. Great channel for learning Tableau

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you Sampath!

  • @SumitYadav-fz2vt
    @SumitYadav-fz2vt Рік тому

    So interesting in simple words thank you for the wonderful video

  • @rotslancer2717
    @rotslancer2717 2 роки тому

    Every video I watch from your channel seems like I have a lot to learn.... Thank you so much for making such great videos.

  • @shisuili1524
    @shisuili1524 3 роки тому +1

    Nice done! This worth more views!

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Shisui! I appreciate that :) (and I hope so too!)

  • @equiwave80
    @equiwave80 3 роки тому

    Thanks for this video.
    I learnt few new topics in Groups and Sets:
    Additional options to create groups and sets
    Include 'Other' option in Groups
    Set Use Case 2: Proportional Brushing
    Your videos are very informative!!!

  • @rajeshtukdeo
    @rajeshtukdeo 3 роки тому +1

    This video has certainly improved my understanding about Sets & Groups.. Thank you !!

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      I am so happy you found it helpful Rajesh!

  • @kskchaitanya
    @kskchaitanya Рік тому +1

    Commenting for reach. Very nice explaination.

    • @sqlbelle
      @sqlbelle  Рік тому +1

      Thank you so much Krishna!

  • @ben-cb5er
    @ben-cb5er 3 роки тому +1

    amazing job explaining groups/sets and showing examples....valuable content! great job and please keep making videos tableau related.. thank you

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Ben! Glad to hear you found it helpful :)

  • @Data_Mom
    @Data_Mom 3 роки тому +1

    Very nicely explained the difference between sets and groups, clear and informative . Thanks a lot

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Pooja! Thank you for this comment, and happy to hear you are finding it helpful! :)

  • @pmkz7970
    @pmkz7970 3 роки тому +2

    Gosh i love this channel so much!!! thank you for making these videos.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you PMZ 🙂

  • @shipla1310
    @shipla1310 Рік тому

    You are just simply Amazing....The way explain every l'll thing it was just awesome... Way of detailing each bite is engaging us more n more...Looking forward many more informative videos....Thank you so much...❤❤

  • @nehakumarisingh2920
    @nehakumarisingh2920 3 роки тому +1

    Thank you ma'am..it was so well explained

  • @dataman1000
    @dataman1000 2 роки тому +2

    Great lesson thanks. Love the way you teach how to handle a task in different ways.👍

  • @sabeenamahmud8921
    @sabeenamahmud8921 3 роки тому +1

    wow, great explanation. Worth watching it.

    • @sqlbelle
      @sqlbelle  3 роки тому

      Thank you Sabeena. Glad to hear you found the video worth watching.

  • @swethanandyala
    @swethanandyala Рік тому

    Your videos are Incredible!!!!

  • @sujana4267
    @sujana4267 3 роки тому +2

    Wow such a wonderful session . Loved the way you explained things. Very clear!! Please make more videos on other BI tools as well.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Sujana!

  • @AdrianaPerez-ev5cj
    @AdrianaPerez-ev5cj 3 роки тому +1

    Great video. Very well explained!

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Adriana :)

  • @ambujrai9872
    @ambujrai9872 3 роки тому +1

    Excellent content with clear details. Thank you once again .😊

  • @rev1198
    @rev1198 2 роки тому +1

    Wonderfully explained.. Thanks 🙂

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you Revanth

  • @peterparker4358
    @peterparker4358 3 роки тому +2

    Nice explanation ❤️ as always ,sometime words are less to appreciate your teaching !!

    • @sqlbelle
      @sqlbelle  3 роки тому +2

      Thank you, as always, Peter!

  • @michafabich9213
    @michafabich9213 2 роки тому +1

    amazing tutorial, thank you

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you Michal :)

  • @gagzilla04
    @gagzilla04 3 роки тому +1

    Great work! Loved it❤️

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you so much Gagandeep! Happy to hear it was helpful :)

  • @udayabanunagarajan5401
    @udayabanunagarajan5401 3 роки тому +1

    Clearly explained!! Loved it !

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Udaya!

  • @sameerabanu3115
    @sameerabanu3115 3 роки тому +1

    beautifully explained

    • @sqlbelle
      @sqlbelle  3 роки тому

      Thank you Sameera!

  • @ushasuresh81
    @ushasuresh81 3 роки тому +1

    As always, the difference between sets and groups is very well explained. Waiting for a video on Actions using Sets.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Usha, I hope you found it useful!

  • @princedelapaz9806
    @princedelapaz9806 3 роки тому +1

    this a great find! happy to know i have a kabayan who does this 😊

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Hello Prince! Salamat :) I hope you found the video helpful and salamat sa comment at suporta!

  • @srem1971
    @srem1971 3 роки тому +1

    Great explanation. Thank you!

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      You are welcome srem1971, I hope you found that helpful!

  • @anaghadamame196
    @anaghadamame196 3 роки тому +1

    Wow...great work 👌
    Thank you for this perfect video

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Anagha!

  • @giuliko
    @giuliko 3 роки тому +1

    Another stunning lesson. Keep up the great work. 🤓

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Guiliko!

  • @sarasong6019
    @sarasong6019 3 роки тому +1

    Very helpful as always, thank you very much!

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Sara! I am glad you found it helpful 🙂

  • @datafreak911
    @datafreak911 Рік тому

    Your videos are by far the best. If possible, can you also show how to prepare a 3-way venn diagram

  • @sreehari6323
    @sreehari6323 3 роки тому +1

    VERY USEFULL , THANKS FOR THE VIDEO

  • @shraddhaw1537
    @shraddhaw1537 2 роки тому

    you give me "Professor McGonagall" kinda vibes.... transfiguring data into insights💯

  • @rajashekarn2000
    @rajashekarn2000 3 роки тому +1

    As always,nice explanation.:)

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Rajashekar!

  • @anushadavuluri5558
    @anushadavuluri5558 Рік тому

    Could anyone explain at 20:40 what actually the bar graph is about and why the combined set is in filter

  • @teenuptanvee
    @teenuptanvee 3 роки тому +1

    Thank you so much.......its just wonderfull..... thanks for explaining so beautifully :)

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Tanvee! I hope you found the video useful!

    • @teenuptanvee
      @teenuptanvee 3 роки тому +1

      @@sqlbelle absolutely......... Useful

  • @khuntiaachyutanan7316
    @khuntiaachyutanan7316 Рік тому

    Thank you - i Like way of your teac ing. understandable

  • @ballyb1
    @ballyb1 2 роки тому +1

    Great video ...

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you Balvinder!

  • @sakshikashyap7034
    @sakshikashyap7034 3 роки тому +1

    No one ever explains sets this clear...

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Sakshi!

  • @z.r.777
    @z.r.777 23 дні тому

    Thank you, Thank you!

  • @wwpharmacist
    @wwpharmacist Рік тому

    Sure, very very useful 🎉

  • @sudhasree9306
    @sudhasree9306 3 роки тому +1

    Wow, Awesome Explanation, Thanks a lot ,please provide Parameter topic also thanks.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Sudha 🙂

  • @TheOGizabellie
    @TheOGizabellie 3 роки тому +1

    Love it and thank you! also love your @ :)

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Isabelle! Here's to all the "belle"s :) (it's my nickname as well!)

  • @RameshCh-me8jm
    @RameshCh-me8jm 3 роки тому +1

    It's so good easy and understanding ♥️ thanks for sharing 🙂 and please do a video on set actions and parameter actions..

    • @sqlbelle
      @sqlbelle  3 роки тому +2

      Thank you, will do!

  • @cocoon757
    @cocoon757 3 роки тому +1

    When you show top product by region (22:13), that means the top products are different for each region since the top-set is defined dynamically. Do I understand this correctly?

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Hi! For the example I gave, it is the top 10 products universally, and how much of those top 10 make up the region profit. For this case, we are not looking at the "relative top 10" but the global top 10.
      It's like, if our top product was "Book", it's looking at how much "Book" accounts for the region profits (how much of Central's profit is book, how much of West's profit is book, etc).
      I hope I didn't confuse you.

    • @cocoon757
      @cocoon757 3 роки тому

      @@sqlbelle thanks for the explanation. Excellent video! Btw, is there a way to show top 10 products for each region (locally rank instead of global ranking)?

  • @AliciaMarkoe
    @AliciaMarkoe 3 роки тому +1

    Excellent, thank you 🌺🦋🌼

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Alicia! Hope you found it useful!

  • @geraldrealubit1949
    @geraldrealubit1949 2 роки тому

    wow, as in wow... Thank you sqlbelle :)

  • @ValerieFomenko
    @ValerieFomenko 8 місяців тому

    Thank you for this video! It was really helpful!
    Do you have video on creating sets using by formula conditions? Thanks!

    • @sqlbelle
      @sqlbelle  8 місяців тому

      Not yet, thank you for the suggestion! That's a topic that I'd like to expand on.

  • @rebekahalvarez8627
    @rebekahalvarez8627 3 роки тому +1

    IS there a way to use the groups or sets and parameters or create diferent dimensions off main ones?

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Rebekah. Would you be able to give an example of what you're thinking to accomplish?

    • @rebekahalvarez8627
      @rebekahalvarez8627 3 роки тому

      @@sqlbelle hi sqlbelle! I think it's cute we share the same belle nickname lol! I mean I have a dimensión with 50 items and I want to instead have 5 dimensiones with 10 items to play with, it's that posible with sets? Do you give private lessons on zoom? Cause I could really benefit off one now! 😀😅

  • @meshell7987
    @meshell7987 3 роки тому +1

    Thank you for the useful video! I have one question about groups: I have big list of serial numbers (lets say 900 serial numbers) which I want to divide in 3 groups. I have a list which serial number in which group should be included (each group should have 300 SNs). Can I insert somewhere this list and say "This list of 300 SNs should be group 1", instead of clicking one by one and selecting every single serial number. Contains, Starts with and Exact match won't work, because there is no specific logic which serial number is which group should be. I just want to insert the list of 300 serial numbers and say this list is group 1, then insert the list of the other 300 SNs and say this is group 2 and the same for group 3..? Can I easily do that? Thank you :))

    • @sqlbelle
      @sqlbelle  3 роки тому +2

      Hi! Hmm that's interesting use case. What I would probably suggest is using a different data source. I gave this a try and it seems to work ok.
      I added a whole bunch of product names into an Excel file (pretending that's group 1), and copied/pasted to Tableau. It will be in a clipboard data source.
      From here you can drag your original serial number and your serial number from the clipboard. You can sort based on blank serial numbers from clipboard (which means they are not in group 1), or shift-select the ones with valid corresponding values and group.
      Not sure if it will work for your case but might be worth a try.

    • @meshell7987
      @meshell7987 3 роки тому

      @@sqlbelle Thank you very much, will give it a try! :))

  • @Data_Mom
    @Data_Mom 3 роки тому +1

    Hi Donabel, to-the-point and wonderful explanation of Sets. thanks you for this video. I didn't find part 2- additional use cases of sets. is it included in the playlist?

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you, as always, for your kind comments and support Pooja! I am playing catch up on creating the video tutorials. Hoping to have more soon.

  • @AJ-bd8os
    @AJ-bd8os 2 роки тому +1

    Can we combine a static set and dynamic set

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Hi AJ - yes we can

    • @AJ-bd8os
      @AJ-bd8os 2 роки тому

      @@sqlbelle Thank you

  • @Data_Mom
    @Data_Mom 3 роки тому +2

    One more question Donabel, can we have proportional brushing for two variables? I created sets for State and Region (in two different worksheets)and in the dashboard, I want Sales to be highlighted for the region/state that I select. I am observing that only one set action works at at time. Please clarify.

  • @ni12907
    @ni12907 3 роки тому +1

    Hey, can you show how you create end-to-end dashboard from scratch? I am interested in Sales/Retail/Profit and Loss/Prior Year vs Current Year type Dashboards. Thank you!

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Nishi. I have 3 videos on dashboards in general. You may be able to use those strategies with what you need for your own dashboards. ua-cam.com/video/cGa7QDeueTA/v-deo.html

    • @ni12907
      @ni12907 3 роки тому +1

      @@sqlbelle thank you so much, this is exactly what I was looking for. I really like your style of teaching. Perfect pace and great content! 👌👌👌👌👌

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      @@ni12907 That's great to hear.

  • @sobersabin
    @sobersabin 3 роки тому +1

    can you please make video on index and its uses,please

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thanks Sabin! Do you mean indexes in relational databases?

  • @venkatc1323
    @venkatc1323 3 роки тому +1

    👌👌👌👌👌👌, keep going on

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Venkat!

  • @harigondhipalli1777
    @harigondhipalli1777 3 роки тому +1

    super madam

  • @neelnickkey4865
    @neelnickkey4865 3 роки тому +1

    Thank you @sqlbelle !!!c

  • @Happy_Stomach
    @Happy_Stomach 2 роки тому

    I created two groups in group 1 I made first class ans second class
    In group 2 I made third class amd fourth class lije this I made Two groups with the name of group 1 amd group 2
    Now in this group 1 I have the first class this should come in to my group 2 as well
    Can we do this plz help me in groups is it possible ?

  • @chawar123
    @chawar123 2 роки тому

    HI! is ther a way to make a group with a dimmentions with values (which will be included afterwards). For example I want to add pen to the subcategery which is not included in subcategery at present. It will be added in the future. Is it possible??

  • @rubengeertvandenberg3336
    @rubengeertvandenberg3336 2 роки тому

    Great work!
    But just a quick question: sets are dynamic.
    So when you drop region into the rows shelf, does region affect the top 10 products set?
    That is, is it now a top 10 products per region or still the same top 10 for all regions combined?

  • @Happy_Stomach
    @Happy_Stomach 2 роки тому

    Can u help me plz of my comment

  • @GrandizerIntali9
    @GrandizerIntali9 3 роки тому +1

    Amazing explanation, thank you !