BitWithBite
Tableau Worksheet
📊 Data Blending & Relationships
SCORE___ / 20
NameClassDate
After this worksheet you can
Relationships vs joins vs blendsPrimary/secondary sourcesLinking fieldsChoose the right combine📚 Quick Recap
Welcome to Phase 3 — Advanced Tableau. Real-world analytics rarely involve a single clean table. You'll work with data from multiple systems: sales from a SQL database, targets from Excel, web analytics from Google Sheets, customer data from a CRM. This lesson teaches you Tableau's three approaches to combining multi-source data — and critically, when to use each one.
🧠 Section A · Concept Check ● BEGINNER 4 × 1 = 4
1Modern flexible combining (2020+) uses:
2Blending combines:
3The orange link icon marks the:
4Rows stacked from same-structure tables use:
🧮 Section B · Problem Solving ● INTERMEDIATE 2 + 3×3 = 11
5In a blend, the first source used is .
6Relationships defer joins until time.
7Sales in SQL + targets in Excel - combine how?
8Relationship vs join advantage?
9When is a union right?
🚀 Section C · Challenge ● CHALLENGE 5
10Symptom of a bad join key?
💭 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 primary 6 query/viz 7 = Blend (or relationship) linked on Region/Month 8 = No premature row duplication; correct aggregation per viz 9 = Same-schema tables split by month/region - stack rows | 10 = Duplicated/multiplied measure values