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

1. How would you create a dynamic title?
   Create a calculated field or directly insert parameter/filter values into the title.
   Example Title:

   Sales Report for YEAR[Order Date])
   

   Or use:

   "Sales for " + [Region]
   

2. How would you show KPI cards with arrows?
   Create a KPI calculation comparing current vs previous period.
   Example:

   IF SUM([Sales]) > LOOKUP(SUM([Sales]),-1)
   THEN "▲"
   ELSE "▼"
   END
   

   Use shapes/colors: Green for increase, Red for decrease.

3. How would you build dependent filters?
   Add Country filter first, then State filter and select “Only Relevant Values.”
   Example: Selecting India shows Karnataka, Delhi, etc., while USA shows Texas, California.
4. How would you implement cascading filters?
   Use parent-child filters where child values depend on parent selection.
   Example:
   Country → State → City
   Selecting “India” filters only Indian states and cities.

5. How would you create a customer search box?
   Create a parameter for user input and use a calculated field:

   CONTAINS(LOWER([Customer Name]), LOWER([Search Parameter]))
   

   Place calculation on Filters and keep TRUE.

6. How would you drill down Region → State → City?
   Create hierarchy by dragging State under Region and City under State.
   Users can click “+” icon to expand from Region → State → City interactively.
7. How would you create a reset filters button?
   Create a duplicate dashboard with default filters and use navigation button.
   Clicking Reset redirects users to original dashboard with default filter values.

8. How would you blend sales and target data?
   Use Sales as primary source and Target as secondary source linked by Region/Date.
   Example Calculation:

   SUM([Sales]) - SUM([Target])
   

   to show variance.

9. How would you join 3 tables with different granularity?
   Aggregate lower-granularity tables before joining.
   Example:
   Sales at Order level and Budget at Monthly level → aggregate Sales:

   SUM([Sales])
   

   by Month before joining.

10. How would you handle duplicate rows after joins?
    Use FIXED LOD or aggregation to avoid duplicated measures.
    Example:

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

        This ensures Sales is counted once per Order ID.

Bhagavad Gita Wisdom #shorts

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