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

 

1. How would you identify customers whose sales are declining for 3 consecutive months?

Compare current month sales with the previous two months using table calculations.

Example:

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

---

2. How would you calculate the percentage of new customers each month?

Identify customers whose first purchase occurred in the selected month and divide by total customers.

Example:

COUNTD(
IF DATETRUNC('month',[Order Date]) =
{ FIXED [Customer ID] : DATETRUNC('month',MIN([Order Date])) }
THEN [Customer ID]
END
)
/
COUNTD([Customer ID])

---

3. How would you identify products with sales above the category average?

Compare product sales against category average using a FIXED LOD.

Example:

SUM([Sales]) >
{ FIXED [Category] : AVG([Sales]) }

---

4. How would you calculate customer profitability ranking?

Rank customers based on total profit generated.

Example:

RANK(SUM([Profit]))

Sort Profit descending to get highest-profit customers at Rank 1.

---

5. How would you identify regions contributing more than 25% of total sales?

Calculate regional contribution and filter regions above 25%.

Example:

SUM([Sales])
/
TOTAL(SUM([Sales]))
> 0.25

This highlights the regions driving a significant portion of overall revenue.

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

 

1. How would you identify customers who have purchased from multiple product categories?

Count distinct categories purchased by each customer and filter those with more than one category.

Example:

{ FIXED [Customer ID] : COUNTD([Category]) } > 1

---

2. How would you calculate the percentage of orders delivered within SLA?

Count orders delivered within SLA and divide by total orders.

Example:

SUM(
IF DATEDIFF('day',[Order Date],[Ship Date]) <= 3
THEN 1
ELSE 0
END
)
/
COUNT([Order ID])

---

3. How would you identify the highest-selling product in each category?

Rank products by sales within each category.

Example:

RANK(SUM([Sales])) = 1

Compute Using: Product
Partition By: Category

---

4. How would you calculate average days between customer purchases?

Find the difference between consecutive orders and average them.

Example:

WINDOW_AVG(
DATEDIFF(
'day',
LOOKUP(MIN([Order Date]),-1),
MIN([Order Date])
)
)

---

5. How would you identify customers whose profit margin is below 5%?

Calculate profit margin and filter low-margin customers.

Example:

SUM([Profit])
/
SUM([Sales])
< 0.05

This highlights customers generating sales but very little profit.