Choose Between JOIN, BLEND, and RELATIONSHIP in Tableau
Company: Amazon
Role: Data Scientist
Category: Analytics & Experimentation
Difficulty: medium
Interview Round: Technical Screen
##### Scenario
You are preparing a Tableau dashboard for marketing managers who want reliable, fast filtering and correct data relationships across multiple data sources.
##### Question
a) Describe the key differences between a JOIN, a BLEND, and a RELATIONSHIP in Tableau. When would you choose each? b) Tableau provides six types of filters (extract, data source, context, dimension, measure, table calculation). Explain the order of operations and give a practical example where choosing the wrong level causes incorrect results. c) A stakeholder insists on using a pie chart to show 12 product categories. Recommend a better visualization choice and justify it.
##### Hints
Cover performance, granularity, level-of-detail implications, and principles of effective visual encoding.
Quick Answer: This question evaluates proficiency in Tableau data modeling, filter order of operations, level-of-detail implications, and visual encoding for dashboard design, focusing on JOINs, blends, relationships, filter types, and chart selection.
