Multiple data sources in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

Tableau

JOIN ON [1] = CustomerID

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

ACustomers.CustomerID

BOrders.CustomerID

CSales.CustomerID

DProducts.ProductID

Attempts:

3 left

💡 Hint

Common Mistakes

Using a field from the wrong data source for the join.

Joining on a non-matching field.

In Tableau, when joining data sources, you specify the field from the primary data source first. Here, Orders.CustomerID is the correct field to join on.

2fill in blank

medium

Complete the code to blend data sources using a common field in Tableau.

Tableau

Data blending is done by linking on [1]

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

ARegion

BProductID

CDate

DSalesAmount

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a measure field like SalesAmount instead of a dimension.

Selecting a field that does not exist in both data sources.

Data blending in Tableau requires a common field to link the data sources. Usually, Date is a common field used for blending time-based data.

3fill in blank

hard

Fix the error in the Tableau calculated field to aggregate data from multiple sources.

Tableau

SUM([1]) + SUM([Sales])

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

AProfit

B[Profit].[Orders]

C[Profit]

D[Orders].[Profit]

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting the data source name.

Using incorrect bracket placement.

When aggregating fields from multiple data sources in Tableau, you must specify the data source name before the field in square brackets, like [Orders].[Profit].

4fill in blank

hard

Fill both blanks to correctly create a relationship between two data sources in Tableau.

Tableau

CREATE RELATIONSHIP BETWEEN [1] AND [2]

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

AOrders.OrderID

BCustomers.CustomerID

COrders.CustomerID

DProducts.ProductID

Attempts:

3 left

💡 Hint

Common Mistakes

Using OrderID instead of CustomerID for the relationship.

Mixing fields from unrelated data sources.

To create a relationship between Orders and Customers, you link Orders.CustomerID to Customers.CustomerID.

5fill in blank

hard

Fill all three blanks to write a Tableau LOD expression that calculates total sales per customer across multiple data sources.

Tableau

{ FIXED [1] : SUM([2].[3]) }

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

A[CustomerID]

B[Orders]

C[Sales]

DCustomerID

Attempts:

3 left

💡 Hint

Common Mistakes

Using brackets incorrectly around CustomerID.

Omitting the data source name before the field.

Confusing dimension and measure placement.

The LOD expression fixes the calculation by CustomerID and sums the [Sales] field from the [Orders] data source.