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

 

How would you identify customers whose sales increased by more than 20% compared to the previous year?

Calculate YoY growth and filter customers above 20%.

Example:

(
SUM([Sales]) - LOOKUP(SUM([Sales]),-1)
)
/
LOOKUP(SUM([Sales]),-1)
> 0.20

---

2. How would you calculate the average number of orders per customer?

Divide total distinct orders by total distinct customers.

Example:

COUNTD([Order ID])
/
COUNTD([Customer ID])

---

3. How would you identify products that have never generated profit?

Filter products whose total profit is zero or negative.

Example:

SUM([Profit]) <= 0

---

4. How would you calculate the percentage of customers contributing to 80% of sales?

Use cumulative sales percentage and count qualifying customers.

Example:

RUNNING_SUM(SUM([Sales]))
/
TOTAL(SUM([Sales]))
<= 0.8

Sort customers by Sales descending before applying the calculation.

---

5. How would you identify the most recent order for each customer?

Use a FIXED LOD to get the latest order date.

Example:

{ FIXED [Customer ID] : MAX([Order Date]) }

Then filter:

[Order Date] =
{ FIXED [Customer ID] : MAX([Order Date]) }

to display only the latest order record per customer.