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])

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

1. How would you calculate contribution margin in Tableau?
   Subtract cost from sales and divide by sales percentage.
   Example:

   (SUM([Sales]) - SUM([Cost])) / SUM([Sales])
   

2. How would you identify repeat customers?
   Count distinct orders per customer and filter customers with more than one order.
   Example:

   COUNTD([Order ID]) > 1
   

3. How would you display sales only for the current year?
   Compare order year with current year.
   Example:

   YEAR([Order Date]) = YEAR(TODAY())
   

4. How would you calculate average monthly sales?
   Divide total sales by distinct months.
   Example:

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

5. How would you identify customers with decreasing profit?
   Compare current profit with previous period profit.
   Example:

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

6. How would you create a sales bucket classification?
   Group sales into ranges using calculated field.
   Example:

   IF SUM([Sales]) < 10000 THEN "Low"
   ELSEIF SUM([Sales]) < 50000 THEN "Medium"
   ELSE "High"
   END
   

7. How would you calculate percentage difference from average sales?
   Compare sales against average sales.
   Example:

   (SUM([Sales]) - WINDOW_AVG(SUM([Sales])))
   / WINDOW_AVG(SUM([Sales]))
   

8. How would you identify delayed shipments?
   Calculate shipping days and filter delayed orders.
   Example:

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

9. How would you create a dynamic date range filter?
   Use parameters for start and end dates.
   Example:

   [Order Date] >= [Start Date]
   AND
   [Order Date] <= [End Date]
   

10. How would you display cumulative profit trend?
    Use running total calculation on Profit.
    Example:

RUNNING_SUM(SUM([Profit]))