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

 

1. How would you calculate Month-over-Month (MoM) growth in Tableau?
   Compare current month sales with previous month using table calculation.
   Example:

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

2. How would you identify the top customer in each region?
   Use RANK function partitioned by Region.
   Example:

   RANK(SUM([Sales])) = 1
   

   Compute using Customer within each Region.

3. How would you show customers contributing 80% of sales?
   Use running total percentage on sorted sales.
   Example:

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

   Filter values <= 0.8.

4. How would you create a band chart for min and max sales?
   Use reference bands with MIN and MAX values.
   Example:

   WINDOW_MIN(SUM([Sales]))
   WINDOW_MAX(SUM([Sales]))
   

5. How would you compare actual vs forecast sales?
   Use dual-axis chart with actual and forecast measures.
   Example:

   SUM([Actual Sales])
   SUM([Forecast Sales])
   

6. How would you identify outliers in sales data?
   Compare values against average and standard deviation.
   Example:

   ABS(SUM([Sales]) - WINDOW_AVG(SUM([Sales])))
   > 2 * WINDOW_STDEV(SUM([Sales]))
   

7. How would you create dynamic date filtering?
   Use parameter to select periods like MTD, QTD, YTD.
   Example:

   IF [Date Filter] = "YTD"
   THEN DATETRUNC('year',[Order Date]) = DATETRUNC('year',TODAY())
   END
   

8. How would you show last N months dynamically?
   Use parameter with DATEDIFF calculation.
   Example:

   DATEDIFF('month',[Order Date],TODAY()) <= [N Months]
   

9. How would you create a funnel chart in Tableau?
   Use calculated negative values for one side of bar chart.
   Example:

   -SUM([Stage Count])
   

   Place positive and negative bars symmetrically.

10. How would you display average order value (AOV)?
    Divide total sales by distinct order count.
    Example:

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

Bhagavad Gita Wisdom #shorts
https://www.youtube.com/playlist?list=PLQM-BpTd9ZSumxwKgJjuJjlx2OcP_W516