Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
All Courses
  • Free Training Courses
  • AI for Your Role
  • AI & Machine Learning
  • Cloud Tech
  • Data Science
  • DevOps
  • Dashboarding/BI
  • Database
  • WebDevelopment
  • Programming & Coding
  • MS Office & Workplace Productivity
  • QA & Test Automation
  • Professional & Career Development
  • Cyber Security

Courses

  • Computer Fundamentals for Beginners
  • MS Word for Beginners
  • Microsoft Excel for Beginners
  • Microsoft Azure for Beginners
  • AWS Cloud for Beginners
  • Oracle SQL Fundamentals
  • Tableau Fundamentals
  • Power BI Fundamentals
Explore All Programs

Courses

  • AI Essentials
  • AI for Administrative Professionals New Launch
  • AI for Managers & Team Leads
  • AI for Data Analytics & Power BI
  • AI for Software Developers
  • AI for Database & SQL Professionals
  • AI for Project Managers
  • AI for Marketing Professionals
  • AI for Sales Professionals
  • AI for HR Professionals
  • AI for Finance Professionals
  • AI for Customer Support Professionals
  • AI for QA & Test Engineers
  • AI for IT Support & System Admins
  • AI for Cybersecurity Analysts
  • AI for Job Seekers
Explore All Programs

Courses

  • Learn Claude Basics New Launch
  • Learn Claude Advanced New Launch
  • Applied Artificial Intelligence (AI) New Launch
  • AI for Workplace Productivity
  • Azure Fundamentals with AI
  • Advanced Microsoft Azure with AI
  • AI Implications for Business Strategy
  • Mastering ChatGPT & Generative AI Tools
  • Prompt Engineering
  • Agentic AI Solutions
  • AI Product Management
  • AI for Quality Control
Explore All Programs

Courses

  • AZ-900 Azure Fundamentals
  • DP-900 Azure Data Fundamentals
  • DP-100 Data Science on Azure
  • AWS Essentials
  • AWS Cloud Practitioner
  • AWS Solutions Architect
Explore All Programs

Courses

  • DP-100 Data Science on Azure
Explore All Programs

Courses

  • DevOps Essentials
  • DevOps with AWS
  • DevOps with Azure
Explore All Programs

Courses

  • Business Analytics: From Data to Insights New Launch
  • Power BI Advanced
  • Data Analytics with Excel
  • Tableau Beginner
  • Tableau Data Consumer
  • Alteryx & Tableau
  • Tableau Advanced
  • Tableau Certification prep
  • Power BI Beginner
  • Cognos Analytics
Explore All Programs

Courses

  • SQL Server for Beginners
  • SQL for Analysts
  • SQL Server Advanced
  • SQL Server T-SQL Programming
  • SSIS
  • Oracle SQL for Beginners
  • Oracle PL/SQL
  • Oracle SQL Advanced
  • Big Data with Hadoop: HDFS, MapReduce & Ecosystem Tools
  • MS Access
Explore All Programs

Courses

  • Angular Frontend Development
  • Spring 5 Framework
  • Full Stack Web Development
Explore All Programs

Courses

  • Learn Python
  • Python PCEP
  • Python PCAP
  • JavaScript & jQuery
  • Java Certification
  • Python for Data Science
  • Machine Learning with Python
Explore All Programs

Courses

  • Analyzing Data with Excel New Launch
  • Workplace Digital Skills
  • Excel Beginners to Advanced Trending Now
  • Excel for Finance
  • Excel for HR
  • Workplace Computer Skills
Explore All Programs

Courses

  • Selenium QA Automation (Java)
  • Selenium QA Automation (Python)
  • API Testing
  • QA Automation with Python (Advanced)
Explore All Programs

Courses

  • Scrum Master Certification
  • Lean Six Sigma Green Belt Certification
  • Business Analyst
Explore All Programs

Courses

  • Cyber Security Foundations for Beginners
  • Computer Networking for Cybersecurity
  • Windows & Linux Security Administration
  • Ethical Hacking & Penetration Testing
  • Artificial Intelligence (AI) in Cybersecurity
