Live versus Extract

Live data: Directly accessing the data from the original dataset

• Usually used this by analysts because the analysis needs to be updated

Extract: creating a local copy of the dataset and performing the operation on the local copy

• when is this used?? When we don’t want to disturb the original data and perform critical operations.

Relationship vs Joints

We need matching fields between logical tables

Keeping each table separate in important

Require join clause & join type selection

Keep your tables separate

<aside> 💡 Newer versions of Tableau automatically decides the type of join that needs to be performed on two tables

</aside>

Join Clause: Used when we need to join multiple tables without a user-defined join condition