How to use Joins in Tableau | Tableau Tutorials for Beginners

Рет қаралды 125,018

2 жыл бұрын

Check out my Full Tableau Course Here: www.analystbuilder.com/course...
This is our fourth of 5 tutorials on Tableau. In this series we will learn the UI of tableau as well as how to effectively create visualizations and dashboards.
Excel File: github.com/AlexTheAnalyst/Por...
Favorite Tableau Course:
Tableau A-Z - coursera.pxf.io/MXYqaN
Joins video in SQL: • Intermediate SQL Tutor...
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
Google Data Analyst Certification: coursera.pxf.io/5bBd62
Data Analysis with Python - coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Analysis and Visualization- bit.ly/3hhX4LX
Statistics for Data Science - bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
SUPPORT MY CHANNEL - PATREON/MERCH
Patreon Page - / alextheanalyst
Alex The Analyst Shop - teespring.com/stores/alex-the...
____________________________________________
Websites:
GitHub: github.com/AlexTheAnalyst
Instagram: @Alex_The_Analyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for

Пікірлер: 62

@nadinasoler2675 2 жыл бұрын

Loved the fact that you are using tables with information about the characters from the office. I like you more just for that

@yqhanliving 7 ай бұрын

I have already learned a lot about joins from your sql course and other sql courses, but in this video, the part where you join the demographics and job title tables via employee name is such a clear and clever way of explaining again how the joins work. It consilidated my understanding for joins. Way to go alex!

@sj1795 7 ай бұрын

Great summary of joins! I love the way you explain all of these concepts and functions so clearly. It makes learning wayyyyy more fun. As always, THANK YOU!

@awedaoluwanifemi8024 2 жыл бұрын

I check your page everyday waiting for the next tableau tutorial. Thanks a lot Alex.

@azlyngoh8426 Жыл бұрын

Alex, you explained the joins very clearly. Thank you so much

@tech_guruLG Жыл бұрын

Great vid. At first, I hated everything about joins BUT since I learned them its make Tableau so much easier! Keep the vid coming your amazing!

@AlexTheAnalyst Жыл бұрын

Not too bad once you get a hang of them!

@user-ny6jl3eu9f 2 жыл бұрын

Understandably explained, thank you!

@oohforf6375 2 жыл бұрын

I wake up in the morning to a new tutorial vid! Thank you!

@yasfarfan 2 жыл бұрын

Thank you very much Alex for this useful tutorial

@matthewhayward4204 Жыл бұрын

I watched the whole tutorial. This is much appreciated thank you.

@eimyatthu1168 2 жыл бұрын

Thank a million for sharing. Your tutorial is helpful for me.

@willymwangi3865 Жыл бұрын

I'm sincerely grateful for the video. I have learnt something new (joins) today. God bless you.

@yoni1991 10 ай бұрын

Thank You Alex I am mastering Tableau because of you!

@de_da_oo 2 жыл бұрын

Can you make an in depth video on data granularity and LOD's(ok, two :)? Found these topics of great importance for understanding Tableau and its power

@mehakkamran3929 6 ай бұрын

I was so scared of joins but I have learned joins from your sql video in my semester break , Now joins are on my finger tips .Since my concept are clear , this video was so easy to follow up .

@adelaokina 2 жыл бұрын

Thank you, it helps me a lot.

@kan-vannaofficial3978 Жыл бұрын

Big thanks for your video Alex.

@Official_Muhammad_Bilal 2 жыл бұрын

Great tutorial 🙌🏼

@SohiniRaviMonani 3 ай бұрын

Hello Aled sir, Thank you so much for this tutorial. I learned tableau in a very easy way. I was facing a problem for 2 months and by these 5 parts I got it. Thank you to adding each feature, especially you are elabarating each types like average, sum, count why they using. Good job

@PacoVillasana27 2 жыл бұрын

Just realising that those where The Office employees. Awesome!

@tsegamuzollo1720 4 ай бұрын

Very good video, with a great explanation! thanks!

@uchindamiphiri1381 8 ай бұрын

Thank you for this tutorial, I am really learning a lot. Apart from this tutorial but Mr. Alex you are really good looking which gives some of us hope to keep on learning.............

@socialgenie2020 2 жыл бұрын

Love the reference from "The Office" with character names, haha.

@tusharjainOct97 2 жыл бұрын

Hi, Can you make a video on difference between Busi. Analyst and Management information systems? Really confused about these 2

@MB-365 10 ай бұрын

Thank you Alex

@mithranseralathan6206 2 жыл бұрын

Thanks you 🙏

