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..
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 🙂
@@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
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. :)
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.
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
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.
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.
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 .
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!!!
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 :)
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#
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!
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..
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..
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?
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!
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.
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".
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!
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
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.
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.
11:32 "The solution is really to create multiple data sources". what do you mean by that? . Is there an option to create multiple data sources? kindly reply thank u in advance
Hello Sarath - what I meant with that is, especially before Relationships in Tableau, if you needed a left join for some views and a right join for other views for example: 1. You create a data source (DS1) which is a left join, and use this in sheets that need the left join 2. You create another data source (DS2) by clicking on the database/cylinder icon, use right join, and use this in sheets that need right join I demonstrate creating multiple data sources in the blend video if you are interested: www.youtube.com/watch?v=dC10teRrv
@@sqlbelle thank u . glad I found this channel. For the past 25 days I have been trying to learn Tableau and what I have learned in those 3weeks is nothing compared to what i have learned here, in this channel in 4 days.
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?
Hello Raghvendra, In 0:57 I show the data we are working with and there you will see how the IDs are different, hence needing the calculated join. Does this help?
@@raghvendrapurohit8057 I understand that. And that's what I am saying - I have explicitly stated in 0:57 what was different and why we needed to join using calculation. I understand you may not want to watch that section but the answer is there. Have you looked at the values in that slide? What are the IDs in the Customers table? What are the IDs in the Customer Orders? That should explain what's being joined and why they're being joined that way in 6:59.
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.
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…
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)
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
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.
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?
Great video! thank you so much!! Also, can I apply filters when I creat join calculations? For example I only want to show the customers that purchased 3 items or more, is there a way to express that in the join calculations? (i know we can do this by creating filters in the worksheets later on,but what if I want to filter it out on the data source level)
Thanks Jiangzheng, that's a great question. If the conditions are more than just simple conditions, I am inclined to recommend doing a "cleaning phase" first before connecting them in Tableau, if possible. For example, you can use some ETL tools on the database side, or for example client tools like Tableau Prep or Power BI.
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.
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.
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
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
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?
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!
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
I am slowly putting all the workbooks in my Tableau Public (the latest one on LODs have an accompanying workbook). Once this is ready, I will make a video or announcement to let anyone who might be interested know.
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
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
Thank You for all your vedios they really helpful, can you please share how to study/ prepare for Tableau desktop specialist exam. There are many videos on RUclips but non of them share how to study/ prepare for exam. I have already attempted once my score was 68 could not make it. Awaiting your help
Hello Amol - I am glad you found the videos helpful! I do have a playlist (3 videos) on the hands on questions for the exams (both specialist and associate). These are based on the Tableau certification guides. ruclips.net/p/PLkZ_g9Y7eszJAm-ZbUT7jnldrl-uF-bWe I do walk you through on how to look at some of the questions and general strategies in these videos. I think overall, practice helps a lot, especially practicing with time limit. I would recommend downloading data sets from some open data sites (like kaggle) and try creating your own questions and answering/validating them. I will also recommend going through the topics they lay out in the certification guide and making sure that you have read each of the points, and practiced them if they are hands on. You are allowed to use the embedded help documentation during the exam, as well as the function list in the calculated field editor .. so these should help. I also have another set of questions here if you would like to try: sqlbelle.teachable.com/ I hope these help! Donabel
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..
Thank you so much for your comment Usha! I am happy to hear you found it useful! 🙂
Totally agree. Awesome skill!!!!!!!!!!!!!!!!!!!!!!!!
21:55 is pure genious! "Use relationships if you can, join if you must, blend if you absolutely must."
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 🙂
@@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
I hvnt seen anyone in my life explaining things so vividly and in such a easy way..
Hatss off sqlbelle.
Keep posting👍🏻👍🏻
This is such a kind note, thank you Vishesh!
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. :)
I share the sentiment. This is exactly the Aha moment of tableau
You are a light in my dark path of data analysis
Thank you Jafet. I am happy if the videos are helping in your data analysis 🙂
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.
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
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.
Thank you for your very kind comment, I appreciate it!
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.
Thank you Mahesh for the kind comment. I am happy to hear you found this video helpful!
this video deserve tons of likes and subscriptions...
Thank you so much Mehul!
Thank you Mehul! This is such a nice comment, thank you :) I do hope more can watch it :)
this is absoulately crystal clear explaination covering all aspects..a big thank you !
Thank you Swati!
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 .
The best relationship explanation I have ever seen! Thank you so much!
she is absolutely great teacher and blessing for tableau students.
Thank you so much for your kind comment Irshad!
Superb explanation. The only 'make sense' explanation I found on youtube
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!!!
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 :)
Thank you Neeraj!
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#
Thank you so much Wasim!
It is the best session I have ever seen, thanks so much for the content & presentation. I have also followed you on Tableau Public. :)
Thank you Sunil!
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!
Thank you so much for your very kind and supportive feedback, Guna. Much appreciated!
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..
So glad to hear, thank you Arjun!
You are a very talented teacher with great pace. Thank you.
Another crystal clear explanation from Ms. Belle. 👏
Thank you for your kind comment, Nicko! I am glad you found the video helpful!
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..
So happy to hear Sindhuja. Happy to hear you are finding the videos helpful :)
Best video with detailed explanation. This helped me a lot to understand the concepts
Thank you for your comment Tarun, glad it helped!
A big thank you to you to explaining this complex relationships concept! Very clearly explained!!
Thank you Sinchana!
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?
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!
Thank you Jakub! I appreciate your comment :)
Pretty well defined... Only after this video I'm clear with this topic.. Thank you🌹❤
Thank you @midunsathiyamoorthy593
Thanks for your well structured explanation , Expecting More Videos...
Thank you Rajesh!
Best video on relationships and joins i hav come across...thanks a lot
Thank you Rajashekar!
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 ❤️😇
Thank you Kriti! I very much appreciate your note! :)
Fantastic explanation and very well articulated!! I'm lucky people like you are out there are making life easier for people like me :)
Thank you SP, I am glad you found it helpful.
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.
These are great suggestions, thank you Shashank!
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".
Thank you Kranthi! Appreciate your comment :)
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.
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
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!
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
Best Explanation Ever. I love the way u explain.
Thank you Chethan!
It helped me a lot ☺️ Thanks a lot for making this video and explaining it so beautifully
A great explanation for these daily decisions!! Thanks
Thank you Cristopher!
Can I get those 3 excel sheets to practice the same things on my PC ? That would be really helpful.
Very well explained. You are a great teacher!
Thank you Adriana!
very well organised way to describe various concepts. I definitely suggest everyone watch this awesome content....awesome.
Thank you for your kind comment Mehul!
Thank you so much for your kind comment, Mehul! Much appreciated :)
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.
When you mentioned, "the solution was to create multiple data sources" (at 11:32) was to use data blending option? BTW, love your videos!!!
Hey thanks for making videos it's really helpful in learning Tableau
Can you advise me which playlist i watch to learn Tableau
Very good content ...Now I am clear about the blend , join and relationship ...Thanks mam😊
Thank you Mrinal, I am glad you found the video helpful! 🙂
You explained the concept very simply. Pls make video to explain performance options in relationship
Thank you Abhishek! That is a great suggestion. I will definitely try to include that in one of the next videos.
@@sqlbelle I will look forward to it...
thanks again for detailed explanation !!! Eagerly waiting for Part -3 (Performance Options) on this topic :).
Thank you Jayasree :)
@sqlbell.
For practice purposes is possible to attach the exact data sets you use for
each video?
Superb. Liked the way you explain. Thanks
Thank you Ramees
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?
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.
Great Explanation,
can you create a video on improving the performance of the dashboard connected to a live data source?
11:32 "The solution is really to create multiple data sources". what do you mean by that? .
Is there an option to create multiple data sources?
kindly reply thank u in advance
Hello Sarath - what I meant with that is, especially before Relationships in Tableau, if you needed a left join for some views and a right join for other views for example:
1. You create a data source (DS1) which is a left join, and use this in sheets that need the left join
2. You create another data source (DS2) by clicking on the database/cylinder icon, use right join, and use this in sheets that need right join
I demonstrate creating multiple data sources in the blend video if you are interested: www.youtube.com/watch?v=dC10teRrv
@@sqlbelle thank u . glad I found this channel. For the past 25 days I have been trying to learn Tableau and what I have learned in those 3weeks is nothing compared to what i have learned here, in this channel in 4 days.
Hi Belle..Thank you so much ! very detailed explanation, and it is vary useful, keep posting. :)
Thank you Mahesh! Glad you found the video useful! 🙂
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?
6:59, wats that CUSTOME+[CUSTOMER ID]...kindly explain,How did join happen with ''CUSTOME''?
Hello Raghvendra,
In 0:57 I show the data we are working with and there you will see how the IDs are different, hence needing the calculated join. Does this help?
@@sqlbelle but wats dat CUSTOME in CUSTOME +[ CUSTOMER ID]..which column is that
@@raghvendrapurohit8057 Thanks. I definitely encourage you to look at 0:57 - the answer is there.
@@sqlbelle I got the concept behind joining those two columns but u had typed "CUSTOME"...There is no such column as CUSTOME... Sorry if I m wrong
@@raghvendrapurohit8057 I understand that. And that's what I am saying - I have explicitly stated in 0:57 what was different and why we needed to join using calculation. I understand you may not want to watch that section but the answer is there. Have you looked at the values in that slide? What are the IDs in the Customers table? What are the IDs in the Customer Orders? That should explain what's being joined and why they're being joined that way in 6:59.
I have understood the concept but how to explain in interview if asks when to choose joins and relationships?
Thanks Belle.. you are the best ! very detailed explanation.
Thank you Siva! Hope you found it useful!
As always the best teacher ...thanks a lot a lot...very very usefullllll....
Thank you so much VDN, so happy to hear you found it useful! 😊
We absolutely enjoyed the video..!!!
That's great to hear, thank you Tarun!
Great Video....Explained very well.Thank you
Thank you Aniket
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.
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…
That's great to hear, thank you Jia! Glad to hear you found the video helpful!
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)
Hello Aditya - do you mean to pull all related fields automatically? No this option does not exist at this point in Tableau.
Super video. Thanks for your efforts..Very clear..
Thank you Vivek, glad you found it helpful.
Thank you for the detailed explanation.
Thank you Aditya!
Can relationships are used to join data from multiple data sources
Mam we want more advanced concept like this plz keep uploading..
Thank you for your comment Piyush! 🙂
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
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.
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.
Thank you for the nice explanation Mam. really loved it and made my concept more clear.
Always appreciate your comments and support, Peter! 😊
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?
Thank you Aditya. I will post the data set. I will reply back here (and add to description) once I add the data set
Great video! thank you so much!! Also, can I apply filters when I creat join calculations? For example I only want to show the customers that purchased 3 items or more, is there a way to express that in the join calculations? (i know we can do this by creating filters in the worksheets later on,but what if I want to filter it out on the data source level)
Thanks Jiangzheng, that's a great question. If the conditions are more than just simple conditions, I am inclined to recommend doing a "cleaning phase" first before connecting them in Tableau, if possible. For example, you can use some ETL tools on the database side, or for example client tools like Tableau Prep or Power BI.
Hi,
Can you provide the link for excel file that you used here for Joins and Relations and blend?
Excellent explanation
Thank you Rasika
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.
Thank you for the great suggestions Sunil!
Good explanation of a complex Tableau topic. Please share the dataset if possible Donabel, would like to practice the concept.
Thank you Pooja, I will upload the workbook with data sets to Tableau public. I'll let you know when it's there :)
@@sqlbelle great video as usual
a kind reminder for sharing the dataset if possible
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.
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
I don't understand the statement can u clearly explain...
If possible please make a video's on Tableau online and server .. please.
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
Best tutorial 👌👍
Thank you Sayak!
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?
I didn't understand what do you mean by "CUSTOME" + in the edit calculation field.
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!
Could you provide datasets to practice?
superb ....mam do uploads dataset as well with your videos.
Thank you for the suggestion Nitesh!
Great!
Where i can find this excel file?
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
Thank you for the suggestion Mukul!
If I can get the path to dataset so I can follow along? Also any video on joins with Calculated fields? thx & much appreciated.
I am slowly putting all the workbooks in my Tableau Public (the latest one on LODs have an accompanying workbook). Once this is ready, I will make a video or announcement to let anyone who might be interested know.
What a great explanation
Thank you Paspas!
is it correct that using Join will solve the * issue in blend? Because in join, there is only 1 database (no primary or secondary)?
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
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
This is just Awesome!! Thank you so much!
awesome explanation
Thank you Diya!
This is a masterpiece video
Thank you Atlas!
Can you please provide link to the data as well?
Amazing explanation ❤️
Thank you Kiran! 🙂
I request you to post tableau project with all use cases? waiting for it eagarly
Vary welll explained as always. Thank you.
Glad it was helpful, Anil! 🙂
Happy New Year Donabel!!!
Happy New Year Eddy!!! 😀
Very Helpful, Thank You.
Thank You for all your vedios they really helpful, can you please share how to study/ prepare for Tableau desktop specialist exam. There are many videos on RUclips but non of them share how to study/ prepare for exam.
I have already attempted once my score was 68 could not make it.
Awaiting your help
Hello Amol - I am glad you found the videos helpful!
I do have a playlist (3 videos) on the hands on questions for the exams (both specialist and associate). These are based on the Tableau certification guides.
ruclips.net/p/PLkZ_g9Y7eszJAm-ZbUT7jnldrl-uF-bWe
I do walk you through on how to look at some of the questions and general strategies in these videos.
I think overall, practice helps a lot, especially practicing with time limit. I would recommend downloading data sets from some open data sites (like kaggle) and try creating your own questions and answering/validating them.
I will also recommend going through the topics they lay out in the certification guide and making sure that you have read each of the points, and practiced them if they are hands on. You are allowed to use the embedded help documentation during the exam, as well as the function list in the calculated field editor .. so these should help.
I also have another set of questions here if you would like to try:
sqlbelle.teachable.com/
I hope these help!
Donabel
@@sqlbelle thanks again for your help
You are most welcome Amol!
Hi Madam,
can you please explain what exact difference between Extract filter and Data Source Filter is?
Thank you Manish - I cover the differences between these filters in this video:
ruclips.net/video/BrpOBoLhmlM/видео.html
Hope it helps!
@@sqlbelle I will go through it , Thank you for finding time to reply