Combine tables that are multiple analysis with relationships
Utilizing the tableau that is recent release, weвЂ™ve introduced some brand brand new information modeling capabilities, with relationships. Relationships are a simple, versatile option to combine information from numerous tables for analysis. You define relationships predicated on matching fields, to make certain that during analysis, Tableau brings into the right data through the right tables during the right aggregationвЂ”handling level of information for you personally. a repository with relationships functions such as a customized databases for each and every viz, however you just build it when.
Relationships will allow you to in three key means:
- Less upfront data planning: With relationships, Tableau automatically combines only the appropriate tables at the time of analysis, preserving the level that is right of. No more pre-aggregation in custom database or SQL views!
- More usage instances per databases: TableauвЂ™s brand new multi-table data that are logical means you’ll protect all of the detail documents for numerous reality tables in one single repository. Bid farewell to data that are different for various situations; relationships are designed for more technical information models within one spot.
- Better rely upon results: While joins can filter information, relationships constantly protect all measures. Now values that are important cash can’t ever get lacking. And unlike joins, relationships wonвЂ™t increase your trouble by duplicating information saved at various degrees of information.