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.