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.