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

Ғылым және технология

Tableau Groups vs Sets - This video provides a complete overview of groups and sets in Tableau. We will walk through how to create groups, fixed sets and dynamic sets. We will also look at some common use cases for each.
For shorcuts, please see: • 10 Tableau tricks you ...
Sections:
0:00 - Intro
1:13 - Groups
5:16 - Visual Grouping in Tableau
7:50 - Groups Use Case: keyword matching
10:18 - Sets
13:05 - Dynamic Sets
14:57 - Set Operations: Combining two sets
18:47 - Set Use Case 1: Show top and bottom values
20:36 - Set Use Case 2: Proportional Brushing
Related Videos:
Blue vs Green, Discrete vs Continuous
• Tableau Tutorial - Dim...
Useful Tableau Shortcuts
• 10 Tableau tricks you ...
Images courtesy of Unsplash, Pexels, Pixabay

Пікірлер: 150

  • @vijayarjunwadkar
    @vijayarjunwadkar3 жыл бұрын

    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 жыл бұрын

    Thank you Vijay!

  • @derekbelyea
    @derekbelyea3 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

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

  • @cesargonzalez4935
    @cesargonzalez49353 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

    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 🙂

  • @tariqa8962
    @tariqa89622 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Congratulations on the wonderful news, Tariq!

  • @Bob-mn7ob
    @Bob-mn7ob Жыл бұрын

    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.

  • @MichaAtienza
    @MichaAtienza3 ай бұрын

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

  • @sqlbelle

    @sqlbelle

    3 ай бұрын

    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.

  • @gauravtarapure4876
    @gauravtarapure48763 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

    Thank you so much Gaurav! :)

  • @equiwave80
    @equiwave802 жыл бұрын

    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!!!

  • @souravanand932
    @souravanand9327 ай бұрын

    So detailed yet easily explained. Love your videos.

  • @piyushkulkarni8868
    @piyushkulkarni88683 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

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

  • @rotslancer2717
    @rotslancer27172 жыл бұрын

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

  • @rajeshtukdeo
    @rajeshtukdeo3 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

    I am so happy you found it helpful Rajesh!

  • @ahabweandrew
    @ahabweandrew2 жыл бұрын

    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!

  • @trekwithwicky
    @trekwithwicky Жыл бұрын

    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

    Жыл бұрын

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

  • @sakshikashyap7034
    @sakshikashyap70342 жыл бұрын

    No one ever explains sets this clear...

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you Sakshi!

  • @russelllavery2281
    @russelllavery2281 Жыл бұрын

    this lady is brilliant!

  • @sqlbelle

    @sqlbelle

    Жыл бұрын

    Thank you Russell!

  • @rymensymen1994
    @rymensymen19943 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

    I hope you found it useful, Simon! 🙂

  • @nagarajants8160
    @nagarajants81603 жыл бұрын

    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 жыл бұрын

    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.

  • @siddhantghadage2439
    @siddhantghadage2439 Жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    Жыл бұрын

    Thank you @siddhantghadage2439

  • @Atharvao988
    @Atharvao988 Жыл бұрын

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

  • @farzanakalluri3372
    @farzanakalluri33722 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you Farzana!

  • @SumitYadav-fz2vt
    @SumitYadav-fz2vt Жыл бұрын

    So interesting in simple words thank you for the wonderful video

  • @dataman6744
    @dataman67442 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you :)

  • @sampathkavala6976
    @sampathkavala69762 жыл бұрын

    All doubts are cleared. Great channel for learning Tableau

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you Sampath!

  • @ben-cb5er
    @ben-cb5er3 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

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

  • @Data_Mom
    @Data_Mom3 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

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

  • @pmkz7970
    @pmkz79703 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

    Thank you PMZ 🙂

  • @peterparker4358
    @peterparker43583 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

    Thank you, as always, Peter!

  • @udayabanunagarajan5401
    @udayabanunagarajan54013 жыл бұрын

    Clearly explained!! Loved it !

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

    Thank you Udaya!

  • @ambujrai9872
    @ambujrai98722 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you Ambuj!

  • @swethanandyala
    @swethanandyala11 ай бұрын

    Your videos are Incredible!!!!

  • @michafabich9213
    @michafabich92132 жыл бұрын

    amazing tutorial, thank you

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you Michal :)

  • @shraddhaw1537
    @shraddhaw15372 жыл бұрын

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

  • @gagzilla04
    @gagzilla043 жыл бұрын

    Great work! Loved it❤️

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

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

  • @nehakumarisingh2920
    @nehakumarisingh29203 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

    Thank you Neha!

  • @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...❤❤

  • @sujana4267
    @sujana42672 жыл бұрын

    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

    2 жыл бұрын

    Thank you Sujana!

  • @srem1971
    @srem19713 жыл бұрын

    Great explanation. Thank you!

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

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

  • @rev1198
    @rev11982 жыл бұрын

    Wonderfully explained.. Thanks 🙂

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you Revanth

  • @sarasong6019
    @sarasong60193 жыл бұрын

    Very helpful as always, thank you very much!

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

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

  • @princedelapaz9806
    @princedelapaz98062 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

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

  • @sameerabanu3115
    @sameerabanu31152 жыл бұрын

    beautifully explained

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you Sameera!

  • @kskchaitanya
    @kskchaitanya Жыл бұрын

    Commenting for reach. Very nice explaination.

  • @sqlbelle

    @sqlbelle

    Жыл бұрын

    Thank you so much Krishna!

  • @shisuili1524
    @shisuili15243 жыл бұрын

    Nice done! This worth more views!

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

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

  • @wwpharmacist
    @wwpharmacist Жыл бұрын

    Sure, very very useful 🎉

  • @ushasuresh81
    @ushasuresh813 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

    Thank you Usha, I hope you found it useful!

  • @giuliko
    @giuliko2 жыл бұрын

    Another stunning lesson. Keep up the great work. 🤓

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you Guiliko!

  • @AdrianaPerez-ev5cj
    @AdrianaPerez-ev5cj2 жыл бұрын

    Great video. Very well explained!

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you Adriana :)

  • @sabeenamahmud8921
    @sabeenamahmud89212 жыл бұрын

    wow, great explanation. Worth watching it.

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

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

  • @anaghadamame196
    @anaghadamame1962 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you Anagha!

  • @datafreak911
    @datafreak91110 ай бұрын

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

  • @khuntiaachyutanan7316
    @khuntiaachyutanan7316 Жыл бұрын

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

  • @ballyb1
    @ballyb12 жыл бұрын

    Great video ...

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you Balvinder!

  • @AliciaMarkoe
    @AliciaMarkoe3 жыл бұрын

    Excellent, thank you 🌺🦋🌼

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

    Thank you Alicia! Hope you found it useful!

  • @sreehari6323
    @sreehari63232 жыл бұрын

    VERY USEFULL , THANKS FOR THE VIDEO

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you Sree!

  • @sreddibathuni
    @sreddibathuni2 жыл бұрын

    Thanks!

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you so much Srinivasa!

  • @rajashekarn2000
    @rajashekarn20003 жыл бұрын

    As always,nice explanation.:)

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

    Thank you Rajashekar!

  • @geraldrealubit1949
    @geraldrealubit1949 Жыл бұрын

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

  • @teenuptanvee
    @teenuptanvee3 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

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

  • @teenuptanvee

    @teenuptanvee

    3 жыл бұрын

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

  • @Data_Mom
    @Data_Mom3 жыл бұрын

    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.

  • @RameshCh-me8jm
    @RameshCh-me8jm2 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you, will do!

  • @TheOGizabellie
    @TheOGizabellie3 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

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

  • @sudhasree9306
    @sudhasree93063 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

    Thank you Sudha 🙂

  • @neelnickkey4865
    @neelnickkey48652 жыл бұрын

    Thank you @sqlbelle !!!c

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you Neel!

  • @Data_Mom
    @Data_Mom3 жыл бұрын

    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 жыл бұрын

    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.

  • @venkatc1323
    @venkatc13233 жыл бұрын

    👌👌👌👌👌👌, keep going on

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

    Thank you Venkat!

  • @anushadavuluri5558
    @anushadavuluri5558 Жыл бұрын

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

  • @ValerieFomenko
    @ValerieFomenko2 ай бұрын

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

  • @sqlbelle

    @sqlbelle

    2 ай бұрын

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

  • @harigondhipalli1777
    @harigondhipalli17772 жыл бұрын

    super madam

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you Hari!

  • @chawar123
    @chawar123 Жыл бұрын

    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??

  • @rebekahalvarez8627
    @rebekahalvarez86272 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

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

  • @rebekahalvarez8627

    @rebekahalvarez8627

    2 жыл бұрын

    @@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! 😀😅

  • @cocoon757
    @cocoon7573 жыл бұрын

    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 жыл бұрын

    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)?

  • @meshell7987
    @meshell79872 жыл бұрын

    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

    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

    2 жыл бұрын

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

  • @sobersabin
    @sobersabin3 жыл бұрын

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

  • @sqlbelle

    @sqlbelle

    3 жыл бұрын

    Thanks Sabin! Do you mean indexes in relational databases?

  • @ni12907
    @ni129073 жыл бұрын

    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 жыл бұрын

    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. kzread.info/dash/bejne/lXuVmbN9ldjLhKQ.html

  • @ni12907

    @ni12907

    3 жыл бұрын

    @@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 жыл бұрын

    @@ni12907 That's great to hear.

  • @AJ-bd8os
    @AJ-bd8os2 жыл бұрын

    Can we combine a static set and dynamic set

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Hi AJ - yes we can

  • @AJ-bd8os

    @AJ-bd8os

    2 жыл бұрын

    @@sqlbelle Thank you

  • @Happy_Stomach
    @Happy_Stomach2 жыл бұрын

    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 ?

  • @rubengeertvandenberg3336
    @rubengeertvandenberg3336 Жыл бұрын

    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_Stomach2 жыл бұрын

    Can u help me plz of my comment

  • @halleluyahpaul3334
    @halleluyahpaul3334 Жыл бұрын

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

  • @GrandizerIntali9
    @GrandizerIntali92 жыл бұрын

    Amazing explanation, thank you !

  • @sqlbelle

    @sqlbelle

    2 жыл бұрын

    Thank you Ham!

Келесі