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.
@PatrickBateman124205 жыл бұрын
Blue pill vs. green pill explained in SQL terms. Awesome work!
@daphnetarango7755 жыл бұрын
Thank you for explaining the relationship between the placement of the pills and SQL.
@Ikowdi6 ай бұрын
Really intereseting, thank you! Are there any more recent videos like that?
@gritmanish6 жыл бұрын
It was nice to understand query optimization
@baijuthomas37162 жыл бұрын
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 ?
@techmind42442 жыл бұрын
1000th like - want to learn Tableau
@revathis82984 жыл бұрын
Thank u. Learnt a lot.
@pasalaramesh54022 жыл бұрын
Great Learning, Thanks a lot.
@carpediem13295 жыл бұрын
What is the download link for the Tableau Log Viewer