Tableau vs Power BI comparison - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a calculated field in Tableau that sums sales.

Tableau

SUM([1])

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

ADiscount

BProfit

CQuantity

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using a field other than Sales, like Profit or Quantity.

The SUM function in Tableau adds up all values in the specified field. Here, we sum the 'Sales' field.

2fill in blank

medium

Complete the code to filter data in Tableau to show only records where Profit is positive.

Tableau

[Profit] [1] 0

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

A<

B=

C>

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' or '=' which would not select positive profits.

To filter for positive profits, use the greater than operator '>'.

3fill in blank

hard

Fix the error in this Tableau LOD expression to calculate total sales per region.

Tableau

{FIXED [Region]: SUM([1])}

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

AQuantity

BSales

CProfit

DDiscount

Attempts:

3 left

💡 Hint

Common Mistakes

Using Profit or Quantity instead of Sales.

The LOD expression fixes the calculation by region summing the 'Sales' field.

4fill in blank

hard

Fill both blanks to create a calculated field that shows average profit per category only for profits above zero.

Tableau

IF [Profit] [1] 0 THEN AVG([2]) END

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

A>

BProfit

CSales

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' or averaging Sales instead of Profit.

The IF condition filters profits greater than zero, then calculates average profit.

5fill in blank

hard

Fill all three blanks to create a calculated field that returns 'High' if sales exceed 10000, 'Medium' if sales are between 5000 and 10000, else 'Low'.

Tableau

IF [Sales] [1] 10000 THEN 'High' ELSEIF [Sales] [2] 5000 AND [Sales] [3] 10000 THEN 'Medium' ELSE 'Low' END

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

A>

B<=

C>=

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up comparison operators or incorrect logical conditions.

The first condition checks if sales are greater than 10000 for 'High'. The second checks if sales are greater than or equal to 5000 and less than or equal to 10000 for 'Medium'. Otherwise, it returns 'Low'.