Top Tableau Scenario-Based Interview Questions Set - 17 (1- 10)

 

How would you calculate the percentage of total sales for each product?

Divide product sales by total sales.

Example:

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

---

2. How would you identify customers who placed only one order?

Count distinct orders per customer and filter those with exactly one order.

Example:

COUNTD([Order ID]) = 1

---

3. How would you calculate the average sales per day?

Divide total sales by the number of distinct order dates.

Example:

SUM([Sales]) / COUNTD([Order Date])

---

4. How would you identify the month with the highest sales?

Rank monthly sales and select Rank 1.

Example:

RANK(SUM([Sales])) = 1

---

5. How would you calculate the sales variance from the previous month?

Subtract previous month's sales from current month's sales.

Example:

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

---

6. How would you identify products contributing less than 1% of total sales?

Calculate contribution percentage and filter.

Example:

SUM([Sales]) / TOTAL(SUM([Sales])) < 0.01

---

7. How would you calculate the average order value by region?

Divide regional sales by distinct order count.

Example:

SUM([Sales]) / COUNTD([Order ID])

Place Region in the view.

---

8. How would you identify customers who generated a loss?

Filter customers whose total profit is negative.

Example:

SUM([Profit]) < 0

---

9. How would you calculate the percentage of returned orders?

Divide returned orders by total orders.

Example:

COUNT(
IF [Returned] = "Yes"
THEN [Order ID]
END
)
/
COUNT([Order ID])

---

10. How would you identify the best-performing state within each region?

Rank states by sales within each region.

Example:

RANK(SUM([Sales])) = 1

Compute Using: State
Partition By: Region

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

 

1. How would you calculate Customer Retention Rate in Tableau?

Calculate customers who purchased in both current and previous periods divided by total customers.

Example:

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

A retained customer can be identified using a Set or LOD calculation.

---

2. How would you identify the Top 3 Products within each Category?

Use Rank table calculation partitioned by Category.

Example:

RANK(SUM([Sales])) <= 3

Set Compute Using = Product and Restart Every = Category.

---

3. How would you calculate a customer's first purchase date?

Use a FIXED LOD expression.

Example:

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

This returns the first purchase date regardless of filters in the view.

---

4. How would you show customers whose sales are above their regional average?

Compare customer sales against the average sales within the region.

Example:

SUM([Sales])
>
WINDOW_AVG(SUM([Sales]))

Compute using Customer and partition by Region.

---

5. How would you identify the Bottom 10 Products by Profit?

Use Rank on Profit in ascending order.

Example:

RANK(SUM([Profit]),'asc') <= 10

Filter TRUE to display the 10 least profitable products.

Top Tableau Scenario-Based Interview Questions Set - 15 (1- 8)

 

How would you identify customers who purchased in consecutive months?

Use a table calculation to compare purchase months for each customer.

Example:

DATEDIFF(
   'month',
   LOOKUP(MIN([Order Date]),-1),
   MIN([Order Date])
) = 1

---

2. How would you calculate the percentage of orders shipped late?

Divide late orders by total orders.

Example:

SUM(
IF [Ship Date] > [Required Date]
THEN 1
ELSE 0
END
)
/
COUNT([Order ID])

---

3. How would you identify the customer with the highest lifetime sales?

Use a FIXED LOD to calculate total sales per customer and rank them.

Example:

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

Rank:

RANK(
{ FIXED [Customer ID] : SUM([Sales]) }
)
= 1

---

4. How would you calculate average monthly profit?

Aggregate profit at month level and average it.

Example:

WINDOW_AVG(SUM([Profit]))

Or:

SUM([Profit])
/
COUNTD(DATETRUNC('month',[Order Date]))

---

5. How would you identify regions where sales exceeded target?

Compare actual sales against target.

Example:

SUM([Sales]) > SUM([Target Sales])

Variance:

SUM([Sales]) - SUM([Target Sales])

---

6. How would you find customers who have not purchased in the last 6 months?

Calculate days since the last purchase.

Example:

