Performance considerations in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create an extract for better performance in Tableau.

Tableau

CREATE EXTRACT [1] FROM data_source

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

ADATA

BFAST

CTABLE

DTABLEAU

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'FAST' or 'TABLEAU' instead of 'TABLE' causes syntax errors.

Trying to extract 'DATA' is too vague and incorrect.

In Tableau, creating an extract from a table improves performance by reducing live queries.

2fill in blank

medium

Complete the Tableau calculation to limit data for faster dashboard loading.

Tableau

IF [Order Date] [1] DATE("2023-01-01") THEN [Sales] ELSE 0 END

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

A=

B<=

C!=

D>=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<=' would include older dates, not limiting data.

Using '!=' or '=' filters incorrectly and may exclude needed data.

Using >= filters data to only include orders from 2023 onward, improving performance.

3fill in blank

hard

Fix the error in the Tableau LOD expression to calculate average sales per customer.

Tableau

{ FIXED [Customer ID] : AVG([1]) }

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

A[Sales]

BSales

CSUM([Sales])

DAVG([Sales])

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting brackets causes syntax errors.

Using aggregation inside LOD causes wrong calculations.

The correct syntax uses the field name with square brackets: [Sales].

4fill in blank

hard

Fill both blanks to optimize Tableau dashboard performance by reducing data and aggregation.

Tableau

SUM(IF [Region] [1] "West" THEN [Sales] ELSE 0 END) / COUNTD([2])

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

A=

B!=

C[Customer ID]

D[Order ID]

Attempts:

3 left

💡 Hint

Common Mistakes

Using '!=' includes unwanted regions.

Counting [Order ID] may not reflect customer aggregation.

Filtering region with = 'West' limits data. Counting by [Customer ID] aggregates correctly.

5fill in blank

hard

Fill all three blanks to create a calculated field that improves performance by filtering and aggregating sales.

Tableau

SUM(IF [Category] [1] "Furniture" AND [Sales] [2] 1000 THEN [3] ELSE 0 END)

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

A=

B>

C[Sales]

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' filters wrong sales values.

Not summing [Sales] causes calculation errors.

Filter category with = 'Furniture', sales greater than 1000, and sum the [Sales] field.