Why Tableau is the leader in visual analytics - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a basic bar chart in Tableau.

Tableau

Drag the [1] field to Columns and the Sales field to Rows.

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

ACategory

BProfit

CDate

DRegion

Attempts:

3 left

💡 Hint

Common Mistakes

Using a measure like Profit instead of a dimension for Columns.

Choosing Date which is usually on Rows or Filters.

Category is commonly used on Columns to create bar charts showing sales by category.

2fill in blank

medium

Complete the code to filter data for the year 2023 in Tableau.

Tableau

Drag the [1] field to Filters and select 2023.

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

ARegion

BOrder Date

CCategory

DCustomer Name

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dimension like Region which is not a date.

Trying to filter on Customer Name which is not related to date.

Order Date is the date field used to filter data by year.

3fill in blank

hard

Fix the error in the calculated field to compute profit ratio.

Tableau

Profit Ratio = SUM([Profit]) / SUM([1])

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

ACategory

BQuantity

CDiscount

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using Quantity or Discount which do not represent total sales.

Using Category which is a dimension, not a measure.

Profit ratio is profit divided by sales, so SUM([Sales]) is correct.

4fill in blank

hard

Fill both blanks to create a calculated field that shows sales growth percentage.

Tableau

Sales Growth % = (SUM([Sales]) - SUM([1])) / SUM([2]) * 100

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

A[Previous Year Sales]

B[Sales]

D[Profit]

Attempts:

3 left

💡 Hint

Common Mistakes

Using Profit instead of previous sales.

Using current Sales in denominator instead of previous sales.

Sales growth compares current sales to previous year sales, so both blanks use Previous Year Sales.

5fill in blank

hard

Fill the blanks to create a Level of Detail (LOD) expression that calculates average sales per customer.

Tableau

{ FIXED [1] : AVG([2]) }

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

A[Customer ID]

B[Sales]

C[Order Date]

D[Profit]

Attempts:

3 left

💡 Hint

Common Mistakes

Fixing on Order Date instead of Customer ID.

Averaging Profit instead of Sales.

The LOD fixes on Customer ID to calculate average Sales per customer: { FIXED [Customer ID] : AVG([Sales]) }.