One of the biggest areas of technical advancement in Tableau Desktop over the last several years is the ability to model complex data sources. Relationships first debuted in 2020 but were only usable for simple data models because you could only use a single fact table as a base table. In 2024, Tableau updated the Relationship builder to allow for multiple-fact tables and shared dimension tables. This ability is invaluable in complex analyses that leverage numerous tables. As you may know from previous videos, Relationships allow Tableau to build data models more efficiently by not unnecessarily duplicating related data like joins. Not only do relationships keep data models smaller, but they often allow you to use less memory-intensive aggregations (COUNT vs COUNTD) and reduce the need to use FIXED LOD expressions to reduce duplication. If you want to learn how to build multi-fact relationships and learn best practices to follow when doing so, check out this video! Connect with us: •Upcoming Tableau Classes: •Book an Office Hour with Eric: •Subscribe to the OneNumber Newsletter: •Follow Eric on LinkedIn: •Tableau Passport Program: Resources: •Tableau Public Workbook: •Downloadable Data Source (Sign in to DataWorld to download): •Why Tableau Created Relationships: •Tableau Relationships vs. Joins Webinar: •Display Missing Data After Creating Tableau Relationship: •Kirk Munroe LinkedIn (Tableau Relationship Expert): •Tableau's Article on Multi-Fact Relationships: