Tableau blending

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  

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.