Master Tableau's Order of Operations - Beginner's Guide - Comprehensive Tutorial with examples

Подписаться 127 тыс.

Просмотров 16 тыс.

50% 1

This is a step-by-step tutorial on understanding and applying the Order of Operations in Tableau. If you're new to Tableau or struggling with this concept, you're in the right place. In this video, we dive into what many call the "secret sauce" of Tableau calculations, ensuring you grasp the nuances of how and why these operations are critical.
🔍 What You'll Learn:
Understanding the Hierarchy:
Discover how filters at different levels impact your data and visualizations.
Context Filters, LODs & Table Calculations:
Learn about context filters, FIXED LOD, and how they interplay with other filters.
Practical Examples:
Walk through common scenarios, like creating top lists and calculating percentages, to see how filters affect outcomes.
💡 Key Highlights:
Interactive Diagram Walkthrough:
We visually break down the Order of Operations, showing where each filter fits in Tableau Desktop.
Common Errors and Tricks:
Avoid frequent mistakes and learn tricks for scenarios like filtering based on table calculation results.
#TableauTutorial #DataVisualization #TableauForBeginners #OrderOfOperations #TableauTips

Опубликовано:

30 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 22

@SatyakalaCh Месяц назад

Thank you so much for these videos with crystal clear explanation .....I love to learn the concepts from your videos

@Wijvangenoeg 10 месяцев назад

i love your videos. they are very helpful for me

@souravanand932 8 месяцев назад

Beautifully explained!!!!

@SebAnt 10 месяцев назад

wonderful tutorial. i had a situation where I need to display ranks of individual within a team, but display only one individual. I solved it by pre-calculating in Alteryx, but how would that be best done in Tableau?

@sqlbelle 10 месяцев назад

Hi Sebastian! I think if the parameters for ranking are pretty set, I would be inclined to pre-calculate the ranking as well in the data set. Table calcs can be tricky, especially if you are going to display the data a few different ways. I feel it's simpler to include the values in the data set. Table calcs would be the way to go though if you ever need to recalculate the ranking based on other fields selected in your view.

@menghao4576 10 месяцев назад

Thank you very much, was preparing for interview, needed this.

@sqlbelle 10 месяцев назад

Thank you, I hope you will find it helpful!

@AveyAvey 9 месяцев назад

In the last example for looking up on that 2021 year, we could have also used Lookup (Min(Year(order date))) and enclosed this expression to Lookup function and use 0 as the offset as you have mentioned. This gave me the desired result. However, what’s ur take on my approach rather than using datepart…?

@AliciaMarkoe 9 месяцев назад

Thank you 🦋. I have a question. (answered my own question, i have to use bars instead of area chart) Can you guide me on how to set up (if possible) a Tableau visualization where a single record contributes to multiple categories in a bar chart? For instance, I want to count Record X in both the 'Red' and 'Yellow' categories within the same chart, based on different criteria. If I had Record X1 and Record X2, this would be easy. I think that a dual-axis chart could be used somehow, but that is more complicated than I want it to be. Example Data: Record X, task attempted, status success Record Y, task attempted, status failed Chart Funnel: Top of Funnel is Red for all tasks attempted Next section is Yellow for all tasks that succeeded When i try to do this with measures, the whole chart turns blue and i can't see different colors for different sections of the funnel, even though the color legend does show multiple colors. I think the issue is that a single record can only be one color in any one chart?

@gauravdiwan21 7 месяцев назад

Thanks @sqlbelle mam, it cleared lot of my doubts.

@MiguelRamirez-tr2nv 9 месяцев назад

Thank you so much!. Very clear the explanation and examples.

@z.r.777 10 месяцев назад

First of all. Thank you! When I saw the video title, I was like, what? OOP again? But I watched anyways because you're great and then I really understood the title. It said MASTER OOP and indeed a Master class this is. Second topic is, even with your clear explanations, it's obvious how Tableau some times is not so intuitive OR I'm just not smart enough, that Lookup function and the date and the flow of data and... and... and... Tableau possibilities are infinite but ... I sometimes I feel they are not obvious. What you think?

@sqlbelle 10 месяцев назад

I agree that some things are not intuitive, especially around table calcs. It takes a while for me to wrap my head around some topics - I usually have to put things in pen and paper to see exactly what's happening. Sometimes, when I think I finally understand the topic, I encounter another scenario that makes me rethink if I did get it, or not really :)

@SebAnt 9 месяцев назад

Thanks a ton, Donabel.🙏🏼 I created a mnemonic- extra dash condiment to help me memorize this 😊

@sqlbelle 9 месяцев назад

Thank you so so much, Sebastian. It's very nice and thoughtful, I very much appreciate it.

@gauravsanghvi9726 10 месяцев назад

Great 👍

@sqlbelle 10 месяцев назад

Thank you :)

@xbbjgpm 10 месяцев назад

thanks a lot for such awesome videos. I have learnt a lot from your other videos. I am working as a Tableau Developer. Whenever I watch your videos a learnt something new.

@sqlbelle 10 месяцев назад

I am glad to hear that, thank you for sharing :)

@piyushk3652 10 месяцев назад

Your way is awesome...Thank you so much for such a great explanation

@GopiKrishna-o7o 2 месяца назад

Thank you so much for your videos on Tableau , I always search your videos only whenever I need the tableau concept ...Thank you so much

@DRF375 9 месяцев назад

Thanks so much for the video. I watch even when I think I understand the topic and always learn something new through your well prepared and clearly communicated explanations.