SQL + Tableau Combined Questions

 

Q1: Why perform calculations in SQL instead of Tableau?

For large datasets and better performance.

Q2: SQL vs Tableau LOD?

SQL uses GROUP BY.
Tableau LOD performs aggregation at visualization level.

Q3: SQL ROW_NUMBER equivalent in Tableau?

INDEX() table calculation.

Q4: SQL Running Total equivalent in Tableau?

Running Total table calculation.

Q5: SQL Rank equivalent in Tableau?

RANK() function.