DATEDIFF(
'month',
{ FIXED [Customer ID] : MAX([Order Date]) },
TODAY()
) > 6

---

7. How would you calculate the average gap between customer orders?

Find the difference between consecutive order dates.

Example:

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

Then apply:

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

---

8. How would you identify the most profitable customer in each region?

Rank customers by profit within each region.

Example:

RANK(SUM([Profit])) = 1

Set Compute Using = Customer and Partition By = Region.

Top Tableau Scenario-Based Interview Questions Set - 14 (1- 12)

 

1. How would you calculate year-over-year profit growth?
   Compare current year profit with previous year profit.
   Example:

   (SUM([Profit]) - LOOKUP(SUM([Profit]),-1))
   / LOOKUP(SUM([Profit]),-1)
   

2. How would you identify customers with highest return orders?
   Count returned orders by customer and rank them.
   Example:

   COUNT([Return Flag])
   

3. How would you display only profitable regions?
   Filter regions where total profit is positive.
   Example:

   SUM([Profit]) > 0
   

4. How would you calculate average revenue per product?
   Divide total sales by distinct products.
   Example:

   SUM([Sales]) / COUNTD([Product ID])
   

5. How would you identify orders with unusually high sales?
   Compare sales against average plus standard deviation.
   Example:

   SUM([Sales]) >
   WINDOW_AVG(SUM([Sales])) +
   WINDOW_STDEV(SUM([Sales]))
   

6. How would you create a sales forecast trend?
   Use Analytics pane and enable Forecast option.
   Example:

   SUM([Sales])
   

7. How would you calculate median sales value?
   Use MEDIAN aggregation on Sales.
   Example:

   MEDIAN([Sales])
   

8. How would you identify products sold in all regions?
   Compare distinct region count with total region count.
   Example:

   COUNTD([Region]) = 4
   

9. How would you create a customer aging analysis?
   Calculate days since last purchase.
   Example:

   DATEDIFF('day',MAX([Order Date]),TODAY())
   

10. How would you display profit variance from target?
    Subtract target profit from actual profit.
    Example:

    SUM([Profit]) - SUM([Target Profit])

11. How would you identify top-selling products by state?
    Use RANK calculation partitioned by State.
    Example:

    RANK(SUM([Sales])) = 1

12. How would you calculate cumulative customer count over time?
    Use running total on distinct customers.
    Example:

    RUNNING_SUM(COUNTD([Customer ID]))

Top Tableau Scenario-Based Interview Questions Set - 13 (1- 10)

 

1. How would you calculate customer purchase frequency?
   Divide total orders by distinct customers.
   Example:

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

2. How would you identify the most profitable product category?
   Rank categories based on total profit.
   Example:

   RANK(SUM([Profit])) = 1
   

3. How would you calculate average discount percentage?
   Use AVG aggregation on Discount field.
   Example:

   AVG([Discount]) * 100
   

4. How would you identify customers with zero profit orders?
   Filter orders where profit equals zero.
   Example:

   SUM([Profit]) = 0
   

5. How would you compare quarterly sales performance?
   Use Quarter dimension with Sales measure.
   Example:

   DATETRUNC('quarter',[Order Date])
   

6. How would you calculate average shipping delay by region?
   Use DATEDIFF and aggregate by Region.
   Example:

   AVG(DATEDIFF('day',[Ship Date],[Delivery Date]))
   

7. How would you identify high-discount low-profit orders?
   Apply conditional filter using Discount and Profit.
   Example:

   [Discount] > 0.3
   AND
   [Profit] < 0
   

8. How would you create dynamic ranking in Tableau?
   Use parameter-driven rank calculation.
   Example:

   RANK(SUM([Sales])) <= [Top Rank]
   

9. How would you calculate customer-wise profit margin?
   Divide customer profit by customer sales.
   Example:

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

10. How would you identify products with declining sales trend?
    Compare current sales with previous period sales.
    Example:

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

Top Tableau Scenario-Based Interview Questions Set - 12 (1- 15)

 

