Tableau Blend vs Join vs Relationship (Data Model) Explained - Part 2 | sqlbelle

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ส.ค. 2024

ความคิดเห็น • 228

  • @ushasuresh81
    @ushasuresh81 3 ปีที่แล้ว +29

    Thank you for the detailed explanation.
    The information given are very clear and easy to understand and remember.
    You narrate it like a story. Awesome skill. I have watched all your videos.
    Do upload videos on advance concepts as well. Thanks again..

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +4

      Thank you so much for your comment Usha! I am happy to hear you found it useful! 🙂

    • @mychaelvo7597
      @mychaelvo7597 ปีที่แล้ว

      Totally agree. Awesome skill!!!!!!!!!!!!!!!!!!!!!!!!

  • @PatrickBateman12420
    @PatrickBateman12420 3 ปีที่แล้ว +12

    21:55 is pure genious! "Use relationships if you can, join if you must, blend if you absolutely must."

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +2

      Thanks Franco! Lots of new features and improvements allow us to work around the blends. And given it's limitations, I find it's best to leave it as last option 🙂

    • @pradeepp9126
      @pradeepp9126 3 ปีที่แล้ว +1

      @@sqlbelle Seriously, You have a special gift for narrating things crisp and clear, I don't feel it like a tutorial it's like a journey us through all depths and heights, keep rocking!!! Thank god I found your channel :-P

  • @visheshsekhsaria4323
    @visheshsekhsaria4323 3 ปีที่แล้ว +8

    I hvnt seen anyone in my life explaining things so vividly and in such a easy way..
    Hatss off sqlbelle.
    Keep posting👍🏻👍🏻

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +2

      This is such a kind note, thank you Vishesh!

  • @gujarmahesh21
    @gujarmahesh21 3 ปีที่แล้ว +5

    Best tutorials I ever watched, the way you present everything a non-tech person will also understand!! thank you very much for bringing this knowledge hub to us.

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you Mahesh for the kind comment. I am happy to hear you found this video helpful!

  • @jafetcalderon9505
    @jafetcalderon9505 3 ปีที่แล้ว +4

    You are a light in my dark path of data analysis

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you Jafet. I am happy if the videos are helping in your data analysis 🙂

  • @natelaning2610
    @natelaning2610 2 ปีที่แล้ว +3

    As a recent convert from Power BI, the video segment on relationships was invaluable! I finally had an "Oh, I get it!" moment. My mind started seeing what I had been familiar with in Power BI, but in Tableau language. Thank you so much! Love the videos! I might have to get your advice at the end framed and hung in my office. :)

    • @4evaism
      @4evaism ปีที่แล้ว

      I share the sentiment. This is exactly the Aha moment of tableau

  • @englishexpress948
    @englishexpress948 3 ปีที่แล้ว +1

    The More , I am watching your video the more I deep dive in tableau expertise. What a champ you are . Love your content , Love your voice and love your explanation . God bless you Madam.

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว

      Thank you for your very kind comment, I appreciate it!

  • @swati12yeola
    @swati12yeola ปีที่แล้ว +1

    this is absoulately crystal clear explaination covering all aspects..a big thank you !

    • @sqlbelle
      @sqlbelle  ปีที่แล้ว

      Thank you Swati!

  • @AJaditya123
    @AJaditya123 3 ปีที่แล้ว +3

    Wow, what a superb explanation. This is just what i was looking for. When i started with tableau, I always happen to find duplicates when i have different data sources, so my always go to action was to fix duplicates at database level, create a view / table and use it as a single table , for this i need data engineers to move all my data sources into one database( could be Redshift or snowflake) which took a lot of time, now by using relationships , i can use them on the go without any issues. Secondly, i can answer different business questions by changing my primary and secondary table in the data viz itself, No need to go back to data source.

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +2

      Thank you Aditya, I am happy to hear it was helpful.
      I think relationships are a game changer, the same way LODs were a game changer when it was first introduced. I am excited to see all the new features and improvements that are planned for the product for the coming year.
      Happy New Year! 🙂
      Donabel

  • @AbhishekKumar-xd3qq
    @AbhishekKumar-xd3qq 2 ปีที่แล้ว +1

    Thanks sqlbelle your efforts are not just supporting individual lives to change but helping them to come out of poverty line .I think most of the people don't afford to get even paid online course but you are just providing free support .Thanks god bless you and your family . We hope if you could post tableau projects for entry level jobs .

  • @irshadkhan-fv5nt
    @irshadkhan-fv5nt 2 ปีที่แล้ว +1

    she is absolutely great teacher and blessing for tableau students.

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +2

      Thank you so much for your kind comment Irshad!

  • @nickomartinez1250
    @nickomartinez1250 3 ปีที่แล้ว +2

    Another crystal clear explanation from Ms. Belle. 👏

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว

      Thank you for your kind comment, Nicko! I am glad you found the video helpful!

  • @beeaeey
    @beeaeey ปีที่แล้ว

    The best relationship explanation I have ever seen! Thank you so much!

  • @nukestrom5719
    @nukestrom5719 5 หลายเดือนก่อน

    Superb explanation. The only 'make sense' explanation I found on youtube

  • @neerajsehtya7700
    @neerajsehtya7700 2 ปีที่แล้ว +1

    Wow!
    This is so clearly explained. I take a bow for your knowledge, teaching and intent to share. Without a shred of doubt, your videos are easiest to understand and most exhaustive.
    Thank you so much :)

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you Neeraj!

  • @wasimkotwal1889
    @wasimkotwal1889 ปีที่แล้ว +1

    Thank you- I was much confuse about this topic and was browsed # of video in youtube but still was not able to understand, But this time with your way of explaning i can say i completely grabs topic very clearly thank you so much please keep updating further.
    #LOVE FROM BANGALORE, INDIA#

    • @sqlbelle
      @sqlbelle  ปีที่แล้ว +1

      Thank you so much Wasim!

  • @midunsathiyamoorthy593
    @midunsathiyamoorthy593 ปีที่แล้ว +1

    Pretty well defined... Only after this video I'm clear with this topic.. Thank you🌹❤

    • @sqlbelle
      @sqlbelle  ปีที่แล้ว +2

      Thank you @midunsathiyamoorthy593

  • @allenklingel5669
    @allenklingel5669 ปีที่แล้ว

    You are a very talented teacher with great pace. Thank you.

  • @tarunpavada427
    @tarunpavada427 3 ปีที่แล้ว +2

    Best video with detailed explanation. This helped me a lot to understand the concepts

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว

      Thank you for your comment Tarun, glad it helped!

  • @sinchanashanthakumar6967
    @sinchanashanthakumar6967 2 ปีที่แล้ว +1

    A big thank you to you to explaining this complex relationships concept! Very clearly explained!!

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you Sinchana!

  • @Guna_cocktail
    @Guna_cocktail 3 ปีที่แล้ว +1

    Another great presentation on this topic . you made it simple and easier to understand when to use. I like this "Use relationships if you can, join if you must, blend if you absolutely must"
    . I am going to watch all your videos.. learn more. Expecting your next video and topic. Thank you so much!

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you so much for your very kind and supportive feedback, Guna. Much appreciated!

  • @rajeshraj-sk8nn
    @rajeshraj-sk8nn 2 ปีที่แล้ว +1

    Thanks for your well structured explanation , Expecting More Videos...

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you Rajesh!

  • @agermoune
    @agermoune 3 ปีที่แล้ว +1

    Thx Donabel for keeping your word and tackling this essential subject in Tabkeau 2020.2. I know it's a holiday season yet you still find time to make hard easy for your followers.
    Was hoping you can clarify the Cardinalliy and integrity features but was happy to hear you saying you will in a separate video.
    I like your way of keeping us tuned up to your channel 😊
    Love the last quote in the Video!

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you for your comment Abderrahim! Happy to hear it was helpful!
      Yes I think it might be good to tackle the performance options separately so I can show the differences when you choose one over another. Hoping to have that in the next few videos.
      Happy New Year!
      Donabel

  • @vijayataw
    @vijayataw ปีที่แล้ว

    Dear, I must say your videos are so easy to understand and covers even littlest of the details... Has anyone observed how cover pic of part 1 of this video highlights 'Blend' as that part covers only blend but part 2 highlights join and relationship words, as they are included in video... It makes so easy to pick a video for re-watch.. well done and lots of encouragement to you!!!

  • @rajashekarn2000
    @rajashekarn2000 3 ปีที่แล้ว +1

    Best video on relationships and joins i hav come across...thanks a lot

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you Rajashekar!

  • @jakubg1267
    @jakubg1267 2 ปีที่แล้ว +1

    This is extremely helpful tutorial together with part 1 reg blending :) Thank you so much! I need to check your other videos. Please keep up the good work!

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you Jakub! I appreciate your comment :)

  • @chethankalappa9880
    @chethankalappa9880 2 ปีที่แล้ว +1

    Best Explanation Ever. I love the way u explain.

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you Chethan!

  • @arjunnag7348
    @arjunnag7348 2 ปีที่แล้ว +1

    Before watching this video, I had multiple doubts and confusion on this topic. Now, I am very confidence on it and easily can decide at my work environment. Thank you so much..

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      So glad to hear, thank you Arjun!

  • @CristopherMardones
    @CristopherMardones 2 ปีที่แล้ว +1

    A great explanation for these daily decisions!! Thanks

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว

      Thank you Cristopher!

  • @enyacat7
    @enyacat7 ปีที่แล้ว +1

    thanks for the explanation, after watching I thought it should be blend over join if possible but you seem to favour join at the end.

    • @sqlbelle
      @sqlbelle  ปีที่แล้ว +1

      Thank you Enyacat. Yes - blends and joins are for two different use cases, and where possible, the hierarchy would be
      1. Relationship
      2. Join
      3. Blend

  • @mehulsoni2300
    @mehulsoni2300 3 ปีที่แล้ว +1

    this video deserve tons of likes and subscriptions...

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +2

      Thank you so much Mehul!

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +2

      Thank you Mehul! This is such a nice comment, thank you :) I do hope more can watch it :)

  • @shashankworldpeace
    @shashankworldpeace 3 ปีที่แล้ว +1

    You are a great educator. The way you explain the things is just amazing. Please try uploading a video on covering all these in a scenario based case study where we have multiple data sets and we have to use relationships + (Joins or blend) and some common mistakes we do while building the viz.

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      These are great suggestions, thank you Shashank!

  • @spp2000
    @spp2000 2 ปีที่แล้ว +1

    Fantastic explanation and very well articulated!! I'm lucky people like you are out there are making life easier for people like me :)

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you SP, I am glad you found it helpful.

  • @kranthikumar9231
    @kranthikumar9231 3 ปีที่แล้ว +2

    Every learner expects this kind of explanation. Thank you so much for your time and knowledge mam. Waiting for video on "cardinality and referential Integrity".

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you Kranthi! Appreciate your comment :)

  • @sindhujagurajala5625
    @sindhujagurajala5625 3 ปีที่แล้ว +1

    Wow... I cud c d amount of effort that was put in to make this... Just wow... N d explanation is fantastic..
    U hf no idea how much u r helping us.. thank you soo much..

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      So happy to hear Sindhuja. Happy to hear you are finding the videos helpful :)

  • @kritisharma8359
    @kritisharma8359 2 ปีที่แล้ว +1

    You are bested Tableau Teacher. Thank you so so much for amazing videos. I am so grateful and thankful to you, you are doing amazing job ❤️😇

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you Kriti! I very much appreciate your note! :)

  • @tarun007
    @tarun007 3 ปีที่แล้ว +1

    We absolutely enjoyed the video..!!!

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      That's great to hear, thank you Tarun!

  • @AdrianaPerez-ev5cj
    @AdrianaPerez-ev5cj 2 ปีที่แล้ว +1

    Very well explained. You are a great teacher!

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you Adriana!

  • @sunil.k.maurya
    @sunil.k.maurya ปีที่แล้ว +1

    It is the best session I have ever seen, thanks so much for the content & presentation. I have also followed you on Tableau Public. :)

    • @sqlbelle
      @sqlbelle  ปีที่แล้ว +1

      Thank you Sunil!

  • @rameespudussery2700
    @rameespudussery2700 2 ปีที่แล้ว +1

    Superb. Liked the way you explain. Thanks

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you Ramees

  • @kushangnagardhankar2547
    @kushangnagardhankar2547 ปีที่แล้ว

    It helped me a lot ☺️ Thanks a lot for making this video and explaining it so beautifully

  • @rasikadhanapala5354
    @rasikadhanapala5354 2 ปีที่แล้ว +1

    Excellent explanation

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you Rasika

  • @sivasrikar
    @sivasrikar 3 ปีที่แล้ว +1

    Thanks Belle.. you are the best ! very detailed explanation.

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +2

      Thank you Siva! Hope you found it useful!

  • @vdn5716
    @vdn5716 3 ปีที่แล้ว +2

    As always the best teacher ...thanks a lot a lot...very very usefullllll....

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you so much VDN, so happy to hear you found it useful! 😊

  • @jayasreecarey7843
    @jayasreecarey7843 3 ปีที่แล้ว +1

    thanks again for detailed explanation !!! Eagerly waiting for Part -3 (Performance Options) on this topic :).

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you Jayasree :)

  • @abhishekarora1
    @abhishekarora1 3 ปีที่แล้ว +2

    You explained the concept very simply. Pls make video to explain performance options in relationship

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you Abhishek! That is a great suggestion. I will definitely try to include that in one of the next videos.

    • @abhishekarora1
      @abhishekarora1 3 ปีที่แล้ว

      @@sqlbelle I will look forward to it...

  • @adityawalia9
    @adityawalia9 2 ปีที่แล้ว +1

    Thank you for the detailed explanation.

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว

      Thank you Aditya!

  • @mehulsoni2300
    @mehulsoni2300 3 ปีที่แล้ว +1

    very well organised way to describe various concepts. I definitely suggest everyone watch this awesome content....awesome.

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +2

      Thank you for your kind comment Mehul!

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +2

      Thank you so much for your kind comment, Mehul! Much appreciated :)

  • @paspas12
    @paspas12 2 ปีที่แล้ว +1

    What a great explanation

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you Paspas!

  • @thyvivek
    @thyvivek 2 ปีที่แล้ว +1

    Super video. Thanks for your efforts..Very clear..

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you Vivek, glad you found it helpful.

  • @sayakpalit3615
    @sayakpalit3615 2 ปีที่แล้ว +2

    Best tutorial 👌👍

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +2

      Thank you Sayak!

  • @ashokkambham323
    @ashokkambham323 2 ปีที่แล้ว

    Most beautiful demonstration I have ever seen. Kudos. It would be really great if access is provided to download these excel datasheets for practice purpose.

  • @mrinalpaul4278
    @mrinalpaul4278 3 ปีที่แล้ว +1

    Very good content ...Now I am clear about the blend , join and relationship ...Thanks mam😊

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you Mrinal, I am glad you found the video helpful! 🙂

  • @maheshbarma
    @maheshbarma 3 ปีที่แล้ว +2

    Hi Belle..Thank you so much ! very detailed explanation, and it is vary useful, keep posting. :)

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +2

      Thank you Mahesh! Glad you found the video useful! 🙂

  • @aniketjamode5290
    @aniketjamode5290 2 ปีที่แล้ว +1

    Great Video....Explained very well.Thank you

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +2

      Thank you Aniket

  • @Atlas-ck9vm
    @Atlas-ck9vm 3 ปีที่แล้ว +1

    This is a masterpiece video

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you Atlas!

  • @shubham7564
    @shubham7564 23 วันที่ผ่านมา

    Very Helpful, Thank You.

  • @diyaunarker7471
    @diyaunarker7471 3 ปีที่แล้ว +1

    awesome explanation

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you Diya!

  • @piyushpathak7311
    @piyushpathak7311 3 ปีที่แล้ว +1

    Mam we want more advanced concept like this plz keep uploading..

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you for your comment Piyush! 🙂

  • @peterparker4358
    @peterparker4358 3 ปีที่แล้ว +1

    Thank you for the nice explanation Mam. really loved it and made my concept more clear.

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +2

      Always appreciate your comments and support, Peter! 😊

  • @tzelichonok
    @tzelichonok 2 ปีที่แล้ว +3

    Great video as always! I'd like to know, Donabel, what would be the best way to convert a complex dashboards from blending to relationships?

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you Tanya! I don't think there's an easy button though to convert from blending to relationships because it works different ways (for example, you will need one data source instead of multiple). You may need to re-create some of them, but it might be a good thing as it can also allow you to take advantage of other newer features in Tableau.

  • @152kiran
    @152kiran 3 ปีที่แล้ว +1

    Excellent !

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you Kiran!

  • @joycwang
    @joycwang 2 ปีที่แล้ว +1

    cleared all my confusions thank you! It is impossible to learn by just reading official online documentation and even the official tutorials don’t explain the concepts clearly, I wonder why that’s the case…

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว

      That's great to hear, thank you Jia! Glad to hear you found the video helpful!

  • @sivakumarreddy2118
    @sivakumarreddy2118 ปีที่แล้ว

    Great Explanation,
    can you create a video on improving the performance of the dashboard connected to a live data source?

  • @anil_ind
    @anil_ind 3 ปีที่แล้ว +1

    Vary welll explained as always. Thank you.

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Glad it was helpful, Anil! 🙂

  • @sunilvedantam8698
    @sunilvedantam8698 3 ปีที่แล้ว +1

    Hi, Could you please post a videos about cardinality and referential integrity? Also, could you please post a video explaining very clearly about the diagram that you have shown in the video for relationships(please take an example for each of the element in the diagram). I think your explanation is just out of the world.

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you for the great suggestions Sunil!

  • @rashmikadre8900
    @rashmikadre8900 2 ปีที่แล้ว

    This is just Awesome!! Thank you so much!

  • @DanielWeikert
    @DanielWeikert 3 ปีที่แล้ว +1

    Thanks. Have you dived deep into relationships? So e.g. why does it matter which table you first drag into Tableau when setting up your "relationship" model?
    What if there are multiple fact tables and you need to have the same dimension tables twice in your model?
    Have you experienced any strange behavior so far?
    Would highly appreciate more on this as the documentation and videos (at least I found so far) are not addressing these question in detail enough for me.
    best regards and take care

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you for your note Daniel, and these are great points.
      I am not able to address some of the why's of Tableau as I am not privy to those, but I can understand why they may have chosen to go this route.
      Perhaps there are different ways to tackle this. In my projects I would handle drill across in fact tables using multiple views from the database end. I would be wary of having a different tool automatically handle this especially if the dimensions are used in different kinds of fact tables (transactional vs periodic for example). I would opt to do the joins within the database itself and expose as a view for Tableau because it provides more control, and will allow me to address nuances of my specific datasets outside of Tableau.
      I will take advantage of Tableau's features like Joins, Blends, Relationships on smaller data sets, but wherever I can I would data cleaning and modeling to the data source. Often my data sources are powerful/resource-heavy enough to handle the cleaning/modeling with more ease than Tableau.
      I am not sure if this is helpful, but just wanted to share with my own thoughts and strategies.

  • @srinivasangajendran
    @srinivasangajendran ปีที่แล้ว

    super explanation.. Thanks !

  • @Rkcuddles
    @Rkcuddles ปีที่แล้ว

    Omg finally a good, really well done example of why relationships are so important in terms of making analytics more accessible.
    Follow up question on your parting advice. How do we create relationships between published data sources?
    So let’s say, I have customers and orders and products all nicely related and I publish the extract to be refreshed daily. My colleague is analyzing delivery estimates which are a function of order total and customer membership tier. They don’t want to also create the same relationships that I already setup, and they just went to add some more to it… is blending just the best option in that scenario?

  • @DeveshGarg-ng2dp
    @DeveshGarg-ng2dp ปีที่แล้ว +1

    Can I get those 3 excel sheets to practice the same things on my PC ? That would be really helpful.

  • @kiranjadhav1117
    @kiranjadhav1117 3 ปีที่แล้ว +1

    Amazing explanation ❤️

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you Kiran! 🙂

  • @niteshsingh4377
    @niteshsingh4377 2 ปีที่แล้ว +1

    superb ....mam do uploads dataset as well with your videos.

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว

      Thank you for the suggestion Nitesh!

  • @saikrishnapagadala7449
    @saikrishnapagadala7449 2 ปีที่แล้ว

    Quite informative video. We understand that blending is useful to play with data from different data sources. However the cross data base Joins or Relationships can solve the purpose but comes with a few limitations. Can you please make a video on to deep dive in knowing the difference between Cross database Joins/Relationships vs data blending?

  • @mukulbajpai8036
    @mukulbajpai8036 2 ปีที่แล้ว +1

    Thanks for sharing this but can you make video on Context filter Advantage and disadvantage and how many context filter we can use in tableau ,so that performance is not affected

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you for the suggestion Mukul!

  • @pokalarajesh8636
    @pokalarajesh8636 2 ปีที่แล้ว

    Wow… this is really nice. It helps a lot. Can you provide same datasets (3 excels) which you being used in this tutorial is really appreciated.

  • @Data_Mom
    @Data_Mom 3 ปีที่แล้ว +1

    Good explanation of a complex Tableau topic. Please share the dataset if possible Donabel, would like to practice the concept.

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you Pooja, I will upload the workbook with data sets to Tableau public. I'll let you know when it's there :)

    • @mahmoudhamza6765
      @mahmoudhamza6765 2 ปีที่แล้ว

      @@sqlbelle great video as usual
      a kind reminder for sharing the dataset if possible

  • @whocares_today
    @whocares_today 3 ปีที่แล้ว +1

    Just Amazing!

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you Ivo!

  • @rahulhgupta
    @rahulhgupta หลายเดือนก่อน

    Query: At 9:00, you have used fixed LOD to show correct salary in joins example. If we use average of salary or min of salary or max salary without LOD that's also gives same result. Is there any specific reason to use LOD here?

  • @saikumareppakayala
    @saikumareppakayala ปีที่แล้ว

    I have understood the concept but how to explain in interview if asks when to choose joins and relationships?

  • @anilsaka7142
    @anilsaka7142 2 ปีที่แล้ว +1

    excellent

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you Anil!

  • @adityacaroli2375
    @adityacaroli2375 2 ปีที่แล้ว +1

    Hey, in data relationships, is there a way to connect two tables that are already connected to two different tables? (like it can be done in PowerBI by a simple drag & drop)

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Hello Aditya - do you mean to pull all related fields automatically? No this option does not exist at this point in Tableau.

  • @Mohammad-rz7oj
    @Mohammad-rz7oj 2 ปีที่แล้ว

    This is a awesome video.
    Could you please let me know like how to handle Measures while using relationships.
    Tableau by default applying left join when we pull measures from more than 1 table. which we need to filter out the data later. i am looking for a way to fix this issue without using filters. It will be great for me if you can share few tips related to this.

  • @wasimkotwal1889
    @wasimkotwal1889 ปีที่แล้ว +1

    I request you to post tableau project with all use cases? waiting for it eagarly

  • @TeluguTraveller1
    @TeluguTraveller1 3 ปีที่แล้ว +2

    You're amazing👍🏻

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +2

      Thank you! Hope you found the video helpful!

  • @pratikr3970
    @pratikr3970 3 ปีที่แล้ว +1

    I didn't understand what do you mean by "CUSTOME" + in the edit calculation field.

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thanks Pratik. The other data set's IDs are different from the other data set.
      If you take a look at 1:13 - one data set has:
      CUSTOMER01
      CUSTOMER02 etc
      The other data set's IDs are:
      R01
      R02
      etc
      Hope this helps!

  • @benagyemang6701
    @benagyemang6701 11 หลายเดือนก่อน

    @sqlbell.
    For practice purposes is possible to attach the exact data sets you use for
    each video?

  • @eddyjo3259
    @eddyjo3259 3 ปีที่แล้ว +1

    Happy New Year Donabel!!!

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Happy New Year Eddy!!! 😀

  • @syediftekhar9517
    @syediftekhar9517 2 ปีที่แล้ว

    When you mentioned, "the solution was to create multiple data sources" (at 11:32) was to use data blending option? BTW, love your videos!!!

  • @kirtisardana8479
    @kirtisardana8479 2 ปีที่แล้ว +1

    Enlightened :)

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you Kirti!

  • @srikanth.gaddam
    @srikanth.gaddam 2 ปีที่แล้ว

    Actually i created a relationship between Orders and Returns from sample super store dataset on OrderID field,we have 5009 unique orders and 296 returns ,but when i am dragging Order ID from Orders and Returned field from Returns Tableau is showing only 296 fields,this should not happened right

  • @NaveenKumar-ig6gn
    @NaveenKumar-ig6gn ปีที่แล้ว

    Can relationships are used to join data from multiple data sources

  • @Earl_roy
    @Earl_roy ปีที่แล้ว

    is it correct that using Join will solve the * issue in blend? Because in join, there is only 1 database (no primary or secondary)?

  • @srini368
    @srini368 2 ปีที่แล้ว +1

    I follow all your videos, thanks for your time!
    It would be great if you cant try to not have bgm

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thank you Srinivasan! All of the later tutorials don't have background music, as I've heard this feedback from others as well. I appreciate your note.

  • @sampathkumarreddy4354
    @sampathkumarreddy4354 2 ปีที่แล้ว +1

    i had a doubt on below statement can you explain .. its from tableau help page
    relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online.

    • @sqlbelle
      @sqlbelle  2 ปีที่แล้ว +1

      Thanks Sampath. I think you are correct that this is still the case (as per: help.tableau.com/v2020.2/pro/desktop/en-us/relate_tables.htm)
      It means that if you connect to a Tableau Server data source for your tables, you cannot establish relationship between those tables .. or at least they are not supported yet

    • @sampathkumarreddy4354
      @sampathkumarreddy4354 2 ปีที่แล้ว

      I don't understand the statement can u clearly explain...
      If possible please make a video's on Tableau online and server .. please.

    • @sampathkumarreddy4354
      @sampathkumarreddy4354 2 ปีที่แล้ว

      when we are publishing report (embedded in or published separate)on Tableau online or service ...if we publish separate data source and report are in different folders right. By using published separate data source we cannot form relationship ...
      Am I correct

  • @nareshtekchandani2188
    @nareshtekchandani2188 10 หลายเดือนก่อน

    Hi,
    Can you provide the link for excel file that you used here for Joins and Relations and blend?

  • @rebekah0207
    @rebekah0207 3 ปีที่แล้ว +1

    Great video. Just wish didn't have background music, it's a little distracting.

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Thank you Rebekah. I received that feedback as well from a number of viewers, and have removed the music in the later videos. It was early on when I was just starting to publish, and was trying to learn from other TH-camrs :) ... now, lesson learned :). Thank you for your note!

  • @saikumareppakayala
    @saikumareppakayala ปีที่แล้ว

    Could you provide datasets to practice?

  • @AJaditya123
    @AJaditya123 3 ปีที่แล้ว +1

    Hi Belle,
    Is it possible to share the Excel, I wanted to test use case at 17.10, what if I want to add product ID and next to it the Salary earned by Customers? To know, what is the range of salaries of customers who are buying particular products. I believe the tableau will again do a sum(salary) if I have a customer buying a product more than once. In this case, can we use again FIXED LOD?

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +2

      Thank you Aditya. I will post the data set. I will reply back here (and add to description) once I add the data set

  • @akhtarhussain7088
    @akhtarhussain7088 3 ปีที่แล้ว +1

    Hi Belle,
    Please guide me on this question. If possible please do some videos on real time scenario base.
    1- I want to share the dashboard to my 3rd party client? So, in which format can ?
    Thank you

    • @sqlbelle
      @sqlbelle  3 ปีที่แล้ว +1

      Hi Akhtar - you have a few options:
      - Tableau Online (if you can publish your data set on the cloud)
      - Tableau Reader (you can send them the twbx file, and ask them to download Tableau reader nd view it from there)
      These will depend on the security requirements you have for your dashboard