Joins in Tableau: Choose the correct join type

👉🏻 Download Our Free Data Science Career Guide: https://bit.ly/2POLaN8
👉🏻 Sign up for Our Complete Data Science Training with 57% OFF: https://bit.ly/3iKD0lv

In order to be able to use the information of two tables at the same time, we’ll have to use joins in Tableau. What we want to obtain is a unique table containing information about all transactions for all audiobooks, and the respective reviews left by clients whenever they chose to do so. The Transaction ID column is the perfect link between the two files, as it is available in both and could serve as a common field based on which we could link the two tables together.
So, one of the main aspects we’ll explore in this lesson is how to create a connection between two tables in Tableau.
Please remember that we will distinguish the terms ‘data connection’ and ‘table connection’. ‘Table connection’ is performed by functionalities like joining or blending. It refers to combining data from two or more data sources.
‘Data connection’, instead, represents a single data source connection between Tableau and a data source, such as an Excel Workbook or an SQL database.
Technically speaking, when creating a join, Tableau sends a query to the database. The join is implemented on the relevant tables at the database level, and the output of the operation is brought back to Tableau, where it is ready to be used for analysis.
An inner join means that the two tables we’ve added have a field in common, and we can combine them using that field. Let me hover my mouse over the symbol. Tableau indicates that it has created an inner join using the parameter “audiobook name”. We don’t want that. We want to link the two tables according to the Transaction ID parameter, as our analysis will be focused on user sales and reviews.

► Consider hitting the SUBSCRIBE button if you LIKE the content: https://www.youtube.com/c/365DataScience?sub_confirmation=1

► VISIT our website: https://bit.ly/365ds

🤝 Connect with us LinkedIn: https://www.linkedin.com/company/365datascience/

365 Data Science is an online educational career website that offers the incredible opportunity to find your way into the data science world no matter your previous knowledge and experience. We have prepared numerous courses that suit the needs of aspiring BI analysts, Data analysts and Data scientists.

We at 365 Data Science are committed educators who believe that curiosity should not be hindered by inability to access good learning resources. This is why we focus all our efforts on creating high-quality educational content which anyone can access online.

Check out our Data Science Career guides: https://www.youtube.com/playlist?list=PLaFfQroTgZnyQFq4nUfb-w2vEopN3ULMb

#tableau #statistics #datascience

Видео Joins in Tableau: Choose the correct join type канала 365 Data Science