Tableau advanced features unlock sophisticated analytics. Master sets, groups, hierarchies, custom sorting, and actions for enterprise-grade dashboards.
Sets: Dynamic Segmentation
Sets: Conditional Groups: Set: subset of dimension members matching condition. Static sets: manually select members. Dynamic sets: condition-based (Top 10 products by sales). Combined sets: union, intersect, exclude. Use: highlight top performers, segment analysis, exclude outliers. Sets create binary field (in set, out of set).
Creating Sets: Right-click dimension → Create Set. Manual: select members. Condition: IF [Sales] > 10000 THEN [Product]. Top/Bottom: RANK([Sales]) <= 10. Set shown in Marks (blue pill). Use in viz: color in/out of set differently, filter to set members, reference line "average in set".
Groups: Combining Members: Group: combine dimension members into larger group. Create: right-click dimension → Group. Combine multiple: Ctrl+Click → Group. Rename: East, West, Central, South. Groups create new dimension values. Use: regional grouping, product category rollup, age bucketing. Hierarchies: organize groups into levels (Region > State > City).
Hierarchies: Drill Paths: Parent-child relationships: Region (parent) > State > City > Store. Create: drag field onto hierarchy or create manually. Drill down: double-click mark → next level. Drill up: click up arrow. Levels collapse detail. Predefined hierarchies: date (Year > Quarter > Month > Day). Custom hierarchies: combine unrelated fields (Region > Product Category).
5 Complete Solved Interview Problems
Question 1: Create Dynamic Top-N Analysis
Show top 10 products by sales, exclude if profit < 0. Use set + filter. Results update with data?
Condition: RANK(SUM([Sales])) <= 10 AND SUM([Profit]) > 0
Worksheet: drag Product to Rows, Sales to Values
Drag Top10Products to filter. Filter: Only relevant members
Result: visualizes top 10 profitable products, updates as data changes
Google – Analytics Manager
Question 2: Build Multi-Level Hierarchy
Geographic hierarchy: Region > State > City > Store. Enable drill-down. Show totals per level?
Worksheet: Region (rows), Sales (values)
Double-click region → drill to State. Each level shows subtotal.
Drill up: click up arrow. Maintain hierarchy structure.
Visualization: bar chart, group bar per level, show total at region level
Meta – Senior BI Engineer
Question 3: Custom Month Sorting
Sort months Jan-Dec (not alphabetical). Maintain across all worksheets?
Specify order: Jan, Feb, Mar, …, Dec
Approach 2 (Calculated field):
MonthOrder: IF [Month] = “January” THEN 1 ELSEIF [Month] = “February” THEN 2 … END
Sort by MonthOrder (ascending)
Result: all visualizations maintain month order
Amazon – Analytics Engineer
Question 4: Complex Dashboard Actions
Click region → filter state list, update sales chart, open URL to region profile. Chain 3 actions?
Action 2 (Filter): Click region > Filter sales chart by region (filter action)
Action 3 (URL): Click region > Open URL:
https://internal.com/region?name=<[Region]>
Dashboard: Execute actions in order (1→2→3). Test: click region → all 3 actions fire
Apple – Analytics Engineer
Question 5: Subset Comparison (In Set vs Out of Set)
Compare “top 5 customers” vs “all others”. Visualize revenue, profit difference?
Condition: RANK(SUM([Sales])) <= 5 Worksheet: Customer dimension, drag Top5Customers to color shelf Measures: Revenue, Profit, Count Result: stacked bar chart. Blue = top 5 (in set), gray = others (out of set) Comparison: visual difference in size, revenue, profit contribution
Microsoft – Analytics Engineer
15 Practice Questions
Question 6: Modify set membership dynamically: exclude members based on condition. What set operations (union, intersect, exclude) achieve different results?
Question 7: Combine two sets using union (A OR B), intersect (A AND B), exclude (A NOT B). Use case for each operation?
Question 8: Refine existing group: split “Other” category into sub-groups manually. How to build hierarchy from groups?
Question 9: Create date hierarchy: Year > Quarter > Month > Day. What happens when drilling to each level? Auto-drill depth control?
Question 10: Implement custom sort for revenue ranking (largest to smallest). How sort direction impact visualization reading?
Question 11: Create parameter action: click data point → set “selected product” parameter dynamically. Use for filtering?
Question 12: Pass special characters safely in URL action. URL encoding needed for spaces, special chars? Tableau encoding syntax?
Question 13: Filter action on unrelated dimensions cause unexpected behavior. Why filtering Region affects Product count? Shared measure impact?
Question 14: Highlight action with set: color marks in set vs out of set. Visual encoding (color, size) differences?
Question 15: Go-to-sheet action navigation between dashboards preserving filter context. How parameters flow to destination sheet?
Question 16: Remove/undo action: deselecting mark clears filter. When does dashboard remember selection vs clear?
Question 17: Set intersection: find customers in top 10 AND also in high-profit segment. Syntax using set operations?
Question 18: Group exclude: remove “Other” category from visualization. Simplify chart by hiding specific group members?
Question 19: Hierarchy collapse: hide lower detail levels by default. Show/hide levels on demand. UX design for navigation?
Question 20: Action chain execution: click → multiple filters cascade in sequence. How to debug if one action fails silently?
Master Tableau Advanced Features
Get our comprehensive Data Analytics: Ace All The Interview Concepts course.