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 

Top Tableau Scenario-Based Interview Questions Set-1 (1- 20)

 

1. How would you show Top 10 customers by sales in each region?
   Use Region + Customer and apply Top N filter on Customer by Sales.
2. How would you display sales for the latest month only?
   Use MAX(Date) filter or latest date LOD.
3. How would you highlight customers whose sales are above average?
   Use conditional color with SUM(Sales) > WINDOW_AVG(SUM(Sales)).
4. How would you compare current year sales vs previous year sales?
   Use dual axis or side-by-side bars with CY and PY calculations.
5. How would you show YoY growth % by category?
   Use (SUM([CY Sales]) - SUM([PY Sales])) / SUM([PY Sales]).
6. How would you identify the top-performing product in each sub-category?
   Use RANK(SUM(Sales)) = 1 within each sub-category.
7. How would you display the latest available record for each customer?
   Use FIXED LOD with MAX(Date) per customer.
8. How would you show running total sales month over month?
   Apply Running Total table calculation on Sales.
9. How would you show moving average for last 3 months?
   Use Moving Average table calculation with 3-period window.
10. How would you compare sales vs target in one chart?
    Use dual axis with Sales bars and Target line.
11. How would you show profit ratio by region?
    Use SUM(Profit)/SUM(Sales).
12. How would you identify loss-making products?
    Filter products where SUM(Profit) < 0.
13. How would you show sales contribution % by category?
    Use Percent of Total table calculation on Sales.
14. How would you display only customers with repeat purchases?
    Filter customers with COUNT(Order ID) > 1.
15. How would you find customers who purchased in both 2024 and 2025?
    Use set or LOD to identify customers present in both years.
16. How would you show products with no sales in the last 6 months?
    Filter products where MAX(Order Date) < TODAY()-180.
17. How would you show dynamic Top N products?
    Use parameter for Top N and apply it in filter.
18. How would you switch between Sales, Profit, and Quantity?
    Use parameter + calculated field to swap measures.
19. How would you allow users to toggle chart types?
    Use parameter to switch between chart sheets.
20. How would you create a dynamic title?
    Use dynamic title with parameter/filter values.

Bhagavad Gita Wisdom #shorts

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