Why connecting disparate data enables insights in Tableau - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a join between two data sources in Tableau.

Tableau

JOIN ON [1] = Customers.CustomerID

Drag options to blanks, or click blank then click option'

AOrders.OrderID

BOrders.Sales

COrders.CustomerID

DOrders.ProductID

Attempts:

3 left

💡 Hint

Common Mistakes

Joining on OrderID instead of CustomerID

Using a field that does not exist in both tables

The join should be made on the CustomerID field from both tables to connect customer orders correctly.

2fill in blank

medium

Complete the code to blend data from two sources using a common field.

Tableau

DATA BLEND ON [1]

Drag options to blanks, or click blank then click option'

ACustomerID

BRegion

CDate

DProductName

Attempts:

3 left

💡 Hint

Common Mistakes

Using ProductName which may not be unique

Using Region which is too broad

CustomerID is the common field used to blend customer-related data from different sources.

3fill in blank

hard

Fix the error in the join condition to correctly connect sales and customer data.

Tableau

JOIN ON Sales.[1] = Customers.CustomerID

Drag options to blanks, or click blank then click option'

ACustomerName

BSalesAmount

COrderID

DCustomerID

Attempts:

3 left

💡 Hint

Common Mistakes

Joining on CustomerName which can have duplicates

Joining on OrderID which is not in Customers table

The join must be on CustomerID to correctly link sales records to customers.

4fill in blank

hard

Fill both blanks to create a calculated field that combines sales and customer data.

Tableau

IF ISNULL([1]) THEN 'No Sales' ELSE [2] END

Drag options to blanks, or click blank then click option'

ASUM(Sales.Amount)

BCustomers.CustomerName

CAVG(Sales.Amount)

DSales.Amount

Attempts:

3 left

💡 Hint

Common Mistakes

Using aggregate functions in the null check

Swapping the fields in the IF statement

The calculation checks if Sales.Amount is null to label 'No Sales', otherwise shows the CustomerName.

5fill in blank

hard

Fill all three blanks to create a calculated field that shows total sales per customer region.

Tableau

TOTAL_SALES = { FIXED [1] : SUM([2]) } WHERE Region = '[3]'

Drag options to blanks, or click blank then click option'

ACustomers.Region

BSales.Amount

CWest

DSales.Region

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales.Region instead of Customers.Region

Using wrong region name

Using wrong measure field

The FIXED LOD expression fixes the calculation by customer region summing sales amount, filtered for the West region.

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