What is the difference between 'Extract Data' and 'Live Connection' in Tableau?

Question

Accepted Answer

Extract Data saves a snapshot of data in Tableau workbook, while Live Connection directly connects to data source.

Extract Data creates a static copy of data in Tableau workbook, while Live Connection directly queries data source in real-time.
Extract Data is useful for working offline or with small datasets, while Live Connection is ideal for large datasets or when data is frequently updated.
Extract Data can improve performance as it reduces the need to query the data source repeatedly, while Live Connection ensures the most up-to-date data is always displayed.
Examples: Extract Data can be used for creating static reports, while Live Connection is suitable for dashboards that require real-time data updates.

Top Affine Data Analyst interview questions & answers