1. How would you identify customers with highest average order value?
   Divide total sales by distinct orders for each customer.
   Example:

   SUM([Sales]) / COUNTD([Order ID])
   

2. How would you calculate sales growth between two selected years?
   Compare sales using year filter or parameter selection.
   Example:

   (SUM([Sales CY]) - SUM([Sales PY]))
   / SUM([Sales PY])
   

3. How would you identify products never sold?
   Use left join/scaffold and check for null sales.
   Example:

   ISNULL(SUM([Sales]))
   

4. How would you create a moving average for 6 months?
   Use WINDOW_AVG table calculation.
   Example:

   WINDOW_AVG(SUM([Sales]),-5,0)
   

5. How would you show customers with sales above regional average?
   Compare customer sales against window average.
   Example:

   SUM([Sales]) > WINDOW_AVG(SUM([Sales]))
   

6. How would you calculate profit contribution percentage?
   Divide individual profit by total profit.
   Example:

   SUM([Profit]) / TOTAL(SUM([Profit]))
   

7. How would you identify seasonal sales spikes?
   Compare monthly sales trends across years.
   Example:

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

8. How would you create a customer retention dashboard?
   Track repeat customers over periods using COUNTD.
   Example:

   COUNTD([Customer ID])
   

9. How would you calculate days between first and last purchase?
   Use MIN and MAX order dates.
   Example:

   DATEDIFF('day',
   MIN([Order Date]),
   MAX([Order Date]))
   

10. How would you identify underperforming regions?
    Compare regional sales against target or average sales.
    Example:

    SUM([Sales]) < WINDOW_AVG(SUM([Sales]))

Top Tableau Scenario-Based Interview Questions Set - 11 (1- 15)

 

1. How would you identify top profit-making customers?
   Rank customers based on Profit measure.
   Example:

   RANK(SUM([Profit])) <= 10
   

2. How would you calculate average order quantity?
   Divide total quantity by distinct orders.
   Example:

   SUM([Quantity]) / COUNTD([Order ID])
   

3. How would you show only last 30 days sales?
   Filter records using DATEDIFF.
   Example:

   DATEDIFF('day',[Order Date],TODAY()) <= 30
   

4. How would you identify products with highest growth?
   Compare current sales with previous period sales.
   Example:

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

5. How would you create customer segmentation in Tableau?
   Group customers based on sales value.
   Example:

   IF SUM([Sales]) > 100000 THEN "Premium"
   ELSEIF SUM([Sales]) > 50000 THEN "Gold"
   ELSE "Standard"
   END
   

6. How would you identify orders shipped on the same day?
   Compare Order Date and Ship Date.
   Example:

   DATEDIFF('day',[Order Date],[Ship Date]) = 0
   

7. How would you calculate sales per region percentage?
   Divide regional sales by total sales.
   Example:

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

8. How would you create a dynamic measure selector?
   Use parameter with CASE statement.
   Example:

   CASE [Measure Selector]
   WHEN "Sales" THEN SUM([Sales])
   WHEN "Profit" THEN SUM([Profit])
   WHEN "Quantity" THEN SUM([Quantity])
   END
   

9. How would you identify the best month for sales?
   Rank monthly sales values.
   Example:

   RANK(SUM([Sales])) = 1
   

10. How would you calculate order processing time?
    Use DATEDIFF between order and shipment dates.
    Example:

        DATEDIFF('day',[Order Date],[Ship Date])

11. How would you display customers contributing negative profit?
    Filter customers with loss.
    Example:

        SUM([Profit]) < 0

12. How would you compare sales against target percentage?
    Divide actual sales by target sales.
    Example:

        SUM([Sales]) / SUM([Target])

13. How would you calculate distinct customer count by region?
    Use COUNTD function.
    Example:

        COUNTD([Customer ID])

14. How would you create a flag for high-priority orders?
    Use conditional logic on Priority field.
    Example:

        IF [Priority] = "High" THEN "Important"
        ELSE "Normal"
        END

15. How would you display monthly average profit trend?
    Use AVG aggregation with Month dimension.
    Example:

        AVG([Profit])