O'Reilly logo

Tableau Cookbook – Recipes for Data Visualization by Shweta Sankhe-Savale

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding Multiple Table Join within a single database

Often there will be instances where the data is stored in multiples tables of a database and for the sake of analysis, we are required to fetch the data from these tables.

For example, there may be a table called Employee Master which contains the employee details such as employee ID, their first name, last name, date of birth and so on. The salary/compensation details could be stored in another table and the employment history could be stored in a separate table as well.

When conducting an analysis, we would want to consider all the information related to an employee and then proceed with our analysis. Thus, in this case, we are required to fetch the data from all the three tables, and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required