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