The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Tableau blending

Tableau blending

0
Votes
2
Answer

Joining and blending which one is the best and more professional

2 Answers

365 Team
0
Votes

Hi,
Thanks for reaching out.
Please take a look at the following thread:
https://365datascience.com/question/tableau-join-and-blending-of-data/
Best,
365 team
 

0
Votes

There isn’t a best and most professional. Use whichever is most appropriate for your data. This is a very complicated area unfortunately. I’ve been using Tableau for 10 years and still have challenges with blending.
I guess one key difference, you should never blend at a granular level (if can be avoided) as it can cause huge performance issues and bring down the Tableau server. You blend at as high a level as possible as blending is like joining an aggregate with an aggregate.
This differs to a join, where you would join at the most granular level as possible and you’re joining raw data to raw data.
Joining can cause duplicate records, while this doesn’t happen with blending.
In summary, it’s complicated. Just make sure you check the output very carefully to make sure the numbers are what are expected.

×
Complete Data Science Training
Save 60%