 What's going on everybody? Welcome back to another video. Today we are starting our second portfolio project in Tableau. Now in the very first project we focused on SQL, so we imported a COVID data set. And then we looked at that and just wrote a lot of queries. And if you haven't done that one yet, that kind of leads into this video now. And so you might want to do that one first. And so I'll leave a link in the description if you want to do that. This project is all about creating visualizations in Tableau. So we're going to create multiple visualizations. We'll combine all of those to create our dashboard and then we can share that dashboard. And you can put that on your resume and your portfolio or on your LinkedIn. I want to mention once again, I tried to make this as beginner friendly as I possibly could. So if you have no experience with Tableau at all, you should still be able to do this portfolio project and add it to your portfolio. Without further ado, let's jump over to my screen and get started on the project. So let's start the project. And the very first thing that we need to do is download Tableau public. All you have to do is go to the link that I will leave in the description below. All you have to do is go in here, put in your email, click download the app. Of course, I've already downloaded it and I checked multiple times and it works. Then you just go through the process to actually create an account. And once you have that account, then you can start building your visualizations. Now, you also get an online account. This is my Alexi analyst account. This is the visualization that we're going to be working on. And just to give you a really quick look at it. This is it. This is what we're going to be working on. It's nothing crazy, nothing too hard. Anybody should be able to do this. This is supposed to be a more of a roadmap to how to get started, how to create your first dashboard, whether it is very simple like mine, which I would consider this pretty simple. One that I think we can do in under an hour and a half, whereas I tried earlier to do one and I recorded for about three hours and it was, I would consider much, I don't want to say better, but it was just more advanced, a lot more colors, more different things, but it just took forever. I didn't think it was very helpful for a lot of people. I thought it was a little bit too complex. So I trimmed it down, got down to the nitty gritty and this is what we're going to be working with. So I'm really excited about it because I think this is actually a lot better than the longer version. So you'll have this account and once you download everything, you'll be able to kind of search like I'm searching right now, search for Tableau. A Tableau desktop is going to come up and you will now be able to insert it. Now, you know, we worked on all these things in SQL and we created the views, we did all this work. Tableau Public, you can't connect to a database. You can't connect to SQL Server and that's kind of a bummer because they'd be super great to be able to do that and in a work environment, that's what you would do. You know, ideally that's what you do. Sometimes you download it for Excel for different reasons, but we can't do that. We're going to be using Excel for this. So what I've done is I've created these queries used for Tableau Project and I've already saved this query. I'm going to put it in the descriptions that you have it. I tweaked, again, I went through and I tweaked some of the scripts that we worked through. It's very similar. If you notice, it's very, very similar to what we worked on in the first project. I tweaked them. These are the first four. These are the only four visualizations we're going to be doing. Nothing crazy. I promise you originally, and I kept the original queries in here in case you were curious and wanted to look at them and try to use them. I had these and there were seven of them. And again, it just took a really long time to get through the video. I felt like it was just too much, to be fair. So I genuinely do believe that trimming it down was the best decision and it's going to be better for you. It's going to be better for me. And we will go from there. So all we're going to do is we're going to run this, let's execute it, and we're going to hit up on this top left. And we're going to do is control shift C. And what that does is it copies the data as well as the headers. And that's something we need. So really quick, let me get out of these. This is from a previous attempt. Let's go to Excel. And we are going to insert this. And we're going to save it. So we're going to do file, save as, I'm just going to go to my downloads. And I'm going to say, let's do Table 1 and replace for me because I already did that one. Let's go back. And I put some notes in there. You can read through it. This is just to double check that the numbers are right and why it's correct and why we're using it. This is number two, plus copy. Again, upper right, control shift C is going to copy everything with the headers and that is what we want. Again, I know this is tedious. It's not really that tedious. I hope this isn't crazy tedious. But it is very manual. Normally, you wouldn't have to do this. But we do. And that's okay. I think Table 2. I think this is a good learning experience, good bonding experience for all of us. If you do this with me, that means we've seen stuff together me and Engels. So this one, control shift C is going to be our Table Table 3. All right. Oops, what am I doing? I need a new one. So something you need to look out for and something that we didn't have to look out for in the previous two is nulls. Now, when you insert or upload data or import data into Table Low, Table Low is going to do the best job that it can to assign a data type to that column. And if you have nulls in any of your columns, it could mistake that for a string or it most likely will. If you look, I already have this sorted by highest to lowest. If we go down to the very bottom, there are these nulls here. We don't want the nulls. We want those to be zeros because then it will be numeric and it will assign it a numeric data type. And so what we're going to do is we're going to do control H and let's just have it. I almost always do that. So we're going to do null and that just assigns it to not just one sheet, but if there's multiple sheets with nulls in it, we'll do that. Well, no, we'll go to zero, replace all them, and we should be good to go. This should fix any issue that we might occur or have in the future. And I promise you, somebody's going to skip this part of the video and they're going to have this issue and they're going to come back, they're going to be watching this, wishing they just watched this in the first place. So stick around because we have to do this in the next one as well. So we'll do File, we'll do Save As, Download. So do Table Low, Table 3. Now you may be wondering, Alex, why aren't we just saving this in one Excel with different sheets? Why aren't we doing that? Well, that's great. Really a fantastic question, to be honest. The reason for that is if we include all of these in, I'm just going to keep going while we're talking, if you include all of these in just one Excel, they have to all be able to tie together. And as you may be able to tell now, they don't. And that's because it's like a joint. You have to be able to join it on like a date or the continent or the location or multiple of those things. And if you notice, we can't do that with these. And so we have to separate them out. Now we also need to change the date in this one. So let's do Short Date. I just have to go right up into this dropdown after clicking on C. And there are nulls in this one as well. Let me see if we'll find any. Yeah, there's nulls here as well. So we need to do the exact same thing. So nulls to zero replace all. And there was 5,000 done. Let me make sure because I thought there were more than that. But let's see, maybe I'm wrong. Okay, that's great. No, that's fantastic. Okay. So we're good to go. We have, once we save this, we have our four. I can't talk at the same time. I can't talk and type. Table four, we have all of them ready to go. We have all of them set up. Now we need to actually get them into Table Low. And then we need to start building our visualizations. So pull up Table Low with me. Click Microsoft Excel. And we're going to go to Table One. And we're going to open. And this is exactly what we had before. This is our Table One. Now we don't want to add connections to this. What we want to do is let's go down to this. It says it's prompting us to go to the worksheet. So now we have access to this table that we just imported or this Excel sheet that we just imported. What you'd want to do is you can do it here. I'm, for the sake of what we're doing, I'm just going to go to sheet two. Go to this one right here. It says new data source. Go to Microsoft Excel. And we're just going to do this for all of them. So we're going to do, we're going to import it. We're going to go over here. Now we have our Table Two in here. Again, just doing this, you don't have to do it exactly how I'm doing it. There's a faster way. But for visual purposes, I'm going to do it like that. All right. And then four, we're going to add it. And now that we have them all opened up, what I'm going to do now is I'm going to cut myself off the screen because you don't need to see me anymore. And I'm going to, I'm honestly, I'm going to get in the way because we're actually going to start building our visualizations. I want you to be able to see everything, be able to track everything. I don't want to be in the way in this upper corner where I am. So thank you for sticking with me. I'm going to get out of here so you can just hear my voice and we will continue on from here. All right. So you should still be hearing my voice. I am still here, but we are going to get started. Now the very first one that we're going to do is by far the simplest. It's extremely simple. Let me show you. We're going to be looking, we're going to be doing this one right here. So these global numbers with just these colors and the columns and rows. So very simple. Let's go back over here. So what we need for this is the total cases, total deaths, and the average death percentage. So we have those over here. Let's go over to table one because we were just on table four because we just imported that one. So we have total cases. We'll make that a column. Total deaths and death percentage. Now, of course, this is not how we want it visualized at all. What we want to do is go over to the show me and then go right back up here for these text tables. So if you, oh, let me click on it. So right down here, gosh, come on. It says text tables down there at the very bottom of this box down there. It says for text tables, try one dimension, one measure. So that is what we have now. And we want to move these measures right up here into the columns. And let's rearrange these really quick. Not perfect. That's exactly how I wanted it. So now we have the total cases, total deaths and death percentage. Let's expand this just a little bit so we can see each one perfect. There's a few things that we need to change in here to make it just more user friendly, make it look better. And once we actually put this into the dashboard at the end, we'll probably have to come back here and change a few things anyways, but it'll give us a pretty good start. So the very first thing that we want to do is just change the coloring, change some of the formatting and make it look a little nicer. And then we'll do a little bit after that. So if you see over here on these marks, there's color, size, text, detail, tool tip. That's referring to these numbers right here or what is in these rows. So if we go over here to color and we make them orange or green, we can do that. I like them black. I think it's going to stand out when we put the color behind it. I personally like that look. You can also change the size and make it as large as you want. I actually do want the size to be a little bit larger anyways. So let's do that right now. It doesn't hurt. And let's pull this down a little bit. So if we go up here to format and let's do shading. This is going to where we can get some of these colors. Let's go over to columns and our header. I believe that's what these are, our headers. Let's go over to this color. That's perfect. Let's just keep it like that. I think that's easy enough. And let's see. Let's see if this is referring to our... Maybe it's not. I was trying to change these really quick, but I'm forgetting where those are. Not super important. We can always do that later. But we also want to change the shading on these as well. Now, if you go over here and you go to the worksheet and you change that, it's going to change the entire thing. That looks absolutely terrible. I do not recommend that. But if you go to the pane, the pane is what's referring to this with the rosemate. So we can do this. I like it a little bit lighter. Maybe like that. I think that doesn't look bad at all. So there's a lot that you can customize in here. You can even do grid lines, trend lines. Let me see. Maybe we want to do something like this. I mean, I personally like doing some sort of lines to separate these out. But we don't have to, but I'm going to try to do a little bit. No, not try grid lines. Yeah, something like this. So let me do a little smaller. Just like that. Super simple, separates it, makes it look nice. We'll probably come back and change this at some point. But I think this is very similar to what I did originally. And I think this will be good to go for now. Let's keep going. Let's go on to our second sheet. Hey, future Alex here. I realized that I forgot to show you something and I did not want to leave it out. I wanted to make sure that you knew how to do this. So I'm coming back in time. We have already completed the entire dashboard, but we're going to pretend that we have not and we are still on sheet one. What we're going to be looking at is this death percentage right here. It says 2 as in 2%, but it's rounding to the nearest whole number. And for death percentage, we want to be a little bit more accurate than 2%. Maybe 2.1103 or whatever that number is. We want to be a little bit better. And so I think we want to go to the two decimal points or the 2.11, which is what the number will be. So the first thing that I'm going to show you is how not to do it. And this is probably something that a lot of people will do. I know I did. You'll go right here and you'll right click and you'll go to format. And you know, this is not where you need to be looking. Although you can look through here and figure that out yourself, if you want to, the actual place where you need to look is right here in this measure values. So let's go over here. Let's click the drop down. We'll go to format. And under the default pane, there's this numbers. And if we click on it, we can go to number custom and change the decimal place. So as you can see right now, it's affecting every single column and we don't want that. And it's very easy to just specify what column you do want. So we're going to go up here to fields, click the drop down and go to some death percentage. And now the only option we have is just numbers. So that makes it really easy. We're going to click here, go to number custom and then it automatically goes to two, but you can go as specific as you'd like. I'm going to keep it at two for at the end of the video, you're going to see that it says two on mine, because I'm going back the next day and showing you this. But I hope that yours says 2.11 or as specific as you'd like to be so that you have that. So I hope now yours will be better than mine at the very end. I hope that this was helpful and we'll let's continue with the video. So sheet two and let's get rid of this format lines. Let's go to table two. So what we are doing in this one is we're going to be creating and I'll go back here to show you. We're going to be creating this graph right here. Okay, that's great. Give it a second. We're going to be carrying that bar graph that you just saw. And I'm not going to wait for it. It's if you look right here, this small bar graph. That's what this one right here, that's what we're going to be making right now. This one should, I believe they did the second simplest. I kind of did them in order of simplicity. So let's go over here. We need our location. You can either drop it down here as a column or drop it in here as a column. Either one works. So it's Africa, Asia, Europe, North America, Oceania, South America. Let's try to expand this a little bit. Okay, that was way too far. Let's do like that. Perfect. So we have our locations and what this one is going to be actually looking at is total death count. So the current global death count. So we want to do this by rows. And it's already looking super close to what we wanted or what we had in the previous thing. So super, super close already. And you can do other things. If you want to, you know, you want to mess up your visualization with a pie chart, go for it. Or do what I just did. You know, go for it. But I like the simple look of the pie charts. You know, I'll show you how to kind of change the colors in a little bit if you want to do that. You don't have to, but you absolutely can. So something that I want to do that I personally like doing is going is ordering them by highest and lowest. I like that descending look. So let's go up here and let's go to sort. And I want to do it manually. So let's see which one's the biggest. So Europe should be at the top. Then North America. And then Asia. And then South America. Oops, South America is before Asia. There we go. Looks like it's out of that. So we could keep it exactly how it is. And it would be fine. But we want to make some additional changes to it. I want to rename this location to continent. That's not right. I think it's right here. That's it. So let's do continent. Is that how you spell continent? Yeah, that's how you spell continent. Perfect. And it changes up here. Super easy. And if we do this right here, and we change this to color, then we can change the colors. These are our marks and we can change certain things about them. So the size, right? If we want to change the size, we can do that. I like to keep it pretty moderate. Just a normal one. I don't want to get too crazy over here. I'm just trying to help. So if we do the color, you can do lots of different colors. And you can do it in an ascending order. That didn't work at all. Orange, assign palette, apply. There we go. You can do it in descending order if you want. That looks totally fine. You can keep a theme in your Tableau dashboard, which will be something that I probably talk about in my tutorials. Speaking of something I have not mentioned, and I'm just going to take a super quick break, like 30 seconds. Something I have not mentioned is if you have never done a Tableau project before, a lot of this might be very confusing, and I hope I'm not going through it too fast. I'm coming into this with hopefully the, I hope I'm explaining it and going through it slow enough. I am going to be doing a complete Tableau series coming up very soon. Like within the next two months, I'm starting it. And so I'm going to have a complete tutorial on a lot of the basics. A lot of the things that we're looking at right now, as well as a few more advanced things. So I did that backwards. I could have done the tutorial first, but I really think these projects are important to do. So I got them up first. But if you're having trouble with these, look forward to those in the future, and just try to keep up with these. You'll learn a lot just by going through these and doing what we're doing anyways. So let's get back to the project. I don't harp on that too much, but the colors you can do a lot with if you want to. I personally just want to keep it how it was. So I'm just doing Control Z. I'm just going to keep it like this. Not doing anything too crazy, not doing anything fancy. But please play around with it. Do what you think looks nice. Again, I am trying to keep it as simple as possible. That's not confuse anybody. So we have this, there's a few other things that you may consider doing. Speaking of something like this, you can enter this axis. Now, as of right now, it's doing tick marks, or I think I'm going to call them tick marks. They are called tick marks of 100,000. You don't have to have it like this. You can change it and customize it however you want. So if we want to make it, let me see if that's right. Yeah, if we want to make it like this, where it goes up a little higher, that's totally fine. And if these tick marks, they're automatic, they're doing tick marks of, whoops, that's just a million. So that's what it's going to look like with a million over here. And we can also get rid of one. And then it's going to be the exact thing that we just did, or we can get rid of another one, and it's going to look like that, or we can get rid of another one, and it's just going to, it's going to look how you make it look. Okay, I'm just going to keep it with the automatic again, not because I'm lazy, but because I think it's just a little bit easier. If you want to change this total death count, you definitely can. I personally, we can keep it like that. I might even change it to death count later on. But I think this looks nice. It's in order. It's simple. And visualizations should not be crazy hard to read. So that is the end of our second visualization. And we're going to move on to our third one, and arguably my favorite, which is the map. So let's go to number three. Let's go to table three. And let's go look really quick at what this looks like, just kind of like this. And I think how we have it or going to do it is going to be even better. So what we have is we have the location. And in location, as you can see, these are all countries. Now, it's not going to open up these map options and the show me it's not going to open up the those map options because that's not how the map options work. As of now, it's just looking at as a text. But we want to tell it and say, Hey, this is not just a location. This is part of a geography. This is something that you should be looking at differently. So we can change this and we go we're going to we're going to click on this little drop down. We're going to go down right here to geographic roll. And we're going to go down to country region. Let's click on that. And as you can see down here, they just generated some longitude and latitude. So what we need to do for that is stick them right up here. There's our longitude. Here's our latitude. Excuse me for a second. I just needs it is allergy season for me. My goodness, it is not pretty over here. So we have the longitude and latitude. And as you can see, it opened up that map for us. That is fantastic. And now what we need to do is we need to start adding things in. Now, it's not automatically really quick. If you want to do the pan, you want to be able to reposition it. That's what I want to do. Reposition it about right here. You just click on this arrow, click pan. This is how you select multiple. I don't really need that. So I keep it on the pan from most part. Anyways, now this is where we need to insert what is going to be looked at and then what is going to be, what colors, how are we going to assign colors to these countries? Okay. So the first thing I want to add over here is the location. So that I can now look and assign something to each location. I want to make, I want to keep that the same really quick because I want to add in what we're actually going to be looking at, which is our percent population infected. Now, why do I not want to add it over here? It's because it ruins everything. That's why I want to add it right down here. And that's fantastic. I want to actually make this a color. Oh, now that already much, how do I say this? It resembles it a lot more closely. So this is a lot more along the lines of what we were hoping for. So this is looking really, really good. So there's a few things that I want to mention or talk about before we actually start moving into this. One, Tableau has their own whole section called map up here. And there's a lot of things that you can do with it. We're not going to be looking at everything today, but one thing I do want to look at is just these background maps. It adds a little bit of depth, a little bit of, it can change the moods like this is a nighttime one. So if you have like nighttime data, we're looking at, I don't know, the stars, suns, rotation. I have no idea. You can do that. The one we're going to be doing is this outdoors one, and it's just going to show the ocean. And if you notice the United States and like all the actual country names get a lot brighter, something that you can do is add something like a label. And before that would have made sense. Because if we have it like this, where it's light, you can't really see the United States behind there, but you may have a label on there and the label helps. But I don't like this label per se. You can always change it and go and make it better. I don't necessarily like how they have those labels. So I'm going to use the outdoors. I'm going to get rid of this. So I'm just going to go to detail. I like how this looks a lot more. It just suits what I personally prefer. But if you don't like that as much, go over here, go to label, and then adjust that label to how you like it. I think that is perfectly acceptable. Now, these colors aren't to my taste. As you can see over here, we have this legend, and we'll get to that in a second. But I personally like a little bit different colors, and we can change that by going to color, clicking on that, and going edit colors. So I don't know why I pulled it over there. I'm going to pull it back. It doesn't make sense. I personally like reds, oranges, these kind of things, at least the infection rates, because I feel like it... I don't know. It's kind of a scary thing. So I want to make it that way. And so you can do something like this. I think that looks very nice. We may even keep it like that, but just for a sake of what we're doing, you can do something like this. Again, it's the personal taste. So if you don't like this one, don't use it. I don't want you to use it. I want you to find one that really looks good to you. And just know that anyone that you choose, you'll still have this right over here. So you should be all right. Let's just try this red to gold. I think this is kind of what we're going for. And to me right off the bat, just starting out, looks like we're doing pretty good. Let's go over here really quick. Let's go to this legend and drop us down. So there's a few things you can do over here. But one thing I want to do is just edit this title. I don't want it to say the sum because each country has its own row in our Excel. So it's not actually the sum, it's just its row. But I don't want people thinking this is some type of aggregate function. I just want people to know this is the percent of the population infected. And speaking of, we should edit this to do, let's see, let's do percent population infected per country. I don't know if that's what we had it in the last one, but that's what we're naming it in this one. All right. I think this one looks good. I mean, we could do more with this in terms of labeling and colors and different stuff, but we don't need to. We do not need to do that. One thing I will note, again, just to make this more of a memorable or teachable moment, you don't only have to have one thing in these marks. If I wanted to add a location down here, I can. And I can change it and make it, I didn't want to do that. That looks terrible. But you can do multiple things. So I can have a label here and I can do the color down here. I can do multiple things with it. So just know that if you want multiple, if you, oh, hey, I want to have a color on the location. I also want to have a label on the location. You can do that. You just have to add multiple things that that marks teachable moments. Just trying to keep it kind of keep trying to keep the learning alive. Um, let's go into the next one. Let's go to sheet four and go to table four. Now, this one, we're going to be doing some time series. We have some time series data here. And for this, we're going to be selecting a few specific countries. You can select whichever countries you want. But I have a few that I'll show you in a little bit that, you know, I think are just not the most relevant, but are really interesting. So what we need to do is we need to bring over the date. And we want that to be on our a column because we want it to show the progression over time. The thing that we're going to be looking at is actually the percent of the population infected. So let's bring that down right here. And look, it already tried its best to create something. And it really did. It tried its best. Let's, why do I keep scooting it just a little bit? I want to scoot all the way. It tried its best. It really did. But let's pull, let's drop this down really quick. There's a few different things that we want to look at. First off is like just this, the dates, because right now it literally is just 2020 and 2021. And that's not exactly what we want. But let's do this really quick. Let's put month. It's breaking out by month. And now I'm regretting making it larger. If you notice, it doesn't have 2020 or 2021 in here at all. It just has January, February, March, April, May and June, July. So it's breaking it out per month. Let me go back to make it small again. It's breaking it out per month. And that's not what we want. We don't quarter either. We want to have it by year. We do want it separated by year because we want the distinction between 2020 and 2021 because those are not, those are not the same. There's a continual time period from year to year. So what we're going to do is go down here. And this is where we can adjust. Now, just for the sake of things I'm going to show today, it gets very specific. And you can do it this way. And so on each day, you can do the percent population effect. And as you can see, it's going higher and higher and higher. That's not, that won't be that way. In just a little bit, that's summing the percent of all the countries. So we have it like this. You can also, whoops, we can also do month. And this is kind of what I prefer. It's just simpler to do it. It simpler looks. So look at it like this. So, you know, just the way it has it. And then look at it like this. It's just what I would consider a little bit easier. Okay. So you don't have to do it like that. Do it however you would like. Whoops. That is not what I was trying to click. So we want to break this out by each individual country. Okay. We don't want the sum. That's not what we want. So let's go down here and let's say average. That's not what we want either. Why did I do that? We want to break this out by the location, right? We want to break this out by country. Completely ignore the last like two things I just did. We want to break it out by location. And as of right now, this is a hot mess. They're all in there. Let's look at this one and Dora. They're all in there, but they look horrible. I mean, that's not what you want. So, you know, we can easily break this out by color. And it's starting to look a lot better. And look now, we have this legend that shows us which color is what. So I mean, we're already just killing. This looks 10 times better than it did just a minute ago. It still looks terrible. And we can limit this to specific locations. I think it's right up here. Let me see. Is it sort? I don't know if it's sort. Let me see. Let me see if it's location. Maybe it's filter. Here we go. So if we go, I'm going to restart if you didn't see that. So I'm just going to go to location. I'm going to do the drop down. I'm going to go to filter. And what I'm going to do is I'm going to look for a few specific countries. So I'm going to go to none. I want to do the United States as well as the United Kingdom. Let's do Mexico. We'll do India. We'll do China. And where else should we do? Any other places? No, I think that should be fine. Let's just keep it there. And we'll apply that. And we'll click OK. So as you can see, it's still summing it. Let's not go to some. Let's just go to... I mean, it's not wrong. It's just... Excuse me. It's just doing the max. I mean, let's see what the difference is between max and the average. It's nothing or hardly anything. You know what? For simplicity's sake, I don't want to get into all that stuff. We're just going to keep it with average. So it's going to... Over that month, what is in that month? What's the average in that month? If you use the maximum, it's breaking out by month. So what's the max in that month? Again, I'm not going to go into all that. Why we want to do it. Let's just stick with average. It's the... I think it makes the most sense. It's simplest. So what we have right now is it starts off at literally the January where almost no country's had any infection rates. And it slowly progresses. And as you can see, the United States, we're just unfortunately doing well in this category. And as of April of 2021, we have a 9.5. This is, by the way, the exact same data we used two weeks ago for the first portfolio project. If you want this to be current and upgraded, you're just going to have to get the new data and then update that in your tables to get the most recent data for May. So we have this and it's looking really good. There are obviously some things that we can do with this to make these better. Some things like, you know, we can add labels and excuse me. And if we do add labels really quick, why not? We'll add another location. Let's do label. Let's see what that looks like. So now we have the label on here. Looks, you know, perfectly fine. We can also do... Let's see. Let's see what else we want. Do we want to add the path? Because we could. Let's see what the path looks like. Oh, that looks terrible. Let me see if the order changes anything. No, just accidentally ate it. Whoops. Let's see what else we can get in here. So dimension. No, I'm just messing around real quick to see if I can find anything interesting. But the colors are auto-generated. You can always change the colors. Just remove this one. It didn't really add anything to it. So we have this and it looks pretty good. Now, something that we can do that's extremely easy is to add some predictive analysis or forecasting, like where are these numbers going to go in the future? So all you have to do is go up to analysis, go down to forecast, and just say show forecast. And that's about as easy as it could possibly be. At least, you know, I mean, it could be easier. That's about as easy as it's going to get. Now, I want to know, I want some additional information on here, just for me, myself and I. So I'm going to do this percent population, and let's do labels for these as well. Why is it saying 279? Oh, because that's the sum. Let's go over here, go to average. So now it's showing our numbers. So it went back to March, and then it's forecasting ahead. Now, if I shrink this a little bit to June when it starts ramping up, the forecasting will go away. I can do that. I can do an exact, oops, let me not do that. I can do a custom range. Let me see if I can. What am I doing? What on earth am I doing? Is it format? Let's take a look in here. I genuinely don't know where I'm looking right now. I'm trying to shrink this date to like June. And somebody out there who is watching is like, Alex, come on in. I'm like, yeah, I know. I really do get it. I don't remember where to go to do that. But that's okay. Just imagine shrinking it to like June, and the forecasting going away, because it needs, I believe, 12 months of data to be able to predict into the future. And these numbers look pretty accurate. It's predicting until March to the end of the year. And if I know the US, yeah, that's probably pretty accurate. So by the end of this year, it's projecting about 20%. It's very possible. And who knows? Who knows? We're starting to love Lough, right? You see this curve is starting to go down. Yeah, go straight back up. So this right here, I mean, it's pretty good. We're doing all right. So let's rename this. And let's call this Percent Population Infected. Now, this is just what I wanted to do. You don't have to do this. You can do, you know, whatever you want. If you want to make it look different, make it look unique. I recommend you just mess around with here. And we can mess with the tick marks as much as we want. I don't want to call it a month of date. That seems odd to me. I'm just going to type, I'm just going to do month. I don't know. It just seems better. So now we have our last visualization. And now if we go down here, that's another sheet. That's a new dashboard, which is new. So we have our new dashboard right here. Let's change the size. Just do automatic. Makes it the largest. And let's start adding things. I'm just going to start adding them because, well, I can. And then let's do, let's add this map. And let's add this. Just as a start, that's what we have. And it's already looking pretty good. I want this to come down next to this visualization or be attached to it. I'm going to drag it right here. Okay. This one I'm going to drag. Let me see if it will stay in here. Oh, that looks terrible. I'm just going to keep it there. I'm going to try to drag this. Let me see. How can I get this to stay up top? Oh, here. Let me try to extend this one. That's not really how that helps, to be honest. Okay. Getting closer. And let's scooch this out just a bit. Maybe even to here. Oh, that didn't work. That's not working. Geez, I am butchering this. Formatting in these things, I am not a fan of. But, you know, what can you do? Whoops. Let me go over here to drag. I'll do that picture. It covers a lot of countries. Okay. This is very close. I mean, we could get closer. But, I mean, this is about it. And let me stop right here and just say, if you've made it here, you're doing a really good job. I don't know if I went too fast or too slow or what I did. But, you know, we got the data into Tableau. We looked at our data. We then created each of the four visualizations and then put it into a dashboard. And as is, right here, we're pretty close. There's some things that need to be changed. So, we'll, like, we need some new headers and stuff like that. But, let's take a look. And this one needs to be, what are we going to call this one? This is the total deaths per continent. Just keep it simple. Keep it simple. So, I mean, for as quickly as we got, as we did this, is a fairly good beginner dashboard. There's so, so much that you can do with this. There's so much that you can do with this. And if I had three hours, four hours, five hours, you know, we could do that. But honestly, that would just be insane. In all, to be completely realistic, this did not take me an hour and a half to make initially, right? I had to mess with things. I had to readjust things. I had to go back and look at my queries. In all actuality, this took me a week. Or probably the more advanced one took me a week. And so, I don't want you to get this picture in your head that this is just only takes an hour and a half. Like legitimately, this could be weeks of work. To look at the data, make sure that the data is clean. To make sure that your visualizations do what you want. You may want to have some type of theme, some code theme, along the way. You know, there is so much that can go into visualizations that we have not even discussed that I will talk about in the series a little quite a bit more. There's so much that could go into this. And so, I don't want you to get the impression that I was able to do this in a short amount of time. I promise you it took me quite a while. Legitimately a week on and off working on it like an hour or two a night. Because I'm not perfect. I make mistakes. I'm like, oh, I messed this data up. Oh, I forgot there were nulls in there. Things that I polished up and got and told you beforehand because I made those mistakes when I was going through it. So, wanted to set that precedent now so that you didn't think that I was some genius because I don't want anybody to think that is not the case. So, let's keep going. We have now, let's say, let's just call this completed. Of course, there's more that we can do to make it better. This could be a little larger. And honestly, I should make that a little bit larger. Yeah, I don't know why I didn't do that. Make this a little bit larger. And so, now we're done. Now we want, let's say, say, okay, you know, I finished my dash where I want to share this to LinkedIn. I want to share this as a portfolio project on my resume. How do I do that? So, so simple. We're going to go to File. We're going to do Save to Public or Table of Public As. It's going to basically say what is it. And I'm going to say COVID dashboard. Let's say, tutorial. You don't write that. That's nice. Tutorial. I am, as you can tell, I talk to myself a lot when I'm spelling. It helps me sound things out. So, we're going to save this and watch the magic. It's amazing. It's saving it. It's saving it. And boom! It opens it up and there is your dashboard. Now, you get your own URL that you can literally copy and you can send to somebody and say, hey, look, I made this and they can click on that link and they can go to it. So, again, what is this? I don't know why it's doing that. Again, this is not perfect by any means, but I hope it showed you some of the concepts, some of the ideas that I had behind the data itself. I didn't want this to be three hours, which it was before, and so I condensed it. And maybe this is now like 45 minutes, which I would be super happy about, to be honest. The shorter the better, because I want people to be able to actually get through it and learn something and see how you can easily make a dashboard and be able to share it and it make a huge impact on your potential career. It really can make a difference. And so, I highly encourage you to make many of these. On my Alexi analyst, he's not going to get a job with one dashboard. Maybe. Maybe he is. Somebody really likes his current dashboard, but do two, three, four, five. This is your Tableau portfolio. Your portfolio for SQL, your portfolio for Python, those are going to be in GitHub and you'll need multiple of those as well. So, don't just stop here with one, okay? Let this be a starting place and then you grow from here. This should not, I don't think this should be your final product. It's not bad, but you can go further from there and improve on what we've worked on today and make it awesome. So, that is all I got. I hope this has been helpful. Again, I hope I didn't disappoint anybody by not doing like the three-hour one because there's that one guy out there like, oh man, I wanted to do the three-hour tutorial. Well, you're the only one. I didn't, I wouldn't have wanted to do my own three-hour tutorial. So, I hope that the people out there who are watching this who got this far were able to successfully complete it to get the kind of visualization they were hoping for. I really appreciate you watching this. I hope, again, I hope it was helpful. If you liked it, be sure to like and subscribe because I have a lot more content coming out with the portfolio series as well as Tableau and Python tutorials coming up and I will see you in the next video. Thank you and goodbye.