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

Top Tableau Interview Questions Set-3 (41-65))

 

41. What is publishing in Tableau?

Uploading dashboards/data sources to Tableau Server/Online.

42. What is versioning in Tableau?

Feature to maintain multiple versions of a workbook or data source.

43. Explain the difference between TDE and Hyper.

Hyper is faster, supports bigger datasets, replaces TDE.

44. Can we schedule extract refresh?

Yes, using Tableau Server tasks.

45. What are blended axes?

Multiple measures sharing the same axis.

46. What is the difference between heatmap & tree map?

Heatmap: color intensity.
Treemap: size + color encoding.

47. What is pagination in Tableau?

Used when displaying large tables; adds page controls.

48. Can we write SQL in Tableau?

Yes, using Custom SQL.

49. What is a Crosstab?

Table view format.

50. What is the most complex chart you created? (Interview favorite)

Examples:

• Sankey
• Radial bar chart
• Waterfall
• Gantt with forecasting
• Multi-layer maps

(You can prepare one example to explain.) 

Bhagavad Gita Wisdom #shorts

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