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)