I get that there's a commercial agenda to shift reliance on writing SQL to using Tableau UI, but I don't think it's a fair argument to say that having nested logic at 18:59 would lead to performance issues. First of all, we must remember that the query is executed at every drag-and-drop you execute. The query on the left executes Tableau logic on the entire raw table. This can be managed by encoding WHERE filters in your custom SQL code so that you only work with the data you really need. While it is possible to perform these same filters on the data source step in Tableau, remember that every layer of logic you define on the UI is another heavy query.
Really intereseting, thank you!
Are there any more recent videos like that?
I get that there's a commercial agenda to shift reliance on writing SQL to using Tableau UI, but I don't think it's a fair argument to say that having nested logic at 18:59 would lead to performance issues. First of all, we must remember that the query is executed at every drag-and-drop you execute. The query on the left executes Tableau logic on the entire raw table. This can be managed by encoding WHERE filters in your custom SQL code so that you only work with the data you really need. While it is possible to perform these same filters on the data source step in Tableau, remember that every layer of logic you define on the UI is another heavy query.
Blue pill vs. green pill explained in SQL terms. Awesome work!
Thank you for explaining the relationship between the placement of the pills and SQL.
It was nice to understand query optimization
1000th like - want to learn Tableau
Are you querying the oracle like database everytime or are you get a snapshot everyday and saving in a tableau database that allows you to do this ?
Great Learning, Thanks a lot.
Thank u. Learnt a lot.
What is the download link for the Tableau Log Viewer
love the brazilian accent
Боже мой, Саша! Перестань говорить кьюри! Куэри!