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

 

1. How would you identify the second highest sales in Tableau?
   Use RANK function and filter for rank = 2.
   Example:

   RANK(SUM([Sales])) = 2
   

2. How would you calculate cumulative percentage contribution?
   Use Running Total divided by Total Sales.
   Example:

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

3. How would you show only weekends sales data?
   Filter dates using DATEPART function.
   Example:

   DATEPART('weekday',[Order Date]) IN (1,7)
   

4. How would you classify customers as High, Medium, and Low sales?
   Use conditional calculated field based on sales range.
   Example:

   IF SUM([Sales]) >= 100000 THEN "High"
   ELSEIF SUM([Sales]) >= 50000 THEN "Medium"
   ELSE "Low"
   END
   

5. How would you create a flag for profit-making orders?
   Use IF condition on Profit field.
   Example:

   IF SUM([Profit]) > 0 THEN "Profit"
   ELSE "Loss"
   END
   

6. How would you calculate average sales per customer?
   Divide total sales by distinct customers.
   Example:

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

7. How would you display only first purchase date for customers?
   Use FIXED LOD with MIN(Date).
   Example:

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

8. How would you identify customers with no orders in the last 90 days?
   Compare latest order date with today.
   Example:

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

9. How would you create a Pareto chart in Tableau?
   Combine bars and cumulative percentage line.
   Example:

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

10. How would you calculate profit margin percentage?
    Divide Profit by Sales and multiply by 100.
    Example:

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

Bhagavad Gita Wisdom #shorts

https://www.youtube.com/playlist?list=PLQM-BpTd9ZSumxwKgJjuJjlx2OcP_W516