@mubaraq8853 2 жыл бұрын

Alex The Goat

@user-yy2yh2st7c 2 жыл бұрын

Thanks♡♡

@mouadbouafia9453 Ай бұрын

Thank you

@MuIqHa93 Жыл бұрын

Hahaha Alex, I just want to say. You explained JOINs better than the Google Course 🤣

@TheOrganizedProfessional 2 жыл бұрын

How do we join the data if they are from two separate files?

@davidmawson438 Жыл бұрын

Any chance of explaning please the benefits of joining a table to itself in Tableau, and how that's useful?

@malcorub 2 жыл бұрын

13:30 man, Michael Scott's salary is super low for being the boss man. 😄 lol. Great tutorial Alex!

@pieneclaessen 2 жыл бұрын

Hi Alex, But off topic, but I have a question about learning my data analytics skills. I am currently learning Python. Now I saw you highly recommended the Google data analytics course. Is it worth to do both courses simultaneously? Or should I choose on or another? Side note, until the end of the year I can work full time on courses.

@abz4852 2 жыл бұрын

google data analytics is only for the fundamental understanding of what you do as a data analyst and basics in all the different skills e.g. google sheets, sql, R, etc. If you are already learning python then better off focusing on that and going more in depth with the other skills and then completing some projects

@susanwangcfa3685 Жыл бұрын

Alex, you look much better without those glasses =). What I do not understand about this example is: Does it assume that the user is aware (or unaware) of the missing data? I would have to think that if one was aware of the missing data, the better option is to simply update the original data source, so if the user were unaware of the data issue, what is your suggestion as to how this would materialize during the selection of Joins? (In this example, I believe you were searching for it only because you were aware of it, so just questioning how obvious it might be for the average, unaware user.). Thank you.

@hamzaaalam4971 22 сағат бұрын

THANKS

@motivationmafia. 2 жыл бұрын

Please upload microstrategy tutorial videos aswell. The youtube has very less content about it.

@muhammadsaad2070 2 жыл бұрын

when will be the remaining part is going to be uploaded?

@chinyerenwigwe5166 Жыл бұрын

Thanks so much Alex However I need help!!! My joined table is not showing but rather it's saying "data preview unavailable" what do I do please Pov I am using Tableau public

@whole.milk__ 4 ай бұрын

ahahah Assistant to the Regional Manager for Dwight love it

@shimmeringblue8408 2 жыл бұрын

Where do we get the Tableau Joins file at???? Help Are we supposed to be following along? Where is the file at? Thanks in advance

@henrifortier8621 Жыл бұрын

I'm not sure to understand why not simply doing relations instead of joins ? (still new to Tableau but experienced with PowerBI)

@k.e.8326 2 жыл бұрын

so you made the joins but for the visualisation you didnt use it, correct ? or am i understanding this wrong ?

@julierenee6668 Жыл бұрын

Aren't joins easiest & best in SQL, then in excel power query, & least in Tableau?

@MamaMia914 Жыл бұрын

My Measures and Tables didn't get the names of the Excel file tabs. I have no idea why.

@KroutAr 3 ай бұрын

But like if i have null in my tableau, it means I was doing something wrong in my SQL/Excel

@mdjavedfurquan4585 Жыл бұрын

I'm unable to download the join file from github

@swapnilshah4620 Жыл бұрын

Not able to download the file from git

@حسان-ونس 2 жыл бұрын

I have a question not about tableau. I just wanted to ask you and this was your latest video. The question is there is a path in LinkedIn Learning to become a Data Analyst and it is for free and was there before Google Certificate and IBM too. But no one talk about it and if it is good or not, if it is updated or it is old for nowadays data analyst career, and a comparison between the 3 of them. And a small tip for google and IBM, we don't have jobs we do not have money to bay for Coursera why do not make the full course on your site if u do not get any revenue from Coursera

@232djcdify Жыл бұрын

love the fact that you play League of Legends

@samuelraj5613 Жыл бұрын

Done

@RijulChauhanRA 2 жыл бұрын

Is Your enough Tableau Interview

@AlexTheAnalyst 2 жыл бұрын

Enough to get you started and understand what Tableau can do - I would do some projects (which I have one already up and one that's coming out on Tuesday of next week)

@ShowBizJunkie 2 жыл бұрын

Your tableau join file has an "xlsx" extension. It does not download correctly. Maybe you meant "xls".

@user-le2ei6ue7l Жыл бұрын

Apparently, since this video has been posted, they've updated Tableau. Now, it spits out all the join info for you automatically. I'm going to do many things, but complain ain't one of them.