How to use Joins in Tableau | Tableau Tutorials for Beginners
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 2024
- Check out my Full Tableau Course Here: www.analystbui...
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/Ale...
Favorite Tableau Course:
Tableau A-Z - coursera.pxf.i...
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.i...
Data Analysis with Python - coursera.pxf.i...
IBM Data Analysis Specialization - coursera.pxf.i...
Tableau Data Visualization - coursera.pxf.i...
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/...
____________________________________________
Websites:
GitHub: github.com/Ale...
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
Loved the fact that you are using tables with information about the characters from the office. I like you more just for that
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!
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!
Not too bad once you get a hang of them!
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
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!
I check your page everyday waiting for the next tableau tutorial. Thanks a lot Alex.
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 .
Just realising that those where The Office employees. Awesome!
I wake up in the morning to a new tutorial vid! Thank you!
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.............
I'm sincerely grateful for the video. I have learnt something new (joins) today. God bless you.
Thank You Alex I am mastering Tableau because of you!
Alex, you explained the joins very clearly. Thank you so much
Love the reference from "The Office" with character names, haha.
I watched the whole tutorial. This is much appreciated thank you.
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
Very good video, with a great explanation! thanks!
Understandably explained, thank you!
Hahaha Alex, I just want to say. You explained JOINs better than the Google Course 🤣
Big thanks for your video Alex.
Thank a million for sharing. Your tutorial is helpful for me.
Hi,
Can you make a video on difference between Busi. Analyst and Management information systems?
Really confused about these 2
13:30 man, Michael Scott's salary is super low for being the boss man. 😄 lol. Great tutorial Alex!
Thank you, it helps me a lot.
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.
Thank you
THANKS
Thank you very much Alex for this useful tutorial
Great tutorial 🙌🏼
Thank you Alex
ahahah Assistant to the Regional Manager for Dwight love it
Any chance of explaning please the benefits of joining a table to itself in Tableau, and how that's useful?
Alex The Goat
Thanks you 🙏
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
But like if i have null in my tableau, it means I was doing something wrong in my SQL/Excel
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
I'm not sure to understand why not simply doing relations instead of joins ? (still new to Tableau but experienced with PowerBI)
Please upload microstrategy tutorial videos aswell. The youtube has very less content about it.
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
Thanks♡♡
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.
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
How do we join the data if they are from two separate files?
so you made the joins but for the visualisation you didnt use it, correct ? or am i understanding this wrong ?
when will be the remaining part is going to be uploaded?
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.
My Measures and Tables didn't get the names of the Excel file tabs. I have no idea why.
Aren't joins easiest & best in SQL, then in excel power query, & least in Tableau?
I'm unable to download the join file from github
love the fact that you play League of Legends
Not able to download the file from git
I did not know that Dwight earns almost the same as michale scott XD
Done
Your tableau join file has an "xlsx" extension. It does not download correctly. Maybe you meant "xls".
Alex now that we know you play League of Legends... what rank are you?
Lol I was Diamond at one point a few years ago when I really gamed. I haven't played in quite some time.
Is Your enough Tableau Interview
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)
Oh, you play League of Legends. Nice to know lol
not a sheer one.
orrrr just use sql