For a new report, a consultant needs to build a data model with three different tables, including two that contain hierarchies of locations and products. The third
table contains detailed warehousing data from all locations across six countries. The consultant uses Tableau Cloud and the size of the third table excludes
using an extract.
What is the most performant approach to model the data for a live connection?
For a performant live connection in Tableau Cloud, especially when dealing with large datasets that preclude the use of extracts, relating the tables in Tableau Desktop is the recommended approach. This method allows for flexibility in how the data is queried and can improve performance by leveraging Tableau's relationships feature, which optimizes queries for the underlying database.
Currently there are no comments in this discussion, be the first to comment!