BitWithBite
Tableau Worksheet
📊 Data Types & Preparation
SCORE___ / 20
NameClassDate
After this worksheet you can
Dimensions vs measuresData types in TableauRename/split/pivot fieldsHandle nulls📚 Quick Recap
Real-world data is rarely in one perfect table. It's spread across multiple tables with different structures, data types, and formats. This lesson teaches you how to combine tables using joins, stack data with unions, understand Tableau's modern Relationships model, and reshape messy data with pivoting — all before a single visualization is built.
🧠 Section A · Concept Check ● BEGINNER 4 × 1 = 4
1Categorical fields are:
2Numeric aggregatable fields are:
3Sales defaults to aggregation:
4A field with Abc icon is:
🧮 Section B · Problem Solving ● INTERMEDIATE 2 + 3×3 = 11
5Dates get drill-down: year, quarter, month, .
6 turn one column into several (e.g. split names).
7Dimension vs measure for: City, Profit, Order Date?
8Why does Tableau aggregate measures by default?
9Fix '1,234' loaded as string?
🚀 Section C · Challenge ● CHALLENGE 5
10Two ways to treat nulls?
💭 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 day 6 Splits 7 = Dimension, measure, dimension (date hierarchy) 8 = Views summarise many rows into marks 9 = Change data type to number (remove separators) | 10 = Filter them out or replace/indicate at source