Always a very kind note and support from you Vijay - thank you so much for taking the time to watch and comment. Happy to hear you found the video still informative :) ... Very much appreciate. Please accept my kind and heartfelt thanks :)
I have been a PowerBI Dev, and now I'm upskilling - Tableau Viz - Your videos are exceptionally awesome, short, simple, and easy to follow. The contents of your video are superb. You are helping to transform into a Tableau Developer role very easily. I want to thank you for all that you do and how you have added value to my tableau journey. I will follow your tableau public to gain more nuggets there too 🙂
can't wait for the final one, especially the set action. Used a couple of your LOD cohorts for the first, second, and last purchase already at work. You are making us shine, getting visibility and hopefully, a raise that will help with this crazy inflation :-)
Thank you Abderrahim, so happy to hear you found the video helpful and that the videos are helping in your work as well :) That is the best consolation!
Thanks Michal! Tableau's an awesome tool to start with, but there's a lot of little tricks that make it even more awesome. I am learning as I go through their materials too. :)
Thank you for sharing one more useful video related to one of the most important topic in tableau... Your explanation is excellent.. thank you once again... 🙂
Learned a lot and looking forward to part 3. I would also like to see a separate series of videos on more complex scenarios with nested LOD to add more complexity. Good job & Thx
@sqlbelle for the LOD 7th can we use this expression AVG({FIXED State,Customer ID: Max(Sales)}). Post which in the map we will select state and this LOD function
What if -have to show product category against different Cohort dates as in (First Purchase , 01st time bought Product category , second purchase, 02nd time bought product categories and so on.. ). Looking for this scenario, Thanks!
Hi Sqlbelle, Which LOD is performance efficient (INCLUDE/EXCLUDE/FIXED), Please can you help had some performance issue in one my dashboard, I am trying to optimize it (Need to choose between INCLUDE/FIXED).
Thanks Pradeep .. I'd still say it depends since the behavior of INCLUDE and FIXED are still different. How should your calculation behave with filters? Sometimes it can become difficult if you add all your filters to context all the time if you want the FIXED to be affected by filters. It's also hard to qualify which one will be more efficient - will depend on how complex your calculations are, esp if they're nested LODs. In general though I would assume FIXED is faster since it's an independent query, much like when you have a regular subquery in a SQL SELECT statement. Hope this helps.
@@sqlbelle Thank you sqlbelle, understood that it totally depends on use case, I did a performance recording using both of them didn't see much of a difference, the calculation was a simple one with out any nested lod's Sum{Fixed [tenure] : avg(total area)}, Majorly, I think need to focus on pre-aggregating the data instead of using lod, thanks a lot for your time you are such an amazing mentor...👍
Thanks for Sharing with us very valuable content. It is very useful in day to day work. But i have question like in use case 6 you use window sum can we use sum in the place of window sum.As you used sum in use case 8
Thank you Ajay. When we have an aggregate already (for example if data is already summed up_, and if we want to do another sum, we will need to use a table calculation function like WINDOW_SUM (unless you are using a FIXED LOD, which technically converts data into a scalar value and therefore can be passed to SUM)
Thanks for your Effort. Could you make the videos for "How to improve the tableau dashboard performance" 1)Desktop level 2) tableau server level, 3)Database level
Hi Donnabel, thanks for your excellent tutorial, I just have a question, in case 6 you use Window_sum for counting number of sub-category if it has more sales than Accessories, but in case 8 you only use Sum for counting products that met the target or not. Can you give me more elaboration in this case. And its even better if you can make a video to further drill down on when to use window_sum, window_min, window_max... rather than min, max, sum... it-seft. Thanks
Hello Ibrahim! I was only able to finish until 12. 11 to 15 were quite long so I've put them in their own videos. I still have 13 in draft :( Here's 11: ua-cam.com/video/-i47u_niLX4/v-deo.html and here's 12:ua-cam.com/video/N-L26NUXhP0/v-deo.html Glad you have found the videos helpful!
Awesome !!! this is so perfect.we appreciate your hard work in making these valuable contents. Please make some contents on connecting Tableau to MySQL,SQlite and SQL-Server.
sqlbelle when I selected only states in the map none of the colors or tooltips were visible when I hovered over it. However, it became visible post I added country. What is the reason behind it?
Great series of videos!! I'm learning a lot! I only have a silly question: where did you get the coffee chain dataset? I googled it and I found some, however none of them have the "Target" fields.
Thank you Andréa. I have a link to the workbook in the description. You can get the dataset from there - when you open it in your Tableau Desktop you can save it back to a csv (or Excel). Hope this helps!
Peter, Peter - always a big thank you for your support. I cannot tell you how much I really appreciate all the comments, support - just a big, big thank you :)
I used a bit different approach for Comparative analysis, But your's is much more cleaner and efficient Difference : SUM([Sales]) - SUM({FIXED : SUM(if [Select Sub-Category] = [Sub-Category] THEN [Sales] END)}) I believe, The best way to learn is to try reaching the final Use case before checking the tutorial, So that we would come to know what are the different approach we can use to solve the same problem.
I wouldn't overrate the title of a "Tableau Zen Master," a title giving to people who educate other users. You might be the best Tableau user in the world, but nobody knows you (except your customers).
Hi, I am unable to get the option "Assume Referential Integrity'' on my data menu for my dataset. What could be the reason behind this? What are the cases when we don't get to see this option in our data menu in our data source and what are the case we do? It would be a great service if this query gets answered. Thanks in advance! Please answer
When I tried IF category = parameter. category the then sales end. the results doesn't match exactly with the sales amount ut is always greater than the sales value. can you please tell me why. I am not using the superstore data for it.
mam could you please calarify in use case no 9 while iam dragging first month sales and last month sales iam getting cntd(first month sales ) as well as cntd(last month sales .how shall i get sum (first month sales ) and sum(last month sales )
Hi belle, I just love how u teach a subject. Kindly could you solve my query?? My query is what is the difference between calculated fields and para meter'.
Thanks Ravi. SUM is an aggregation function, WINDOW_SUM is a table calculation function. We use SUM() if we want to see just grouped values for example total sales per state (which is at 16:19 In 7:59 - what we want is a grand total count which we will display in the title, and not simply a difference per state. Note that the chart is subdivided by State (ie this pill is in your Rows shelf). What we want to get is the total for all the values shown on screen, which is why we need to use a table calculation function WINDOW_SUM. I encourage you to give it a try to see the difference.
@@sqlbelle Thank you Donabel for your quick response and now its very clear where to use SUM and where to use Table calculation. l really appreciate your hard work and the way you are helping and you made LOD very simple for everyone i am going through all your videos and found very useful . God bless you Donabel
I am not sure your Use case #9 is correct. 1/3/2018 sales is only $16, not $14,237 which is for the whole jan 2018. could you please double check? your example displays the first day of the month, but the measure still calculates for the whole month
If you watch the video, I emphasize that $14,237 is for the full month. A succeeding step is to extract the first day of month (using INCLUDE LOD) and last of month (using INCLUDE LOD). The crosstab walks through how you can extract the information. However it's the charts later on (around 22:39) that uses the extracted information. Note that with the crosstab, the actual sales were not displayed. I encourage you to view the video again. in 22:39 you will see that the first of month and last of month sales are different (and NOT $14K). And as you say, it displays $16 for first day sales. If you check the accompanying workbook, or re-create the charts I create - you can verify that the values are accurate.
Thank you Donabel for an excellent video! You have shown very practical use cases in a simple easy to follow manner! Take a bow Tableau Master! 😊👍
Always a very kind note and support from you Vijay - thank you so much for taking the time to watch and comment. Happy to hear you found the video still informative :) ... Very much appreciate. Please accept my kind and heartfelt thanks :)
@@sqlbelles AQ पॉप😢
Your step by step explanation is the highlight of this video to understand all the LOD concepts very clearly. Thank you for the same.
Thank you Tamil, appreciate your kind comment! Glad to hear you found the video helpful :)
I have been a PowerBI Dev, and now I'm upskilling - Tableau Viz - Your videos are exceptionally awesome, short, simple, and easy to follow. The contents of your video are superb. You are helping to transform into a Tableau Developer role very easily. I want to thank you for all that you do and how you have added value to my tableau journey. I will follow your tableau public to gain more nuggets there too 🙂
I would say this is probably the best explanation I can find of LOD use cases, looking forward to see the Part 3
Thank you Yifan! Glad you found the video helpful :)
Actual vs Target example was way impressive 🤓keep rockin
Thank you Rakesh!
I've learned so much from LOD Part 1 and 2, looKing forward to see your Part 3
Happy to hear that Tony! Thank you for sharing :)
can't wait for the final one, especially the set action. Used a couple of your LOD cohorts for the first, second, and last purchase already at work. You are making us shine, getting visibility and hopefully, a raise that will help with this crazy inflation :-)
Thank you Abderrahim, so happy to hear you found the video helpful and that the videos are helping in your work as well :) That is the best consolation!
Thank you so much , because are changing my view about tableau . you are the best teacher ever.
I'm keeping on watching every new video of you. It is extremely useful for fresher like me. Thank you for your hard work!!!
Thank you Thao! Glad you are finding the videos helpful!
This video was not only helpful. It was AMAZING. Thank you so much. Very good, very practical and easy to follow!
I am glad to hear, thank you Christos!
thanks to you I become better and better every day in Tableau :) this tutorials are so concise and substantive that I cannot get over it :)
Thanks Michal! Tableau's an awesome tool to start with, but there's a lot of little tricks that make it even more awesome. I am learning as I go through their materials too. :)
Thank you for sharing one more useful video related to one of the most important topic in tableau... Your explanation is excellent.. thank you once again... 🙂
Thank you Ambuj! Happy to hear you found the video helpful :)
Learned a lot and looking forward to part 3. I would also like to see a separate series of videos on more complex scenarios with nested LOD to add more complexity. Good job & Thx
Sounds great, thank you for the suggestion Nadeem! :)
This video is very useful👍, I have learned a lot of analytical methods and technology in Tableau
Thank you very much for taking time explaining all the details your explanation was excellent in understanding LODS
Thank you Shad, I appreciate your comment!
With LOD we can answer so many questions thanks ...
@sqlbelle for the LOD 7th can we use this expression AVG({FIXED State,Customer ID: Max(Sales)}). Post which in the map we will select state and this LOD function
Great videos. Thank you so much for your time and effort to make us understanding the concept in depth.
Thank you Indra!
Thanks for explain LOAD step by step, you're awesome
Thank you Nallely..
Why in 6 example you use Window_sum while in 8 example you use SUM for calculating numbers of subcategories/products basedon conditions?
this videos are legendary! thank you for your effort. really appreciate it.
Thanks Michal! Appreciate you taking the time to watch and leave kind comments :)
Thanks mam...your my favorite tutor...
Thank you You! Hope you found it helpful :)
Thank you so much for this LOD concepts
Thank you Guna!
What if -have to show product category against different Cohort dates as in (First Purchase , 01st time bought Product category , second purchase, 02nd time bought product categories and so on.. ). Looking for this scenario, Thanks!
Excellent Explanation !! Please upload complex scenarios also.. Thank you so much
Thanks for one more useful, easy to understand video! 🙂
Thank you Thomas! :)
..Im thankful to U
And For
Waiting for part 3 lods
Thank you Sudarsan!
Hi Sqlbelle, Which LOD is performance efficient (INCLUDE/EXCLUDE/FIXED),
Please can you help had some performance issue in one my dashboard, I am trying to optimize it (Need to choose between INCLUDE/FIXED).
Thanks Pradeep .. I'd still say it depends since the behavior of INCLUDE and FIXED are still different. How should your calculation behave with filters? Sometimes it can become difficult if you add all your filters to context all the time if you want the FIXED to be affected by filters.
It's also hard to qualify which one will be more efficient - will depend on how complex your calculations are, esp if they're nested LODs. In general though I would assume FIXED is faster since it's an independent query, much like when you have a regular subquery in a SQL SELECT statement.
Hope this helps.
@@sqlbelle Thank you sqlbelle, understood that it totally depends on use case, I did a performance recording using both of them didn't see much of a difference, the calculation was a simple one with out any nested lod's
Sum{Fixed [tenure] : avg(total area)},
Majorly, I think need to focus on pre-aggregating the data instead of using lod, thanks a lot for your time you are such an amazing mentor...👍
Thank you! Very well explained. Kind regards
Thank you for your comment Paulo!
Thanks for Sharing with us very valuable content. It is very useful in day to day work. But i have question like in use case 6 you use window sum can we use sum in the place of window sum.As you used sum in use case 8
Thank you Ajay. When we have an aggregate already (for example if data is already summed up_, and if we want to do another sum, we will need to use a table calculation function like WINDOW_SUM (unless you are using a FIXED LOD, which technically converts data into a scalar value and therefore can be passed to SUM)
@@sqlbelle ❤️
Thanks for your Effort. Could you make the videos for "How to improve the tableau dashboard performance" 1)Desktop level 2) tableau server level, 3)Database level
Thank you Murugan for your suggestions!
Hi Donnabel, thanks for your excellent tutorial, I just have a question, in case 6 you use Window_sum for counting number of sub-category if it has more sales than Accessories, but in case 8 you only use Sum for counting products that met the target or not. Can you give me more elaboration in this case. And its even better if you can make a video to further drill down on when to use window_sum, window_min, window_max... rather than min, max, sum... it-seft. Thanks
Thank you for the informative video!
Thank you Kamran! Glad to hear you found the video informative! :)
Thank you Donabel, I would like to ask about top 11-15 LOD video. I couldnt find it. Did you add before or you didnt add that video. Thank you again.
Hello Ibrahim!
I was only able to finish until 12. 11 to 15 were quite long so I've put them in their own videos. I still have 13 in draft :(
Here's 11:
ua-cam.com/video/-i47u_niLX4/v-deo.html
and here's 12:ua-cam.com/video/N-L26NUXhP0/v-deo.html
Glad you have found the videos helpful!
Awesome !!!
this is so perfect.we appreciate your hard work in making these valuable contents. Please make some contents on connecting Tableau to MySQL,SQlite and SQL-Server.
Thank you Irshad!
sqlbelle when I selected only states in the map none of the colors or tooltips were visible when I hovered over it. However, it became visible post I added country. What is the reason behind it?
Great series of videos!! I'm learning a lot! I only have a silly question: where did you get the coffee chain dataset? I googled it and I found some, however none of them have the "Target" fields.
Thank you Andréa. I have a link to the workbook in the description. You can get the dataset from there - when you open it in your Tableau Desktop you can save it back to a csv (or Excel).
Hope this helps!
@@sqlbelle Yes, it helps! Thank you!
Hi, thank you so much once again. Could you make a video on 'window-function' keys.?
Thank you for the suggestion Sasmita!
@@sqlbelle it's my pleasure, but in same time I need to improve myself. I need your support. Thank you so much once again.
That's was super cool 😎 thank you so much mam again..
Peter, Peter - always a big thank you for your support. I cannot tell you how much I really appreciate all the comments, support - just a big, big thank you :)
I would like to ask when do we use WINDOW_SUM? In one example it was needed, why we couldn't use just SUM?
Thanks agelee89 - WINDOW_SUM will need to be used if what you're trying to get a total of is already a SUM (or another kind of aggregate)
I used a bit different approach for Comparative analysis, But your's is much more cleaner and efficient
Difference :
SUM([Sales]) -
SUM({FIXED : SUM(if [Select Sub-Category] = [Sub-Category] THEN [Sales] END)})
I believe, The best way to learn is to try reaching the final Use case before checking the tutorial, So that we would come to know what are the different approach we can use to solve the same problem.
Thank you for sharing Pradeep!
Omg simple but so useful! Thank you. Are you a Zen Master?!?!!!
Thank you Mashiro! Glad you found it useful :) .. No I am not a Zen Master :)
I wouldn't overrate the title of a "Tableau Zen Master," a title giving to people who educate other users. You might be the best Tableau user in the world, but nobody knows you (except your customers).
How can I get the adjusted coffee chain dataset used in the video?
Hi, I am unable to get the option "Assume Referential Integrity'' on my data menu for my dataset. What could be the reason behind this? What are the cases when we don't get to see this option in our data menu in our data source and what are the case we do? It would be a great service if this query gets answered. Thanks in advance! Please answer
I'm stuck in the Q10. When I'm dragging the customer id to the plot it is not changing into measures( green color) . Help..
When I tried IF category = parameter. category the then sales end. the results doesn't match exactly with the sales amount ut is always greater than the sales value. can you please tell me why. I am not using the superstore data for it.
Thankyou for sharing 👍👍
Thank you Diksha!
mam could you please calarify in use case no 9 while iam dragging first month sales and last month sales iam getting cntd(first month sales ) as well as cntd(last month sales .how shall i get sum (first month sales ) and sum(last month sales )
Can you provide the transactions coffee dataset that you used?
Can you please upload videos on interview questions
Thank you for the suggestion Mani!
Too Great explanation :)
Thank you Chitransh!
Do LOD fields work if my data source is a live data source?
Very cool & usefull
Thank You for the video :-)
Thank you :)
Super good!!!! Thank you! Liked and Bookmarked (already subscribed ;) )
Thank you Jers! :) Glad you found the video informative :)
Hi belle, I just love how u teach a subject. Kindly could you solve my query??
My query is what is the difference between calculated fields and para meter'.
Thank you Sasmita. I have a video on parameters that may help clarify: ua-cam.com/video/0Uar_D57QhU/v-deo.html
@@sqlbelle thank you so much.
can i know the link for coffee chain dataset? so i can download it
Is this dataset available to follow along?
The Best !!!!
Thank you Suraj!
Thank you for your efforts. !!!c
Thank you Neel! :)
Thank you Donabel
Its so good 🙂
Thank you! Hope you found some practical use cases you can use right away :)
Can some help me please at 7:59 why used window_sum and at 16:19 why used sum ?
Thanks Ravi. SUM is an aggregation function, WINDOW_SUM is a table calculation function.
We use SUM() if we want to see just grouped values for example total sales per state (which is at 16:19
In 7:59 - what we want is a grand total count which we will display in the title, and not simply a difference per state. Note that the chart is subdivided by State (ie this pill is in your Rows shelf). What we want to get is the total for all the values shown on screen, which is why we need to use a table calculation function WINDOW_SUM.
I encourage you to give it a try to see the difference.
@@sqlbelle Thank you Donabel for your quick response and now its very clear where to use SUM and where to use Table calculation. l really appreciate your hard work and the way you are helping and you made LOD very simple for everyone i am going through all your videos and found very useful . God bless you Donabel
Nice
Thank you Shailendra!
Great
Thank you Musavvar!
Madam can u make a video about calculations
Thank you Venugopala. I have a playlist on calculations if you'd like to check it out: ua-cam.com/video/QimVQl5AoYM/v-deo.html
@@sqlbelle thanks ❤
I am not sure your Use case #9 is correct. 1/3/2018 sales is only $16, not $14,237 which is for the whole jan 2018. could you please double check? your example displays the first day of the month, but the measure still calculates for the whole month
If you watch the video, I emphasize that $14,237 is for the full month.
A succeeding step is to extract the first day of month (using INCLUDE LOD) and last of month (using INCLUDE LOD). The crosstab walks through how you can extract the information. However it's the charts later on (around 22:39) that uses the extracted information. Note that with the crosstab, the actual sales were not displayed.
I encourage you to view the video again. in 22:39 you will see that the first of month and last of month sales are different (and NOT $14K). And as you say, it displays $16 for first day sales.
If you check the accompanying workbook, or re-create the charts I create - you can verify that the values are accurate.
Good videos and explanations but they go so quick that I find myself having to pause constantly and rewinding which was a bit frustrating.
Tableau has new certification!!!!! Certified Data Analyst.... please help lol this just sound so hard to pass :(
Thanks Ben! I havent taken the new beta exam yet, but I am looking at the new prep guide. I'll plan to create a new video addressing it.
💙
Thank you Pushkar ❤
Thanks 🛅