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
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)
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
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!!
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!
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!
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.
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.
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!
Pure Gold, understanding how blends work and the difference between the primary and secondary data source. Fantastic channel, packed with top info. Well done !
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.
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!
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 RU-vid .. still living and learning :)
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!
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...
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!
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.
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.
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
Thank you Simmu! I have a Part 2 which discusses Join - is this what you're looking for? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-FtyVMvfzn1I.html
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?
I love your content. Amazing, I am learning a lot. Thanks, but please do not put background music. It is annoying/distracting. Please do not take it otherwise.
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.
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!
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.
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?
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?
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.
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.
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?
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.
Thank you for your comment Pradeepta. Part 2 which discusses Join and Relationship, and also summarizes how all these 3 compare, is in another video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-FtyVMvfzn1I.html Looking forward to your feedback! Donabel
Hello Pradeepta, Part 2 of the video is posted: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-FtyVMvfzn1I.html I hope you will find it useful as well. Donabel
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..
Thank you Diksha. When we join - we are combining tables horizontally, ie what you get in your result is a wider table with more columns. For example if TableA has 5 columns and TableB has 10 columns and you join them, your (immediate) result will have 15 columns, therefore wider.
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.
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
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!
