BitWithBite
Tableau Worksheet
📊 Tableau Prep Builder
SCORE___ / 20
NameClassDate
After this worksheet you can
Flow-based data cleaningClean/shape stepsJoins and unions in PrepOutput to hyper/csv📚 Quick Recap
Real-world data is almost never analysis-ready. It arrives from multiple systems in inconsistent formats, with wrong data types, merged columns, duplicate rows, and mismatched naming conventions. Tableau Prep Builder is a dedicated ETL (Extract, Transform, Load) tool that lets you visually build data preparation flows — cleaning, reshaping, and combining data before it reaches Tableau Desktop. Mastering Prep makes you dramatically more self-sufficient as an analyst.
🧠 Section A · Concept Check ● BEGINNER 4 × 1 = 4
1Prep organises work as a:
2Fixing typos/casing happens in a:
3Turning wide to tall data is:
4Prep outputs commonly to:
🧮 Section B · Problem Solving ● INTERMEDIATE 2 + 3×3 = 11
5Each transformation is a in the flow.
6Profile pane shows value for quick auditing.
7Why clean in Prep instead of Desktop calcs?
8Messy city names - Prep fix?
9Combine 12 monthly CSVs?
🚀 Section C · Challenge ● CHALLENGE 5
10What does the profile pane help catch?
💭 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 step 6 distributions 7 = Reusable, visual, auditable pipeline before analysis 8 = Clean step - Group Values by spelling/pronunciation 9 = Wildcard union in the input step | 10 = Outliers, nulls, weird distributions instantly