Live vs extract connections in Tableau - Quick Revision & Key Differences

Recall & Review

beginner

What is a live connection in Tableau?

A live connection in Tableau means the data is connected directly to the source and updates in real-time or near real-time whenever you interact with the dashboard.

beginner

What is an extract connection in Tableau?

An extract connection uses a snapshot of the data saved locally or on Tableau Server. It does not update automatically unless you refresh the extract manually or on a schedule.

beginner

Name one advantage of using a live connection.

Live connections provide up-to-date data, which is useful when you need the latest information for decision-making.

beginner

Name one advantage of using an extract connection.

Extracts improve performance because Tableau works with a smaller, optimized copy of the data instead of querying the full source every time.

intermediate

When might you prefer an extract connection over a live connection?

You might prefer an extract when the data source is slow, unreliable, or when you want faster dashboard performance without constant querying.

What happens when you use a live connection in Tableau?

A Data is stored in a local Excel file

B Data is saved as a snapshot and does not update

C Data updates automatically with every interaction

D Data is only refreshed when you restart Tableau

Live connections query the data source directly, so data updates with every interaction.

Which connection type generally offers better dashboard performance?

A Extract connection

B Live connection

C Both perform the same

D Neither affects performance

Extract connections use optimized snapshots, which usually improve performance.

When using an extract connection, how do you get updated data?

A Data updates automatically in real-time

B You refresh the extract manually or schedule refreshes

C Data never updates once extracted

D You must recreate the workbook

Extracts require manual or scheduled refreshes to update data.

Which connection is better if your data source is slow or unreliable?

A Live connection

B Neither should be used

C Both are equally good

D Extract connection

Extracts reduce load on slow or unreliable sources by using a local snapshot.

What is a key downside of live connections?

A Dashboard performance depends on data source speed

B You cannot filter data

C Data is outdated

D Extracts are required

Live connections depend on the speed and availability of the data source, which can slow dashboards.

Explain the main differences between live and extract connections in Tableau.

Think about how data updates and how fast dashboards respond.

Describe scenarios when you would choose a live connection versus an extract connection.

Consider data speed and update frequency needs.

Practice

1. Which statement best describes a live connection in Tableau?

easy

A. It only works with Excel files and not databases.

B. It stores a snapshot of data for faster access and offline use.

C. It shows real-time data directly from the source without storing a copy.

D. It requires manual data entry to update the dashboard.

Solution

1. Step 1: Understand live connection concept

   A live connection accesses data directly from the source in real-time without storing a copy.

2. Step 2: Compare with extract connection

   Extract connections store data snapshots for speed and offline use, unlike live connections.

3. Final Answer:

   It shows real-time data directly from the source without storing a copy. -> Option C

4. Quick Check:

   Live connection = real-time data [OK]

Hint: Live = real-time data, Extract = stored snapshot [OK]

Common Mistakes:

• Confusing extract with live connection
• Thinking live connections store data locally
• Assuming live connections work offline

2. Which of the following is the correct way to create an extract connection in Tableau?

easy

A. Click 'Data' > 'New Data Source' > Select 'Live' option

B. Click 'Data' > 'Extract Data' and save the snapshot

C. Use 'Refresh Data' to update live connection

D. Connect only to Excel files for extract

Solution

1. Step 1: Identify extract creation steps

   Extracts are created by selecting 'Extract Data' from the Data menu and saving a snapshot.

2. Step 2: Eliminate incorrect options

   Click 'Data' > 'New Data Source' > Select 'Live' option is for live connections, C is for refreshing live data, D is incorrect as extracts support many sources.

3. Final Answer:

   Click 'Data' > 'Extract Data' and save the snapshot -> Option B

4. Quick Check:

   Extract = 'Extract Data' option [OK]

Hint: Extract = 'Extract Data' menu option in Tableau [OK]

Common Mistakes:

• Choosing 'Live' instead of 'Extract' option
• Confusing refresh with extract creation
• Thinking extracts only work with Excel

3. If you have a slow database but need fast dashboard performance, which connection type should you choose in Tableau?

medium

A. Extract connection to improve speed

B. Manual data entry for accuracy

C. Live connection to get real-time data

D. No connection, use static images

Solution

1. Step 1: Analyze performance needs

   Slow databases cause delays with live connections, hurting dashboard speed.

2. Step 2: Choose connection type for speed

   Extract connections store data locally, improving performance despite slow sources.

3. Final Answer:

   Extract connection to improve speed -> Option A

4. Quick Check:

   Slow source + speed need = Extract [OK]

Hint: Slow source? Use extract for faster dashboards [OK]

Common Mistakes:

• Choosing live connection despite slow source
• Thinking manual entry is faster
• Ignoring extract refresh needs

4. You created an extract but the dashboard shows outdated data. What is the most likely cause?

medium

A. You forgot to refresh the extract after data changed

B. Live connection was used instead of extract

C. The data source is offline

D. Tableau does not support extracts

Solution

1. Step 1: Understand extract behavior

   Extracts are snapshots and do not update automatically without refresh.

2. Step 2: Identify cause of outdated data

   If data changed but extract wasn't refreshed, dashboard shows old data.

3. Final Answer:

   You forgot to refresh the extract after data changed -> Option A

4. Quick Check:

   Extract needs refresh to update [OK]

Hint: Extracts need refresh to show new data [OK]

Common Mistakes:

• Assuming extracts auto-update
• Confusing live and extract connections
• Ignoring data source availability

5. You need a Tableau dashboard that updates every hour with fresh data but must also work if the database is temporarily offline. What is the best connection strategy?

hard

A. Use a live connection with no extract

B. Use a live connection only for real-time data

C. Use manual data entry to update hourly

D. Use an extract connection with hourly refresh schedule

Solution

1. Step 1: Analyze requirements

   Dashboard needs fresh data every hour and offline availability if database is down.

2. Step 2: Evaluate connection options

   Live connection fails if database is offline; extract with scheduled refresh meets both needs.

3. Step 3: Choose best strategy

   Extract connection with hourly refresh updates data regularly and works offline.

4. Final Answer:

   Use an extract connection with hourly refresh schedule -> Option D

5. Quick Check:

   Fresh + offline = Extract with refresh [OK]

Hint: Extract + scheduled refresh = fresh and offline-ready [OK]

Common Mistakes:

• Choosing live connection ignoring offline need
• Thinking manual entry is practical
• Not scheduling extract refresh