Why Tableau Created Relationships

Описание: 🔔 Book a FREE 15-min Tableau call here: https://forms.gle/DfW6TJkMjsmBytig8

Connect with us:
•Upcoming Tableau Classes: https://www.eventbrite.com/o/onenumbe...
•Book an Office Hour with Eric: https://www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Eric on LinkedIn:   / eric-parker-37513249  

Description:
In 2020, Tableau unveiled a new way to combine multiple tables of data in Tableau Desktop: a Relationship. Billed as "smart joins", relationships provide the capability to merge multiple tables of data horizontally on shared dimensions (like a join). However, they don't duplicate data when the tables being combined have different levels of granularity.

So, are they better than joins? Not always! Relationships can reduce data duplication and improve performance, but a data set that is generated from a relationship might present blind spots if the data isn't perfectly clean.

To learn more about relationships and see a scenario where they provide a lot of value, check out this video!

Resources:
•Tableau Public Workbook: https://public.tableau.com/app/profil...
•NYC Motor Vehicle Accident Data: https://catalog.data.gov/dataset/moto...
•Tableau Relationships vs. Joins Recording: https://onenumber.biz/blog-1/2021/12/...

Chapters:
0:00 Intro & Scenario
1:50 Fact and Dimension Tables
3:28 Join Walkthrough
10:13 Relationship Walkthrough