In Which scenario go for joins and when should use relationships in Tableau any sample data with explanation it helps me in understanding....

A simple search on the Internet comes up with many examples, in addition to what's already been provided to you by other experts on the Forums:

https://coffeebreakdata.com/tableau-relationships-blends-joins/

https://learningtableau.com/combining-tables-in-tableau/

https://www.thedataschool.co.uk/penny-richmond/tableau-desktop-relationships-vs-joins/

https://theinformationlab.nl/en/2023/08/04/understanding-relationships-joins-unions-and-blends-in-tableau-combining-data-sources/

https://interworks.com/blog/2022/08/04/tableau-relationships-basics-the-ground-rules/

Comparing Tableau's New Relationships to Blends and Joins

Tableau Data Relationships vs Joins - Vizual Intelligence Consulting

Tableau Relationships vs. Joins - Webinar Accompanying Workbook

https://medium.com/shippeo-tech-blog/tableau-relationships-vs-joins-1-2-b78dd9cc373d

https://medium.com/shippeo-tech-blog/tableau-relationships-vs-joins-2-2-cf1d48c8057c

Tableau Relationships: Series Introduction - InterWorks

Tableau Relationships: Tips and Tricks - InterWorks

Tableau Blend vs Join vs Relationship (Data Model) Explained - Part 1 ... You Tube Video

Tableau Blend vs Join vs Relationship (Data Model) Explained - Part 2 | sqlbelle You Tube Video

3 Creative Uses for Relationships/Joins in Tableau

Tableau Relationships vs. Joins - Webinar Recording - OneNumber

Relationships vs Joins - Coding Ninjas

Tableau's relationships are pretty cool | by Tomas Dvorak | Towards ...

Types of Joins in Tableau: Key Features - The Knowledge Academy

Relationships, Joins and Unions in Tableau 2020.2 - YouTube

What join type are Tableau Relationships most similar to? - OneNumber

Tables Relations: One-to-One, One-to-Many, Many-to-Many

Getting started with the new Relationships feature in Tableau

Tableau Relationships: Performance - Speed and Cardinality

You can sign up for a free account and gain access to a 3-4 hour free course on Trailhead (Salesforce Training site) for the following course: Getting Started in Tableau Desktop: https://trailhead.salesforce.com/content/learn/trails/get-started-with-data-visualization-in-tableau-desktop and Tableau Desktop resources for Newbies Tableau Desktop resources for Newbies

If you want to work with sample data, you can join any one of the community project workshops here. Or any of the User Groups here.

Books. A simple internet search turned up the following:

Learning Tableau 2022: Create effective data visualizations, build ...

Mastering Tableau 2021: Implement advanced business intelligence ...

Mastering Tableau 2021 - Third Edition [Book] - O'Reilly Media

The 8 Best Tableau Books Based on Real User Reviews - Solutions Review

10 lists of books for people to learn about data | Tableau

All of those should answer your question.

Best, Don

(Please, don't forget to click Select as Best or Upvote !)