BigData / Tableau Interview Questions
What are the types of joins supported in Tableau?
When connecting multiple tables from the same data source, Tableau lets you join them using standard relational join types, configured visually in the data source pane.
| Inner Join | Left Join | Right Join | Full Outer Join |
| Only matching rows from both tables. | All rows from the left table, matched rows from the right. | All rows from the right table, matched rows from the left. | All rows from both tables, matched where possible. |
Orders (left table) LEFT JOIN Customers (right table) ON Orders.customer_id = Customers.customer_id -- keeps every order, even ones missing a matching customer record
Tableau shows a visual Venn-diagram-style icon for each join type in the data source pane, making it easy to pick the right one without writing SQL by hand. Choosing the wrong join type is a common source of row duplication or missing data — for example, an inner join silently drops orders that don't have a matching customer, which can understate totals if not caught.
Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!
Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.
Invest now!!! Get Free equity stock (US, UK only)!
Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.
The Robinhood app makes it easy to trade stocks, crypto and more.
Webull! Receive free stock by signing up using the link: Webull signup.
More Related questions...
