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

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

 

1. How would you calculate customer lifetime value (CLV) in Tableau?
   Aggregate total sales for each customer across all orders.
   Example:

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

2. How would you identify the fastest growing region?
   Compare current period sales growth across regions.
   Example:

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

3. How would you display top-selling product per category?
   Use RANK within each category.
   Example:

   RANK(SUM([Sales])) = 1
   

   Compute using Product within Category.

4. How would you create a rolling 12-month sales calculation?
   Use WINDOW_SUM over last 12 months.
   Example:

   WINDOW_SUM(SUM([Sales]),-11,0)
   

5. How would you identify inactive products?
   Check products with no recent sales.
   Example:

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

6. How would you calculate average profit per order?
   Divide total profit by distinct order count.
   Example:

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

7. How would you create a dynamic KPI color indicator?
   Use conditional calculation for color coding.
   Example:

   IF SUM([Sales]) > [Target]
   THEN "Green"
   ELSE "Red"
   END
   

8. How would you compare weekday vs weekend sales?
   Create calculated field using DATEPART.
   Example:

   IF DATEPART('weekday',[Order Date]) IN (1,7)
   THEN "Weekend"
   ELSE "Weekday"
   END
   

9. How would you show monthly sales variance?
   Compare current month sales with previous month.
   Example:

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

10. How would you identify high-value customers dynamically?
    Use parameter-driven sales threshold.
    Example:

     IF SUM([Sales]) > [Sales Threshold]
     THEN "High Value"
     ELSE "Normal"
     END