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.
