Respect!! Blend is not an easy material to explain, but this video made so easy to grasp. Your database background is making you such a great instructor. The left join, aspect of the Blend, primary data source, and aggregation to the blended second data source were the missing point that you tackled here very explicitly. Can't wait for the relationship tutorial week
@sqlbelle3 жыл бұрын
Thank you so much for your note abderrahim. 🙂 This is also a product of struggling with blends earlier on. I am quite happy that there are better and easier ways to deal with combining data now (LODs and Relationships take a lot of the pain away)
@monikadileep17312 жыл бұрын
@@sqlbelle Can blending be done within same datasource
@akshaykharche52032 жыл бұрын
@@monikadileep1731 no we can use join for that!
@zakirhussain41939 ай бұрын
Yes.. It is possible..@@monikadileep1731
@havefundrawing3 жыл бұрын
I’ve never heard anyone explaining blend so clearly!
@sqlbelle3 жыл бұрын
Thank you for your comment! Glad you found the video useful :🙂
@romyli51593 жыл бұрын
Thanks belle! I was often confused about the use case of blending. Now you've made it really clear. Great video!
@sqlbelle3 жыл бұрын
Thank you Romy, I am happy to hear that! 🙂
@aayushraj60108 ай бұрын
I have started learning tableau and then I found your videos on Data connection topics it is so nicely explained with examples. thanks for making such videos
@vuphan29563 жыл бұрын
This is the best explanation about data blending I've ever watched, very clear and very knowledgeable. I actually enjoy all the video you posted. Thank you.
@sqlbelle3 жыл бұрын
Thank you, Vu! SO happy to hear that 🙂
@just39633 жыл бұрын
This is probably the best explanation available online. I am new to Tableau and felt overwhelmed by most of these new concepts but watching your videos has helped me so much! Thank you!!
@sqlbelle3 жыл бұрын
So happy to hear you found the video helpful, Albert :) .. Tableau is a wonderful tool, but it does get overwhelming sometimes - even for people who may have used it for years. It has a great community though! Happy Tableau'ing!
@onambhanot70882 жыл бұрын
I never usually subscribe or comment.. but your lucid explanation made me do that.. your channel is so underrated..more people should subscribe.
@sqlbelle2 жыл бұрын
I really appreciate your feedback Onam, thank you.
@dudehe7117 Жыл бұрын
This video has the clearest description of what data blending is. It essentially is a left join of the primary data.
@drummersaad Жыл бұрын
Hands down the best place to learn Tableau on the internet. Thank you once again.
@TonyChangTaiwan3 жыл бұрын
I started to learn Tableau 6 months ago and I had watched this video a few times in the past. After 6 months, I am watching this video again and many things make better sense to me! Your Tableau videos are the best in class! Thank you!
@sqlbelle3 жыл бұрын
Thank you Tony! :) Appreciate your kind comment and feedback!
@shisuili15243 жыл бұрын
Belle's videos are so well produced. It's an enjoyment to watch them.
@sqlbelle3 жыл бұрын
Thank you Shisui!
@ricardoosorioflota56843 жыл бұрын
OMG! what an easy way to explain Blend. Congratulations!
@sqlbelle3 жыл бұрын
Thank you Ricardo! 🙂
@neilvanasselt71073 жыл бұрын
Pure Gold, understanding how blends work and the difference between the primary and secondary data source. Fantastic channel, packed with top info. Well done !
@sqlbelle3 жыл бұрын
Thank you so much for your feedback Neil, so happy to hear you found the video useful! 😀 - Donabel
@neilvanasselt71073 жыл бұрын
@@sqlbelle Please could you add a download link to the two spreadsheets you use.
@ganeshjayavarapu3 жыл бұрын
I have watched so many videos.. But urs could be the best video if I want to suggest anyone. Take a bow for ur explanation. Became fan of your lecture.
@sqlbelle3 жыл бұрын
Thank you Ganesh! I appreciate your very kind note.
@ni129073 жыл бұрын
Amazing explanation on Blend. Although I have used tableau before but I didn't know that blend is a left join. Only one suggestion, please reduce the volume of background music. Thank you so much!
@sqlbelle3 жыл бұрын
Thank you Nishi! I will definitely adjust the background music, appreciate your feedback!
@adityawalia92 жыл бұрын
This was really helpful. Thanks! One small request. Since this is a video which is used by many as reference, would request you to please keep this updated as when Tableau makes any changes.
@sqlbelle2 жыл бұрын
Thank you Aditya!
@sasall53372 жыл бұрын
Great Video and super helpful. I was struggling exactly on the same issue of asterisks to understand why it is happening on my dashboard, and, now I got the answer.. Keep up the great work!
@sqlbelle2 жыл бұрын
Thank you sas all!
@niteshsingh43773 жыл бұрын
you don`t know how your solving my these issues so deeply.........love you always.
@sqlbelle3 жыл бұрын
Thank you Nitesh!😀
@snehalall97243 жыл бұрын
By far the best tutorial for Blend. Thank you so much.
@sqlbelle3 жыл бұрын
Thank you Sneha!
@jeffrey6124 Жыл бұрын
The Level of Detail of the explanation is a Primary 🤓 distinction from the rest making other videos Secondary 😎👏👏👏
@vickybisht41202 жыл бұрын
This is amazing. I am big fan of how you explain things so easily which makes everything so simple. Thanks a lot
@sqlbelle2 жыл бұрын
Thank you Vicky!
@GeraBizuneh3 жыл бұрын
You are an excellent instructor ! Super helpful, thank you for sharing !
@sqlbelle3 жыл бұрын
Thank you for your kind comments, Gera, and I am happy to hear you found the video helpful!
@neerajsehtya77002 жыл бұрын
Excellent! Excellent! Excellent! Truly, the best video on Blend :) Thank you very much for creating this video.
@sqlbelle2 жыл бұрын
Thank you Neeraj!
@panchalrht3 жыл бұрын
I was searching for this kind of explanation from a month . Thanks a lot mam :)
@sqlbelle3 жыл бұрын
Thank you Rohit! Hope you found the video helpful!
@adityagupt3314 Жыл бұрын
Fan of your teaching from India..love your videos as it is making more clear about data.
@kirtisardana84793 жыл бұрын
Such a crisp n clear explanation Belle :) Thankyou for this !!!
@sqlbelle3 жыл бұрын
Thank you Kirti! Glad you found the video helpful!
@pum40413 жыл бұрын
Superb! Your explanation is super clear. I just start my new role as Analytics and watch many videos on youtube but your channel is super good!Thank you so much for great video and explanation. Love this channel!
@sqlbelle3 жыл бұрын
Thank you Pum! I appreciate you rcomment, and happy to hear you found the video and the channel helpffil :)
@152kiran3 жыл бұрын
i went through a lot of videos in the process of getting certified. This video is one use case on when to use blend...and pretty much tells everything about it very well. What i am saying is there is no need to go searching for other explanations after seeing this. You are good! Since you have done this so well...can you please do Tableau recommended other when to blend situations - when Data needs cleaning - when dealing with large amounts of data You already did data at different aggregation level and also cross DB is not supported when Cubes are in picture of Salesforce Data.
@sqlbelle3 жыл бұрын
Thank you so much for your comment and feedback Kiran! Happy to hear you found the video helpful! Appreciate your time and kind comment.
@padmagopalarathinam3 жыл бұрын
Huge fan of all your videos. Learning conceptually all the Tableau concepts from all of your videos.Please keep up the good work!!!. Can you please share the excel file /dataset you have used in this video for me to practice.Just started with this video
@sqlbelle3 жыл бұрын
Thank you for your kind comment Padma, and happy to hear you are finding the video useful.
@mtgmtgyoutube2213 жыл бұрын
That was a clear video on the Blend topic. Thanks a lot.
@sqlbelle3 жыл бұрын
Thank you MTG!
@sampathmedara84452 жыл бұрын
Your giving reply to every comment, it's great mam. May god bless you 🙏🙏
@sqlbelle2 жыл бұрын
Thank you Sampath. I try, and am trying not to miss some :)
@karanjeetsingh-z5m7 ай бұрын
Hats off to you! best video on yt on blends! Thank a ton. God bless you
@Pcahaaw5 ай бұрын
Thank you!!! Finally I understand Blends in Tableau
@sqlbelle5 ай бұрын
Thank you 🙏
@ducjoshnguyen3 жыл бұрын
You are amazing. I’ve taken paid courses online and I didn’t get this level of explanation.
@sqlbelle3 жыл бұрын
Thank you for your kind note Josh, and happy to hear it was helpful! :)
@dataspeaks4693 жыл бұрын
simply awesome way of explaining...expecting more from you in Tableau.
@sqlbelle3 жыл бұрын
Thank you for your comment Ranjith, appreciate it! :)
@cococnk388 Жыл бұрын
Thanks miss... I am really enjoying all your tutorials...
@sqlbelle Жыл бұрын
Thank you coco
@Rkcuddles Жыл бұрын
How am I just discovering your amazing content! Thank you so much for the fantastic explanation! Ps. There are those of us with a little sql knowhow but we just don’t know tableau…. it would be good if you used some of the language we are familiar with to help us recognize the topic. For anyone reading … It helps me to think about blending as just a sub query in the select statement. the ‘linking fields’ are whatever you would have put in your group by clause if you were writing the query. and whatever fields you are getting from the secondary table have to be aggregated in the select statement so product name won’t work, but the measure count(distinct product_name) can be used. Get it?
@vinaypratapsingh58152 жыл бұрын
Thanks Belle for providing great concept on these topics .... Could you also provide the excel sheet here? So that i can just practice it to get some hands on experience.
@smartsaik3 жыл бұрын
I have tremendous admiration for your work.. I have one small suggestion, please choose the background music which doesn't hinder our learning..previpis videos were perfect I had to struggle through this one...
@sqlbelle3 жыл бұрын
Thank you so much for your support and kind comment, Saikat. I have received the same feedback and have removed background music in the later tutorials. Hope you will find the later tutorials much easier to listen to!
@simmumuddana7922 жыл бұрын
Hi Sqlbelle. I follow your lessons regularly. A small request can you please do a lesson for Tableau Join
@sqlbelle2 жыл бұрын
Thank you Simmu! I have a Part 2 which discusses Join - is this what you're looking for? kzbin.info/www/bejne/fKXch4Csm9-hZ6s
@fusionarun3 жыл бұрын
Crisp and clear! Thanks!
@sqlbelle3 жыл бұрын
Thank you Arun!
@manishsathe83712 жыл бұрын
Just single word .. Excellent (100/100)
@fahimqureshi6696 Жыл бұрын
Great videos.Thank you. I wanted to follow the videos in a Workshop. Could you please provide a link to your 2 XL datafiles. Thanks
@kushangnagardhankar2547 Жыл бұрын
Absolutely beautiful video series 😍....A Must Watch Video series for beginners
@rajeevagarwal65192 жыл бұрын
Excellent video, you really explained very well what I was searching from a long time. Thanks a lot.
@hoosier-daddy46510 ай бұрын
EXECLLENT video. Finally understand blends!
@gauravtarapure48763 жыл бұрын
very precisely explained. Great work !
@sqlbelle3 жыл бұрын
Thank you so much Gaurav!
@fieryzou93213 жыл бұрын
Thank you so much for this video. The explanation is so clear and I now completely understand how blend works.
@sqlbelle3 жыл бұрын
So great to hear you found it helpful! Thank you for your comment Fiery!
@shilpajha38933 жыл бұрын
You explained everything very clearly !! Thanks a lot .
@sqlbelle3 жыл бұрын
Thank you Shilpa!
@tomix77772 жыл бұрын
A truly amazing explanation of blend functionality!!! However, the background music is way too loud and I find it distracting.
@sqlbelle2 жыл бұрын
Thank you Tomix7777 - I appreciate the feedback, and yes I've removed the background music for the later tutorials. Unfortunately there isn't any way for me to just swap videos in YT once they're published. I will probably try to re-create some of the earlier tutorials without the background music.
@huytruong2026 Жыл бұрын
Thank you for making such a great video. I think a big distinction between blend and join/relationship is the number of data sources. Blend requires at least two different data sources while join/relationship work on a single data source (but you can add multiple connections to it). When I started my Tableau journey, I was very confused about data sources and data connections. For example, if I have one Excel spreadsheet with two tabs, do I connect to it multiple times (each time is a new data source) or do I use join/relationship? Even if the data in these two tabs are not related in anyway, I can still create a dummy field in each tab and relate them. Or should I have two different Tableau workbooks, each workbook is for a different Excel tab? I hope the personal struggle I'm describing here makes sense. Anyways, regarding the material presented here, you highlighted the difference very well.
@gzuzchuy5052 жыл бұрын
Thank you so much for the information! Straight to the point and very clear. New subscriber here :)
@sqlbelle2 жыл бұрын
Thank you Jesus :)
@vdn57163 жыл бұрын
As always the best teacher ...thanks a lot a lot...very very usefullllll....
@sqlbelle3 жыл бұрын
Thank you VDN, I am glad you found it useful! 😊
@ALotThx3 жыл бұрын
Terrific content! Thank you sqlbelle
@sqlbelle3 жыл бұрын
Thank you Thomas! Hope you found it helpful! :)
@abhishekarora13 жыл бұрын
You explained it very beautifully. Thank you for such a great video!
@sqlbelle3 жыл бұрын
Thank you Abhishek! :) :) Happy to hear you found it helpful.
@plaidanalytics3 жыл бұрын
Great video, as always, sqlbelle!
@sqlbelle3 жыл бұрын
Thank you for your support, as always, Andrew!
@Gdesplanque2 жыл бұрын
Thanks a lot, very clear. Now I know how to solve the issue I had!
@sqlbelle2 жыл бұрын
That's great to hear Geraud, thank you for sharing!
@moneshbhagavathula49133 жыл бұрын
Hello ma'am. As always , i enjoyed your lecture. It's informative , easily understandable. I recently came to know that there's a technique called domain padding which avoids suppression of rows. Kindly make a tutorial on this topic. It'll be a great help.
@sqlbelle3 жыл бұрын
Thank you Bhagavathula for your comment and suggestion! I will definitely consider that for a future video. It may come in handy for an upcoming (advanced) table calculations video. Appreciate your support!
@anmolaggarwal58552 жыл бұрын
Great, amazing explaination, very deep observations
@kaustavroy4u3 жыл бұрын
Hi, Very intuitive video! I have one question in mind. How do we go with data pivoting in relationship model? Or how can we achieve the same in relationship?
@sqlbelle3 жыл бұрын
Thanks Kaustav! Do you have an option to do it outside of Tableau Desktop? The reason I am asking is the cleaning phase can get complicated, and ideally (where possible) is for this to be done outside of Tableau - for example in Tableau Prep or maybe an ETL process.
@kaustavroy4u3 жыл бұрын
@@sqlbelle Thank you for your reply. I was just trying to understand how the logical layer deals with pivoting. I think I got my answer. 😀
@iitrrocks2 жыл бұрын
Hi, your knowledge and explaination is excellent. Just one advice though- please do not add unnecessary background music, it is irritating. Thanks :)
@sqlbelle2 жыл бұрын
Thank you, I appreciate your feedback. And yes I have removed background music from the newer tutorials based on similar feedback before. These were some of the earlier videos I created trying to navigate how to create content in KZbin .. still living and learning :)
@rasikadhanapala53542 жыл бұрын
Amazing explanation. Thank you very much
@sqlbelle2 жыл бұрын
Thank you Rasika!
@nikhithcheavi16653 жыл бұрын
Hi sqlbelle, Thanks for such beautiful videos. I have few questions. 1. Where is the aggregation performed? Do the sales are aggregated in the secondary datasource to the granularity of primary datasource based on the linking field and then a aggregated result set is sent to tableau or the aggregation is performed in tableau after fetching the record level sales from the sec. datasource? 2. Could you suggest me few use cases where blending is still preferred over joins and relationships? 3. I came across limitations of blending around non-additive aggregates like median, Rawsqlagg etc. on Tableau official website? What exactly does non-additive aggregates mean? Appreciate your help. Thanks.
@sqlbelle3 жыл бұрын
Great questions Nikhith. 1. Aggregations will happen at the data source, and results are sent back to Tableau. The key in here is that aggregations will happen with each respective data source. Here's a reference from the Tableau documentation: help.tableau.com/current/pro/desktop/en-us/multiple_connections.htm 2. Hmm, great question. I can't think of a lot of use cases right now. Perhaps if the data source you're using is not supported for relationships, and you want to maintain the different aggregation levels? 2. Non-additive means you cannot accumulate or total up the numbers. For example, bank balance. You cannot add your bank balance everyday - this will not be a true reflection of how much you have in your account. Hope this helps! Donabel
@aliyanrazzaq75212 жыл бұрын
Very easy and understandable.
@sqlbelle2 жыл бұрын
Thank you Aliyan!
@ChristyDimpu Жыл бұрын
Thank you so much.... Understood perfectly...!!! very well taught..
@didichesmain88272 ай бұрын
Hi, can we have an explanation of the Alteryx? How to display the values? How to make them visible even if it’s several values
@nidhisingh4973 Жыл бұрын
All videos are just amazing. Thank you so much :) One doubt, sales and product name are from secondary table 'Customer Order'. Sales value got aggregated per customer id and displayed correctly. Why cant we combine all product name per customer id?
@andrecsilveira Жыл бұрын
Great content! Thank You! Using your Blend example, how could I find out which customer has not bought a specific product yet? If I filter out the product on the secondary data source will it show me all the customers id who haven't bought this product yet?
@maseedilyas2033 жыл бұрын
Wow exactly what I was looking for
@sqlbelle3 жыл бұрын
Happy to hear that Maseed, thank you for sharing!
@arunrajan19793 жыл бұрын
Simply Awesome! Please do more videos
@sqlbelle3 жыл бұрын
Thank you Arun! 😀
@cocoon7573 жыл бұрын
Great videos! I was confused by these three for a long time. A question: if I blend 3 tables, do I need to define the primary somewhere? or whatever I drag to the working sheet from the beginning becomes primary automatically? So it always left join when I blend them?
@sqlbelle3 жыл бұрын
Thank you for your comment IFLY! And to answer your question, with blends, the data source that owns the first field you drag onto your worksheet is always the primary, and it will always be a left join to that data source. Hope this helps!
@avantikapathak1963 жыл бұрын
you explained so well. I have one question, so blend is just about 2 data sources those 2 could be same or different.
@sqlbelle3 жыл бұрын
Thank you Avantika. Blend needs at least 2 different data sources (could be more). The data sources could technically be the same file, but created twice as different data sources.
@Mohammad-rz7oj2 жыл бұрын
Simply awesome 👌
@sqlbelle2 жыл бұрын
Thank you Mohammad
@berrylewis1335 Жыл бұрын
love the explanations
@sqlbelle Жыл бұрын
Thank you Berry!
@imaduddinfarih48352 жыл бұрын
hello sqlbelle. it's amazing video and very clear explanation.. is it possible to blend from more than 2 data source ? maybe 3 or more data source.. thank you for sharing..
@boomme35983 жыл бұрын
Great video. I have customer data from many ERPs. Could I use tableau to somehow merge the similar customers on Name or Address? Or is such data mining best in SQL?
@sqlbelle3 жыл бұрын
Hello, Where possible, it is best to leave the data transformation work in the database or your ETL process. Usually Tableau will be one of many tools you will use to analyze and report out the data, so having this cleaned up and made available in a more central place will make it more scalable. Also, having more data cleaning happening at the Tableau workbook level will mean your workbook will load more slowly. Ultimately, there are many factors to be considered, but where possible we want to clean data at the source. If that's not possible, it is better to clean in a more central place/repository. Hope this helps! Donabel
@peterparker43583 жыл бұрын
thank you so much Mam also get many things to learn from you...i am very big fan of you and will be always :)
@sqlbelle3 жыл бұрын
Thank you Peter. I am very grateful for your support - and please do not call me Mam 🙂 .. Donabel
@jakubg12672 жыл бұрын
Great tutorial! Thanks :)
@sqlbelle2 жыл бұрын
Thank you Jakub!
@apuroop.mahadev3 жыл бұрын
Thanks a lot. Explanations are great. I'm gonna thank in each video I see in your channel. 💓💓
@sqlbelle3 жыл бұрын
Thank you so much Apuroop! Much appreciated!
@daruwayyy Жыл бұрын
hats off to you man... thankyou so so much .. bless you !
@sqlbelle Жыл бұрын
Thank you Divyam!
@russelllavery22812 жыл бұрын
brilliant once again.
@sqlbelle2 жыл бұрын
Thank you Russell!
@assanjallow8723 Жыл бұрын
i find this tutorial very useful thank you
@kshitizgulati6546 Жыл бұрын
great explanation! Thanks😊
@abdulkhadershaik47383 жыл бұрын
awesome explanation.. very clear.. Keep it up
@sqlbelle3 жыл бұрын
Thank you Abdul Khader! :)
@venkatc13233 жыл бұрын
👌👌👌👌👌 keep going on,pls take use cases also pls... Pls.....pls....
@sqlbelle3 жыл бұрын
Thank you venkat. Are there any specific use case you are looking for?
@hellokirankumar2 жыл бұрын
Where i can get the files for orders and order details for practice for blending in tableau. Any idea
@RommyRenteros Жыл бұрын
HI! I need to compare data from different sites (more than 5 data sources). Not data aggregation/blend/ relationship. Same data that comes from 5 sites. Example: A bar graph with 5 bars showing customer satisfaction for each site along each other. How can I do that? Thank you so much!
@bhawnamongia49552 жыл бұрын
Hi Sqlbelle, how can we create 1 dimension out of 2 dimensions when given condition is data from 2 tables and output of one is true and another is false; need to make true false together ( tried sets, parameters, groups, calc but failed) is there any other alternate to do that. THANKS 😊,
@mayurvirwani2 жыл бұрын
Excellent content. Thank you.
@andrewkim94752 жыл бұрын
You are fantastic!!
@sqlbelle2 жыл бұрын
Thank you Andrew!
@manishsathe83714 ай бұрын
Hi Mam, is there any way to find out which dimensions and measures are used in a tableau file ?
@Neutrino-xw6jl2 жыл бұрын
Hi Belle, Can you please send us a link to download the datasets?
@Teddyafro172 жыл бұрын
that video is gold
@sqlbelle2 жыл бұрын
Thank you TeddyAfro!
@namanverma11052 жыл бұрын
Thanks madam for Amazing video
@sqlbelle2 жыл бұрын
Thank you Naman!
@shubhumusical7557 Жыл бұрын
Hlo mam I completed self study in tablue devloper but I am not select any interview so I have problems in English communication so what is processe in apply for devloper reole
@sunithach7662 жыл бұрын
Hi is it possible to combine excel sheet and tableau server data source in tableau?? I want to inner join data from tableau server data and Excel data
@nareshkumargamming5772 жыл бұрын
NICE Explanation ..
@annswift9883 жыл бұрын
Would it be possible to offer a downloadable pdf of the comparison table between blends, joins and relationships? Thanks.
@sqlbelle3 жыл бұрын
Hello Ann - for sure. I will post it in my blog and reply back here (and post in description) once it's there.
@nadeemraja6553 жыл бұрын
How can I get access to datasets used in this video?
@sqlbelle3 жыл бұрын
Thank you Nadeem. I will try to put the workbooks and data sources in a central place and provide it in the descriptions