Explore All Programs
  • About Us
    • OCA Skill Sprint Method
    • Meet the Founder
  • Blogs
    • Career Building
    • AI / Machine Learning
    • MS Excel
    • Programming Essentials
    • Database
    • Cloud Computing
    • Tableau
    • Power BI
    • Web Development
    • Tips for Success
    • Qlik
    • Soft Skills
    • Technology
    • Business Intelligence Analyst
    • Message from the CEO
    • DATA ANALYST
  • TechCred
  • Find Your Training
  • Contact Us
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH

 

  • info@ohiocomputeracademy.com
  • +1 866-648-7284
  • Home
  • About Us
  • Blogs
    • Career Building
    • AI / Machine Learning
    • MS Excel
    • Programming Essentials
    • Database
    • Cloud Computing
    • Tableau
    • Power BI
    • Web Development
    • Tips for Success
    • Qlik
    • Soft Skills
    • Technology
    • Business Intelligence Analyst
    • Message from the CEO
    • DATA ANALYST
  • TechCred
  • Find Your Training
  • Contact Us
Find With Us
  • Home
  • Blogs
  • Tableau
  • Difference between Tableau relationships and Joins

Difference between Tableau relationships and Joins

In my previous blog How to create relationships in Tableau, we learned about relationships. In this blog, we will study the difference between Tableau Relationships and joins. We will also see if joins are still available in Tableau.

To explain this concept, I will use the following three tables,

Tableau_Relationship_All3TablesMain

Sample Emp, Dept, and Salary tables used to demonstrate relationships and joins in Tableau

*In Tableau, Joins work similar to database joins.

Difference between Tableau Relationships and Joins

  1. In Tableau, relationships are called the Logical layer and Joins are called the physical layer.

  2. As we understood in the previous blog, Relationships are not Joins. Relationships keep the tables separate and do not merge them into a single table.

  3. If you connect to MS-Excel source of these three tables, a relationship is created between Emp and Dept based on the common field DeptNo and a relationship is created between Emp and Salary based on JobID, which is shown below. (please comment below if you need these tables for your practice) 

Emp data is displayed

Tableau_Relationship_3Tables

Relationships between Emp, Dept, and Salary, with the Emp table selected for data preview.

You will notice that the rows of Emp table only will be displayed in the preview window, since Emp table is selected. The rows from other two tables will NOT be displayed. This occurs because relationships keep the tables separate.

An analysis of data from these tables can be easily performed. For e.g. I can determine the Employees working in different departments and their respective salaries based on the job titles.

Tableau_RelationshipView1

Employee, department, and salary data displayed together using Tableau relationships.

In the earlier versions of Tableau, in the absence of a relationships, this task would have required data blending with multiple sources and would therefore be slow. Using relationships, we can do this in one data source. Also, data blending is limited to a worksheet, but relationships are available for the entire workbook. Relationships will increase the performance of your dashboard.

Where are Tableau Joins?

Joins are still available and can be created as required.

  1. A Join between two tables merges the tables and creates a single table.  

  2. Joins between two tables are created based on the common field names. To create a join, you need to double click on the table in the logical/relationship layer and add another table next to it.

  3. To create a join between Emp and Dept tables, in the relationship, double click on the Emp table and add dept to it. You can choose the type of join you need.

Tableau_RelationshipJoin1

Inner join between Emp and Dept tables using Deptno. The department table appears as Dept1 in this example.

You can close this Join/physical layer by clicking on the cross on the right corner. This will navigate you back to the relationship layer. Notice the emp table will look different as it now contains a join.

Tableau_RelationshipJoin1

The Emp logical table contains a physical join and is related to the Dept and Salary tables.

Compared to Relationships, Joins have some disadvantages

  1. Joins are static and once made, will affect the data in the entire workbook.

  2. Depending on the join type you use, you may lose unmatched data. For example, inner join shows only matching rows between the tables. Although emp table has 7 rows, you will see only 5 rows when inner join is used.

  3. If you use Left join, with Emp table on the left, you will get all the rows from the Emp table but dept table will show only the matching rows and therefore Deptno 800 will not be displayed.


    Tableau_Relation_LeftJoin

    Left Join retains all employees from the Emp table, including Sam and Raj, who have no matching department records.

  4. If you use a Right join, with Dept table on the right, you will get all the rows from the dept table including DeptNo 800. The employees in Emp table that do not belong to any department, will not be displayed.

