Data relationships model in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a relationship between two tables in Tableau.

Tableau

RELATE TABLE Orders TO Customers ON Orders.CustomerID [1] Customers.CustomerID

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

A=

BIN

CLIKE

DJOIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using SQL join keywords instead of equality operator.

In Tableau, relationships between tables are defined by matching keys using the equals sign (=).

2fill in blank

medium

Complete the code to specify the cardinality of a relationship in Tableau.

Tableau

CREATE RELATIONSHIP BETWEEN Orders AND Customers WITH CARDINALITY [1]

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

AMany-to-Many

BOne-to-Many

CMany-to-One

DOne-to-One

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing the direction of cardinality.

Typically, the relationship from Customers to Orders is one-to-many, meaning one customer can have many orders.

3fill in blank

hard

Fix the error in the relationship definition code.

Tableau

RELATE TABLE Sales TO Products ON Sales.ProductID [1] Products.ProductKey

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

A=

B==

C===

D!=

Attempts:

3 left

💡 Hint

Common Mistakes

Using programming language equality operators instead of Tableau syntax.

Tableau uses a single equals sign (=) to define relationships between keys, not double or triple equals.

4fill in blank

hard

Fill both blanks to define a relationship with referential integrity and cardinality.

Tableau

DEFINE RELATIONSHIP BETWEEN Orders AND Customers ON Orders.CustomerID [1] Customers.CustomerID WITH CARDINALITY [2]

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

A=

BOne-to-Many

CMany-to-One

DLIKE

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong operators or confusing cardinality directions.

The relationship uses '=' to match keys and 'One-to-Many' to specify cardinality from Customers to Orders.

5fill in blank

hard

Fill all three blanks to create a relationship with matching keys, cardinality, and referential integrity.

Tableau

CREATE RELATIONSHIP BETWEEN Sales [1] Products ON Sales.ProductID [2] Products.ProductID WITH CARDINALITY [3]

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

AAND

B=

CMany-to-One

DOR

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'OR' instead of 'AND', or wrong cardinality.

The 'AND' connects tables, '=' matches keys, and 'Many-to-One' defines cardinality from Sales to Products.