BitWithBite
Tableau Worksheet
📊 Groups, Sets & Hierarchies
SCORE___ / 20
NameClassDate
After this worksheet you can
Group members manuallyDynamic setsBuild hierarchiesIn/out set analysis📚 Quick Recap
Groups, Sets, and Hierarchies are three of Tableau's most powerful organizational features — and most analysts under-use all three. Groups let you bundle dimension members into custom categories. Sets let you create dynamic in/out segments that respond to user interaction. Hierarchies let you drill from continent → country → city with a single click. Together, they unlock a whole new level of analytical flexibility.
🧠 Section A · Concept Check ● BEGINNER 4 × 1 = 4
1Combining NY+NJ+CT into East is a:
2A dynamic top-customers collection is a:
3Country - State - City drill-down is a:
4Sets divide data into:
🧮 Section B · Problem Solving ● INTERMEDIATE 2 + 3×3 = 11
5Groups are (manually defined, static).
6Sets update when data changes (condition-based).
7Group vs set in one line?
8Build Category - Sub-Category - Product hierarchy.
9Set for customers with sales above 10k?
🚀 Section C · Challenge ● CHALLENGE 5
10Use of IN/OUT on colour?
💭 Reflection — the most useful thing I learned:
A ___/4 B ___/11 C ___/5 Total ___/20
Teacher's Signature
Parent's Signature
✂ answer key — fold or cut before handing out
1-A 2-A 3-A 4-A | 5 static 6 dynamically 7 = Group = manual buckets; set = rule-based in/out membership 8 = Drag Sub-Category onto Category, then Product onto it 9 = Create Set - Condition - SUM(Sales) > 10000 | 10 = Compare top-set members vs the rest visually