Tableau_Relation_RightJoin

Right Join retains all departments, including Security and Training, which have no matching employee records.

5. This problem can be resolved by using outer join, but here again, if your tables are huge, this may result in slow performance. Due to this reason, Outer joins are not recommended.

All these problems will be resolved by using Relationships. You can still use joins but use them when absolutely necessary.

Tableau offers diverse techniques for merging data, such as, relationships, joins, unions, and data blending. Compare each method and learn which method to use in specific scenarios.

Tableau provides various techniques to visualize data, learn how to create a stacked bar chart with percent of total sales and totals on the top.

For more such tips and to become an expert in Tableau checkout my new Tableau book – Dashboarding with Tableau

Learn More

Want to Learn Tableau with Hands-On Training?

Understanding relationships and joins is an important step in building accurate Tableau dashboards.

At Ohio Computer Academy, we offer instructor-led Tableau training with practical exercises covering data connections, relationships, joins, visualizations, and interactive dashboards.

Whether you're a beginner or looking to strengthen your Tableau skills, our training can help you gain practical, job-ready knowledge.

Explore Tableau Training

Like
Chandraish Sinha

Chandraish Sinha is the Founder and President of Ohio Computer Academy, a leading institution committed to delivering high-quality IT education. With a passion for teaching and a belief in his company’s mission—Inspire, Educate & Evolve—Chandraish brings over 25 years of experience in the Information Technology industry.

Explore more of his work on his Amazon Author Profile.

0 Comments

Add Your Comment

Post a Comment

Required fields are marked *

✅ Thanks for adding your comment! It will appear after moderation.

0 Comments

Related Blogs
View All Blogs
Why learning Tableau is important
Read More
Tableau Components
Read More
Types of Files in Tableau
Read More
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH

Registered with the Ohio State Board of Career Colleges and Schools — School Registration No. 2395

About Us
  • Contact Us
  • Our Story
  • Training Gallery
  • Reviews
  • Books
  • Greater Columbus Training Center
Trainings/Services
  • Course Categories
  • Learning Paths
  • Frequently Asked Questions
  • AI Advantage
Contact Us
  • Phone:+1 866-648-7284
  • E-mail: info@ohiocomputeracademy.com
  • Address:

    Dublin, Ohio
    5900 Sawmill Road, Suite # 150, Dublin, OHIO 43017 USA

Thank you
Failed
Free Training Courses
  • Computer Fundamentals for Beginners
  • MS Word for Beginners
  • Microsoft Excel for Beginners
AI Courses
  • Claude Basics
  • Claude Advanced
  • AI for Workplace Productivity
  • Prompt Engineering
  • Agentic AI Solutions
  • AI for Quality Control
Cloud Tech
  • DP-900 Azure Data Fundamentals
  • DP-100 Data Science on Azure
  • AWS Technical Essentials
  • AWS Cloud Practitioner
  • AWS Solutions Architect
DevOps
  • DevOps Essentials
  • DevOps with AWS
  • DevOps with Azure
Dashboarding/BI
  • Tableau Beginner
  • Power BI Beginner
  • Data Analytics with Excel
Database
  • Oracle SQL for Beginners
  • SQL for Analysts
  • SQL Server for Beginners
MS Office & Workplace Productivity
  • Workplace Digital Skills
  • Excel for Finance
  • Excel for HR
  • Excel Beginners to Advanced
  • Workplace Computer Skills
Learning Hub
  • Begin Your IT Career
  • Generative AI & Workplace Productivity Foundations
  • Claude AI Learning Path
  • Data Visualization Foundations
  • Data Analytics Career Path
  • AI for Business & Data Applications
  • Programming Foundations & Development Path

© 2026 Ohio Computer Academy. All rights reserved.

  • Privacy
  • Terms & Conditions