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 

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

 

1. How would you show Top N and Others in a chart?
   Create a parameter for Top N and group remaining values as “Others.”
   Example:

   IF RANK(SUM([Sales])) <= [Top N]
   THEN [Customer Name]
   ELSE "Others"
   END
   

2. How would you display only the latest record for each customer?
   Use FIXED LOD with MAX(Date).
   Example:

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

   Filter records where Order Date equals latest date.

3. How would you create Year-over-Year growth calculation?
   Compare current year sales with previous year sales.
   Example:

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

4. How would you create a running total sales chart?
   Apply Running Total table calculation on Sales measure.
   Example:

   RUNNING_SUM(SUM([Sales]))
   

5. How would you show percentage contribution by category?
   Use Percent of Total table calculation.
   Example:

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

6. How would you highlight top-performing regions dynamically?
   Use conditional formatting based on rank.
   Example:

   RANK(SUM([Sales])) <= 3
   

   Color TRUE regions differently.

7. How would you swap measures dynamically using parameter?
   Create parameter with Sales, Profit, Quantity values.
   Example:

   CASE [Measure Parameter]
   WHEN "Sales" THEN SUM([Sales])
   WHEN "Profit" THEN SUM([Profit])
   WHEN "Quantity" THEN SUM([Quantity])
   END
   

8. How would you create a dynamic reference line?
   Use parameter-driven reference value.
   Example:

   [Target Value]
   

   Drag parameter measure to Reference Line.

9. How would you identify customers with declining sales?
   Compare current period sales with previous period.
   Example:

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

   Filter TRUE customers.

10. How would you create a heatmap for sales performance?
    Use dimensions on Rows/Columns and Sales on Color.
    Example:

SUM([Sales])

Higher sales automatically display darker intensity colors.

Bhagavad Gita Wisdom #shorts

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