Enhancing Tableau Data Queries

Speaker- Alex Lokhov, Alex Eskinasy Check out the various techniques for optimising live connections in Tableau. We will tackle techniques to optimise query performance from the Tableau side as well as the database side. Expect a recap of general performance tips in Tableau, an understanding of what happens under the covers (i.e. order of execution in Tableau, performance recording and implementation plan in a database), and a review of joins vs. blends vs. cross-database joins, performance implications, resulting queries, and more.

[@PatrickBateman12420]

Blue pill vs. green pill explained in SQL terms. Awesome work!

[@daphnetarango775]

Thank you for explaining the relationship between the placement of the pills and SQL.

[@darrellleong8327]

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.

[@gritmanish]

It was nice to understand query optimization

[@revathis8298]

Thank u. Learnt a lot.

[@pasalaramesh5402]

Great Learning, Thanks a lot.

[@techmind4244]

1000th like - want to learn Tableau

[@baijuthomas3716]

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 ?

[@carpediem1329]

What is the download link for the Tableau Log Viewer

[@80lilala]

love the brazilian accent

[@thghtfl]

Боже мой, Саша! Перестань говорить кьюри! Куэри!