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 

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

1. How would you fix blend errors?
   Ensure both data sources have a common linking field with matching data types and values.
   Example:

   STR([Customer ID])
   

   Convert fields to same datatype if one source has Number and another has String.

2. How would you fix duplicate marks in blended view?
   Duplicates usually happen due to different granularity in secondary source.
   Use aggregation like:

   SUM([Target Sales])
   

   or FIXED LOD:

   { FIXED [Region] : SUM([Target]) }
   

3. How would you reduce marks in scatter plot?
   Reduce dimensions and aggregate measures to minimize rendered points.
   Example:

   AVG([Sales])
   

   by Region instead of Customer-level data reduces mark count significantly.

4. How would you design mobile-friendly dashboards?
   Use Device Designer and create separate mobile layouts with fewer visuals and filters.
   Example:
   Keep only KPI cards and one chart on mobile instead of full desktop dashboard.

5. How would you secure row-level data?
   Create user-based filter logic using USERNAME() function.
   Example:

   [Region Manager] = USERNAME()
   

   Users will see only their assigned region data.

6. How would you fix incorrect totals in dashboard?
   Validate joins, aggregation level, and table calculation scope.
   Example:

   SUM([Sales])
   

   may duplicate after joins, so use:

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

   to avoid inflated totals.

Bhagavad Gita Wisdom #shorts

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