 What's going on everybody welcome back to another video today we are starting our Tableau tutorial series Now this series is for absolute beginners So if you have never used Tableau before you were in the perfect place I'm going to take you all the way from the very beginning of installing it and just understanding what Tableau is and how you can use it All the way to creating dashboards and sharing it now personally I hate those videos that are like three hours long and they just expect you to go through it I'd like to break my videos up into chunks So if you have ever done my sequel tutorials, you'll know that I like to break things up So it gives you time to try them out and do them yourself and then you can move on to the next video So I'm going to be breaking this up into five separate videos But in this video, I'm going to show you how to install Tableau for free. I'm going to show you the user interface We're going to download a data set that you can find on Kaggle And then we will build our first visualization together with that being said let's jump over my screen and we'll get started All right So the very first thing that we need to do is you need to actually download Tableau So we're not going to be using Tableau. We're going to be using a free version called Tableau public It has a lot of the same features except of course, it's not Every single feature that regular Tableau has but it is absolutely perfect for learning it and for using it And and you can even build, um, you know dashboards and share those for your portfolio Um, I'm going to put this link in the description So you can just go and click on that and all you have to do is input your email right here I'm going to click download the app And then it should start to download and then you can save that and then you're going to open this up now I'm going to open it up. I don't know what it's going to do. I already have it downloaded But it should open up and look hopefully like what you're seeing on my screen in just a second Let's see what it does. Um, I hope you can see this, but it says Tableau public It says I already have it set up, but you're going to click install and go through all that All that set up stuff. So I'm going to exit out of here I'm going to go over here and type in Tableau public It's 20 21.3. That's the current version that they have out If you're doing this in the future, they may have, you know different versions So you should be able to pull this up right here now I'm going to Go and get our data set that we're going to be using and I'm going to show you how to get that as well And then we will actually jump into Tableau and start using it So let's go over here. I'm going to get a data set from Kaggle. I wanted something pretty generic To show you in future videos I'm going to show you some special or not special but just different visualizations that you might use And we'll get different data sets for those because of course not one data set covers all these other types of visualizations So we're starting off pretty simple right here. We're going to be getting one called video game sales and We can take a really quick look at it. Here are some of the fields that you're going to be having Like rank name platform the year genre and then some sales data And this is what it actually looks like. It's called vg sales of video game sales into the csv and You know here are the fields And we have our data and all we are going to do is we're going to download that And I will save it now when you download it. It's going to be saved into a zip file. So we need to go to our downloads Let's refresh this Here's our archive. We need to go in here. You can just copy it And paste it right back into here um, and just so you know that is a A csv so be aware of that So what we want to do is we want to come in here now since it is a csv This is not we're not going to be using microsoft excel. We're going to be using the text file So we'll come in here We'll take vg sales now One thing I want to do before I do that is i'm going to rename mine vg sales underscore one I've already Prepared for this and so I already have that in there But so I want to make a distinct one for myself. You do not have to do that. So we'll come back here Um, and then we're going to do text file and vg sales We're going to open that up and When it pulls up right here Um, you can bring in other tables and then you can start to join them together and create those relationships We are not going to be doing that in this video. We'll do that in a separate one Um as for you know, just getting started, you know, we're not going to be using that but you can see um some of these things or some of these fields and if you notice they they um They're either abc or they're a number. So it starts to categorize What this field type is so is it a string? Is it numeric? It starts to automatically do that and that's all done within tableau And so it just kind of reads it and that's what it does What we are going to do is when I click right down here, it's called go to worksheet Um, the worksheets are where you're going to actually start being able to build your Visualizations your charts your graphs all these things. Um, and so, you know, we have this in here now And so we're just going to click right here On go to worksheet as you can see here is vg sales underscore one You will not have the underscore one if you did not add that like I did Uh, but right down here, you can see all the fields that we just imported from that data set And they even created one right here for us. Uh, they just generated that field Based on the file. So it's a count of all the rows really So what I'm going to do is I'm just going to walk you through Uh, basically what we're looking at some of the things that we're going to be using today There will be things that I don't talk about but I'm going to highlight those and set in in future videos when we start using those Are going over them. Um, and so let's just start with the most obvious one. It's way over here I'm sure you saw it when we uh, this first came up on the screen because it has all these different charts and visualizations and graphs and uh These will become available as you start dragging and dropping our data into this sheet And so if I go right here, it says four scatter plots try zero or more dimensions two to four measures So what our dimensions are are right here and what our measures are are right down here And so typically uh things like like you say genre or names or or strings like that are going to be These uh dimensions and then a lot of a lot of times the numerical is going to be are going to be measures Next what I want to show you is right here So you can take something like global sales and you can drag it right here into your rows and then it Takes your rows and so it automatically created a sum of global sales Now if we take that away, and let's say we drag it right here. It's going to give us a column Now you can also do it right up here. You don't have to um drag it on screen you can also Just add it to the column or the row. That's typically what I do. I it's just more intuitive to me Or you can drop it in this section right here And it does its best to assign it some type of Some type of visualization and so that's what it always is trying to do. It is trying to say, okay This is what you're trying to do. Let me try to get the best visualization for the data that you're giving me Now while we are here It went down here into marks and marks is a very important area It's where you can add color size text Detail and tool tip and I'm not going to go into what all those are because I'm just going to show you So let's start pulling some fields in here and creating a visualization And then I'm going to show you how all of that works Including filters as well. So the first thing that we are going to look at is global sales And let's put that in the rows And then I'm going to take year and I'm going to make that the column And this is basically exactly what I wanted to do now as of right now It has only the year and it's looking at global sales for everything But we want to break that out a little bit better I want to break it out by let's do genre. It's a different genre of games Now if I add that right here to this columns, it is going to break it up by year and genre If I add it right here Is going to break it out by the year of course, but then in each individual row has the different genre That's not what we want. We want to keep this type of line graph And what we're going to do is we're going to add it to marks And you can't really see it based off of these colors, but they're all different So we have action genre. We have the sports genre racing role-playing all these different genres within it Now we can get rid of that because we don't need it anymore And this is where these These marks really come in handy because you can start Basically doing what you want with them. So for the genre I want to be able to see all these different genres with different colors to me That just makes the most sense. So I'm going to put color right here And automatically it assigns every single genre its own color And gives us this legend right over here And so it's really easy to see well when you have smaller numbers is much easier But I know that red is sports and I can go right here and find red and that is sports So it makes it a lot easier than when it is all the same color blue So what you can do after that is you can also add things like a label to it So if we take label and we or we take genre put label You can click right here and you can get rid of the labels that you have and you can see them right down here Or you can also change the font. So if you want to make it orange or whatever color you can do all those same things And you can also do things like changing where you see these things So for action, you're going to see it a ton because for each year action is is at the Is on the higher end and so you're seeing those in those minns and maxes You can also do it for a selected area. So if I come in here and I select it It's then going to show me what those are. So label is really really useful really helpful Let me get rid of that really quick You can also do it where the lines end so line ends is at the beginning and the end and you can also Take that away or put that back on So labels are really important labels aren't very helpful when you're doing at least I don't find that it's super helpful when you're doing things like genre So when you're doing your dimensions, so I'm going to get rid of that and I'm actually going to bring Our global sales over here and let's label that And right now I think it's labeling the Line ends we want to do the min and max Now if we do min and max on the table It's just going to give us the max and the min which is zero and then 139.4 It's a little bit more useful if we do it For each line. This at least gives us some context I probably wouldn't do this in an actual visual visualization, but to give you some understanding just how it works. So now I know that Right over here the min and the max or the min Sorry, the max for these for action and for sports Is right around 138 139. So it's pretty easy to see and you can Again go in here and you can remove the max or remove the min's Whichever one you feel is best You'll probably keep the maximums in there for each category. And so this is a really quickly becoming A pretty usable visualization And that's not the only label that you can add we still are using year over here So we can always drop year in there as well We'll create a label and so now we have let's see for this one is a puzzle genre So we also have the year that it had the maximum Sales and so you know just some things that you can do you don't have to add that Now let's go up here and we're going to take a look at filters because filters are really important You know if you are making this for a client or you're making this for somebody You want them to be able to filter down? To very specific information that they want to see so Let's take the platform lots of different platforms As you can see you know ps4 xbox if you're familiar with these We'll click all of these And we'll click okay So now this is an option as a filter and all we're going to do is we're going to click on this arrow right here And we're going to say show filter Now right now all of them are selected So every single one is being taken into account for this visualization But let's say we come down here and we say okay I don't want to see sales for any of these ps the original playstation two three or four So i'm gonna get rid of this one this one this one And this one and you could immediately see the the changes that were happening So now none of the numbers none of those sales Are being accounted for and and being added to the sum of global sales right here at all so That is just how a filter can work and You can also Do that And you can get rid of all of them and you can go in and actually just pick very specific sales So if you only want to see the playstation sales You can go in there and do that as well So really really handy filters are things that You at least want to have as an option for most of your Your visualizations at least that's what I found especially when you're doing client facing work They like to Get in there and mess around and look at different look at it in different ways And so that's one that I I think is is really useful to to have The very last thing that we want to do Is we want to actually add this to a dashboard now Let's say we come right down here and we add a new worksheet And actually we might change one more thing on that last one, but we'll just make a really simple one We'll just give it genre and we'll give it global sales as the rose And this nifty button right up here, which is a sorting button So i'm going to sort like that I'm going to add the genre in just as we did i'll give it different colors perfect Now we have two really quick different visualizations, right? What I want to do is just show you how to combine those because what you are going to do Is you're going to actually come in here and you're going to do new dashboard That's what this button is right here now when we come in here the size is extremely small That's very easy to fix that all we're going to do is click right here I'm going to go to this range of this drop down and we're going to click automatic So now it is a much larger size for us to actually drop our visualizations into Uh, and let's put sheet one And we'll put uh, let's put it up top So now it looks a little bit like this, uh, not perfect, but again If I wanted to make this look a lot better, I definitely would And then you can go over here and you can rename these things You can also do that back when we were in our actual, uh worksheets But you can also do it here as well and then start, um, you know, customizing and building it out That's not what this video is for that is the last video We're going to build an entire dashboard. It'll be kind of like a small project You can put that in your portfolio If you have gotten this far and you want to jump straight into it And you don't want to wait for these other videos to come out or you don't You just want to jump straight into creating an entire portfolio project I have an entire portfolio project series that covers sequel python and tableau And so go check out that series. I have one video dedicated to tableau. It's like 45 minutes or an hour long And it covers a lot of the things that we're going to hear in here as well as a few other things But I appreciate you checking out this video in future videos We're going over things like creating bins calculated fields Doing joins and then creating a final project and putting it all together So thank you so much for joining me. I really appreciate it If you like this video, be sure to like and subscribe below and I will see you in the next video