Top Tableau Scenario-Based Interview Questions Set -29 (1- 5)

 

1. How would you identify customers whose profit margin is higher than the company average?

Compare customer profit margin against overall company profit margin.

{ FIXED [Customer ID] :
SUM([Profit]) / SUM([Sales])
}
>
{ FIXED :
SUM([Profit]) / SUM([Sales])
}

This helps identify highly profitable customers.

---

2. How would you calculate the percentage of sales contributed by the Top 10 customers?

First identify Top 10 customers, then divide their sales by total sales.

IF RANK(SUM([Sales])) <= 10
THEN SUM([Sales])
END

Contribution %:

WINDOW_SUM(
IF RANK(SUM([Sales])) <= 10
THEN SUM([Sales])
END
)
/
WINDOW_SUM(SUM([Sales]))

---

3. How would you identify products whose current month sales are lower than last month?

Compare current month sales with previous month sales.

SUM([Sales])
<
LOOKUP(SUM([Sales]),-1)

Compute using Month.

This highlights declining products.

---

4. How would you calculate customer tenure in days?

Calculate the number of days from first purchase until today.

DATEDIFF(
'day',
{ FIXED [Customer ID] :
MIN([Order Date])
},
TODAY()
)

This is commonly used in Customer Lifetime Value analysis.

---

5. How would you identify regions where profit growth is negative?

Compare current period profit against previous period profit.

(
SUM([Profit])
-
LOOKUP(SUM([Profit]),-1)
)
/
ABS(LOOKUP(SUM([Profit]),-1))
< 0

This identifies regions experiencing profit decline.