Combine multiple tables for analysis with relationships
Utilizing the tableau that is recent release, weвЂ™ve introduced some brand brand new data modeling capabilities, with relationships. Relationships are a straightforward, versatile option to combine information from numerous tables for analysis. You define relationships predicated on matching fields, in order that during analysis, Tableau brings into the right information through the right tables during the aggregationвЂ”handling that is right of information for your needs. a repository with relationships functions like a custom databases for almost any viz, you just build it as soon as.
Relationships will allow you to in three key means:
- Less upfront information planning: With relationships, Tableau automatically combines only the appropriate tables during the time of analysis, preserving the level that is right of. No more pre-aggregation in custom SQL or database views!
- More usage instances per repository: TableauвЂ™s brand new multi-table data that are logical means you’ll protect all of the detail records for numerous fact tables in one single databases. Bid farewell to data that are different for various situations; relationships are capable of more technical data models in a single destination.
- Better rely upon outcomes: 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 kept at various degrees of information.
The 8 Rs of relationship semantics
Tableau requires guidelines to followвЂ”semanticsвЂ”to figure out how to query information. Relationships have actually 2 kinds of semantic behavior:
- Smart aggregations: Measures automatically aggregate towards the degree of information of these source that is pre-join dining dining table. (mehr …)