Live vs extract connections in Tableau - Business Scenario Comparison

Scenario Mode

👤 Your Role: You are a data analyst at a retail company.

📋 Request: Your manager wants to understand the difference between live and extract connections in Tableau and see which connection type is better for monthly sales reporting.

📊 Data: You have sales data with columns: Date, Region, Product, Sales Amount. The data is stored in a database that updates daily.

🎯 Deliverable: Create a simple Tableau dashboard showing monthly sales by region using both live and extract connections. Explain the pros and cons of each connection type.

Sample Data

Date	Region	Product	Sales Amount
2024-01-05	North	Widget A	1200
2024-01-15	South	Widget B	850
2024-02-10	East	Widget A	950
2024-02-20	West	Widget C	1100
2024-03-05	North	Widget B	1300
2024-03-15	South	Widget C	900
2024-04-10	East	Widget B	1000
2024-04-20	West	Widget A	1150

1

Step 1: Connect Tableau to the sales database using a live connection.

In Tableau, choose 'Connect' > select your database > choose 'Live' connection option.

Expected Result

Tableau connects directly to the database and fetches real-time data.

2

Step 2: Create a monthly sales by region view using the live connection.

Drag 'Date' to Columns, set to 'Month'. Drag 'Region' to Rows. Drag 'Sales Amount' to Text or Bars to show sum.

Expected Result

A chart showing monthly sales totals for each region with live data.

3

Step 3: Create an extract of the sales data in Tableau.

In Tableau, go to Data Source tab > select 'Extract' instead of 'Live' > click 'Extract' to save a snapshot of data.

Expected Result

Tableau creates a local snapshot of the data for faster access.

4

Step 4: Create the same monthly sales by region view using the extract connection.

Repeat the same steps as in step 2 but using the extract data source.

Expected Result

A chart showing monthly sales totals for each region with extract data.

5

Step 5: Compare performance and data freshness between live and extract connections.

Observe load times and check if recent data updates appear in each view.

Expected Result

Live connection shows latest data but may load slower; extract loads faster but data is as of last extract refresh.

6

Step 6: Summarize pros and cons of live vs extract connections in a text box on the dashboard.

Add a text object with points: Live - always current data, slower; Extract - faster, needs refresh, snapshot data.

Expected Result

Dashboard includes clear explanation helping manager understand connection types.

Final Result

Monthly Sales by Region Dashboard

+-----------------------------+
| Month | North | South | East | West |
|-------|-------|-------|------|------|
| Jan   | 1200  | 850   |      |      |
| Feb   |       |       | 950  | 1100 |
| Mar   | 1300  | 900   |      |      |
| Apr   |       |       | 1000 | 1150 |
+-----------------------------+

Connection Type: Live vs Extract

Pros and Cons:
- Live: Always current data, slower load
- Extract: Faster load, data snapshot, needs refresh

✓Live connection shows the most up-to-date sales data but can be slower to load.

✓Extract connection improves performance by using a snapshot but data may be outdated until refreshed.

✓For monthly sales reporting where data updates daily, extract connection with scheduled refresh balances speed and freshness.

Bonus Challenge

Create a parameter in Tableau to switch between live and extract connections dynamically in the dashboard.

Show Hint

Use Tableau's data source swapping feature with parameters and calculated fields to toggle connection types.

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