Why connecting disparate data enables insights in Tableau - Why Use It

Introduction

Connecting different data sources lets you see the full story behind your business. It helps you combine pieces from separate places to find new patterns and answers that one source alone can't show.

When you want to compare sales data from your store system with customer feedback from surveys

When your marketing team needs to see how ad spend relates to website visits from Google Analytics

When you want to combine inventory data with supplier delivery times to spot delays

When you need to analyze employee performance alongside training records from another system

When your finance data is in one place and project costs are tracked elsewhere, but you want a combined report

Steps

Step 1: Open Tableau Desktop

- Start screen

You see options to connect to data sources

Step 2: Click 'Connect to Data' and select your first data source

- Connect pane

Tableau loads the first data source and shows its tables

Step 3: Click 'Add' to connect a second data source

- Data pane

The second data source appears alongside the first

Step 4: Drag tables from both data sources to the canvas

- Data Source tab

You see tables from both sources ready to be linked

Step 5: Create relationships by dragging fields that match between tables

- Data Source canvas

Tableau links the data sources so they can be analyzed together

💡 Use fields with the same meaning, like Customer ID or Date

Step 6: Go to a worksheet and start building views using fields from both sources

- Worksheet tab

You see combined data insights from the connected sources

Before vs After

Before

You have separate tables: one with sales data and another with customer survey results, shown separately in Tableau

After

You see a combined view where sales numbers and customer satisfaction scores appear together, revealing patterns like which products have happy customers

Settings Reference

Data Source Connection

📍 Connect pane on start screen

Choose the type of data source to connect to

Default: None

Relationships

📍 Data Source tab canvas

Define how tables from different sources relate to each other

Default: None

Join Type

📍 Relationship dialog

Control which matching or non-matching rows to include

Default: Inner

Common Mistakes

Connecting data sources without matching fields

Tableau cannot link data properly if fields do not correspond, leading to incorrect or empty results

Ensure you connect tables using fields that represent the same information, like IDs or dates

Using joins instead of relationships for disparate data

Joins can create duplicate or missing data when sources have different granularity

Use relationships to keep data separate but connected, preserving accuracy

Summary

Connecting different data sources in Tableau lets you combine information for deeper insights

Use matching fields to create relationships that link data without losing detail

Proper connections help reveal patterns you can't see from one source alone

Practice

1. Why is connecting different data sources in Tableau important for business insights?

easy

A. It makes the dashboard load slower.

B. It combines information to give a fuller picture of the business.

C. It hides data from users.

D. It deletes duplicate records automatically.

Solution

1. Step 1: Understand the purpose of connecting data

   Connecting data sources allows combining different pieces of information that alone may not show the full story.

2. Step 2: Recognize the benefit for insights

   By linking data, Tableau can show relationships and trends that help make better decisions.

3. Final Answer:

   It combines information to give a fuller picture of the business. -> Option B

4. Quick Check:

   Connecting data = fuller picture [OK]

Hint: Connecting data = fuller insights, not slower or hidden data [OK]

Common Mistakes:

• Thinking connecting data slows dashboards
• Believing it hides data
• Assuming it deletes duplicates automatically

2. Which Tableau feature is used to link different data sources without merging their tables?

easy

A. Relationships

B. Filters

C. Calculated fields

D. Data blending

Solution

1. Step 1: Identify Tableau features for connecting data

   Tableau uses joins, relationships, and blending to connect data sources.

2. Step 2: Understand relationships

   Relationships link tables logically without merging them, preserving their structure and enabling flexible analysis.

3. Final Answer:

   Relationships -> Option A

4. Quick Check:

   Link without merging = Relationships [OK]

Hint: Relationships link data without merging tables [OK]

Common Mistakes:

• Confusing blending with relationships
• Thinking calculated fields link data
• Assuming filters connect data sources

3. Given two data sources: Sales and Customers, connected by a relationship on Customer ID, what insight can Tableau show?

medium

A. Sales data duplicated for each customer

B. Only sales data without customer info

C. Customer names without sales numbers

D. Total sales amount per customer region

Solution

1. Step 1: Understand the relationship between Sales and Customers

   The relationship on Customer ID links sales records to customer details like region.

2. Step 2: Predict the combined insight

   Tableau can aggregate sales amounts grouped by customer region using this link.

3. Final Answer:

   Total sales amount per customer region -> Option D

4. Quick Check:

   Relationship enables combined sales and customer info [OK]

Hint: Relationship joins data for combined insights like sales by region [OK]

Common Mistakes:

• Thinking only sales or only customer data shows
• Assuming data duplicates incorrectly
• Ignoring the relationship effect

4. You connected two data sources in Tableau but the dashboard shows no combined data. What is the likely problem?

medium

A. Filters are turned off.

B. The data sources have too many rows.

C. The relationship keys do not match between sources.

D. Calculated fields are missing.

Solution

1. Step 1: Check the relationship keys

   If keys used to link data do not match, Tableau cannot combine the data correctly.

2. Step 2: Rule out other causes

   Data size, filters, or calculated fields do not prevent combining if keys match.

3. Final Answer:

   The relationship keys do not match between sources. -> Option C

4. Quick Check:

   Mismatch keys = no combined data [OK]

Hint: Check keys match to connect data properly [OK]

Common Mistakes:

• Blaming data size for no combined data
• Thinking filters off cause no join
• Assuming calculated fields are required to connect

5. You have three data sources: Orders, Products, and Suppliers. How does connecting all three in Tableau help find insights?

hard

A. It allows analysis of sales by product and supplier region together.

B. It automatically cleans all data errors.

C. It hides supplier details from the report.

D. It duplicates orders for each product.

Solution

1. Step 1: Understand the role of each data source

   Orders show sales, Products describe items, Suppliers provide origin info.

2. Step 2: Connect data to combine insights

   Linking all three lets Tableau show sales by product and supplier region, revealing patterns across sources.

3. Step 3: Recognize what connecting does not do

   It does not clean errors automatically, hide data, or duplicate records incorrectly.

4. Final Answer:

   It allows analysis of sales by product and supplier region together. -> Option A

5. Quick Check:

   Connecting multiple sources = combined insights [OK]

Hint: Connect all to analyze combined sales and supplier info [OK]

Common Mistakes:

• Expecting automatic data cleaning
• Thinking data gets hidden
• Assuming data duplicates incorrectly