Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Last answered:

18 Dec 2024

Posted on:

14 Dec 2024

0

Resolved: sql + tableau problem

hello
I noticed that in sql + tableau courses , the data is mostly aggregated in tableau instead of sql, is this always the case and why?
1 answers ( 1 marked as helpful)
Instructor
Posted on:

18 Dec 2024

0
Hey Doaa,

Thank you for reaching out!

Ultimately, this is a matter of personal preference, depending on the use case, data size, and the developer's comfort level with SQL versus Tableau. Both approaches have their merits.

Aggregation in Tableau allows for dynamic, real-time adjustments without needing to rewrite SQL queries. It enables end-users to interactively explore data through filters and can simplify the workflow for non-technical users.

In contrast, doing so may increase Tableau's processing load, especially with large datasets. When dealing with heavier datasets, performing aggregation in SQL is the more efficient option.

Hope this helps!

Kind regards,
365 Hristina

Submit an answer