My objective was to learn 4 important use cases of Tableau’s advanced data visualization.
- Analyzing data using statistical tools
- Creating and pivoting crosstabs
- Mapping geographic data
- Creating custom calculations and fields
This activity also helped me clarify the difference between relationships and joins. There are rules applies only to the use of relationships used such as;
- When relating tables, the fields that define the relationships must have the same data type. Changing the data type in the Data Source page does not change this requirement. Tableau will still use the data type in the underlying database for queries.
- Relationships can only be equal to (inequality relationships aren’t currently supported). If you need to use an inequality join, double-click a logical table to open the physical layer and join or union physical tables.
- You can’t define relationships between published data sources.
- Circular relationships aren’t supported in the data model.
- You can’t define relationships based on calculated fields or geographic fields. If you need to join on a calculated field, double-click a logical table to open the physical layer and join or union physical tables.