 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 dataset 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 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 will 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 what 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 in 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 the 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 use 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 that's 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 in 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 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 low table one and replace for me because I already did that one let's go back and I have 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 um the tablet table two I think this is a good learning experience good bonding experience for all of us if you do this with me then we that means we've seen stuff together man and gals um so this one control shift c is going to be our tablet table three all right oops oops oops what am I doing I need a new one um so something you need to look out for and something that we didn't have to look out from 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 um if you look I already have this um 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 um because then it will be numeric and it'll sign it a numeric uh data type and so what we're going to do is we're going to do control h and that's just habit 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 um we'll do that well no we'll go to zero replace all and we should be good to go this should fix uh any issue that we might occur or 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 watch this in the first place um so stick around because we have to do this in the next one as well um so we'll do file we'll do save as download so do table three 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 um and as you can might may be able to tell now they don't um and that's because you know 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 um 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 drop down after clicking on the 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 5000 done um let me make sure because I thought there were more than that um 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 uh once we save this we have our four uh I can't talk at the same time I can't talk and type table 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 tableau and then we need to start building our visualizations so pull up tableau with me uh click microsoft excel and we're gonna go to table one and we're gonna open and this is exactly what we had before this is our table one now we don't want to uh 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 you can do it here um I'm for sake of what we're doing I'm just going to go to sheet two go to um this this one right here it says uh new data source go to microsoft excel and we're just going to do this for all of them so we're gonna do um we're gonna import it we're gonna 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 uh I'm gonna do it like that um all right and then four we're gonna add it and now that we have them all opened up what I'm going to do now is I'm gonna cut myself off the screen because you don't you don't need to see me anymore and I'm gonna I'm honestly I'm gonna get in the way um because we're actually gonna 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 wherever I am um so thank you for sticking with me I'm gonna 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 uh we are gonna get started now the very first one that we're gonna do is by far the simplest um it's extremely simple um let me show you we're gonna be looking we're gonna be doing this one right here okay so the uh these global numbers with just these colors and 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 uh oh 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 um we'll make that a column uh total deaths and death percentage now of course this is not how we want it visualized at all um 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 let me click on it so right down here oh 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 um that is what we have now and we want to move these measures right up here into the columns um 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 um let's expand this just a little bit so we can see each one perfect um there's a few things that we need to we need to change in here um to make it just more user friendly make it look better um 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 um and and make it look a little nicer and then we'll do a little bit after that so you know you can 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 you know 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 um you can also change the size um 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 um and let's pull this down a little bit um 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 uh not super important um 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 um this uh with the rows in it so we can do this I like it a little bit lighter maybe like that I think that doesn't look bad at all um so there's a lot that you can customize in here um you can even do grid lines trend lines let me see maybe we want to do something like this I mean I I personally like um doing some sort of lines like separate these out but we don't have to but I'm gonna I'm gonna try to do a little bit um no not try line 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 a really good this looks very similar to what I did originally and I think this will be good to go for now um 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 um we have already completed the entire dashboard but we're gonna 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 two as in two percent but it's rounding to the nearest whole number and for death percentage we want to be a little bit more accurate than two percent maybe two point one one zero three or whatever that number is we want to be a little bit better um and so I think we want to go to the two decimal points or the or the you know two point one one uh which is what the number will be so the first thing that I'm going to show you is how not to do it um 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 um 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 you know specific as you'd like I'm going to keep it at two four um at the end of the video you're going to see that it says two uh 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 go to table two so what we're doing in this one is we're going to be creating and I'll go back here to show you where you're creating this graph right okay that's great you have a second um we're going to be carrying that bar graph that you just saw um and I'm not going to wait for it it's if you look right here the small bar graph um that's what this one right here that's what we're going to be making right now this one should I believe the the second simplest I kind of did them in order of simplicity um 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 um 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 um 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 um the previous thing so super super close already um 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 um or do what I just did you know go for it but I like the simple look of 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 um so something that I want to do that I personally like doing is going is ordering them by highest 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's before Asia there we go let's exit 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 um 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 let's do um continent is that a useful continent yeah it's a useful continent perfect and it changes up here um super easy um if we do go if we do this right here and we oops 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 um I like to keep it pretty moderate just a normal one I don't I'm not I don't want to get too crazy over here all right I'm just trying to trying to help so if we do the color you can do lots of different colors um and and you can uh you know you can do it in like an ascending order uh 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 um you can keep a theme in your tableau dashboard which will be something that I probably talk about in my tutorials um speaking of something I have not mentioned 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'm 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 um 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 you know I I did that backwards I you know 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 um 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 um the colors you can do a lot with if you want to I I personally just want to keep it how it was I'm just doing control z I'm just going to keep it like this not getting anything not doing anything too crazy not doing anything fancy um 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 um so we have this there's a few other things that you may consider doing speaking of something like like this you can enter this access now as of right now it's doing tick marks or I think I'm going to call them tick marks they are they are called tick marks of 100,000 okay you don't have to have it like this you can change it and customize it however you want so you know 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 you know that's just a million so that's what's going to look like with a million over here um 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 you know it's going to it's going to look how you make it look okay I'm just going to keep it with the automatic again um not because it 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 um and and visualization so that should not be crazy hard to read so that is the end of our second visualization we're going to move on to our third one and arguably my favorite which is the map um 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 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 the location as you can see these are all countries now it's not going to open up these map options and to show me it's not going to open up the those map options because um 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 this is part of a geography this is something that you should be looking at um differently so we can change this and we go we're going to we're going to click on this little drop down I'm going to go down right here to geographic role and we're going to go down to country region and let's click on that and as you can see down here they just generated some loud 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 sneezed it is allergy season for me my goodness it is not pretty over here um so we have the longitude and latitude um 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 um automatically um it really quick if you want to do the pan you want to be able to like reposition it that's what I want to do reposition about right here uh you just click on this arrow click pan this is how you like select multiple I don't really need that so I keep it on the pan for most part anyways now this is where we need to um insert like 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 and I want to make um I'm going 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 is because it ruins everything um that's why I want to add it right down here and that's fantastic and 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 um so you know this is a lot more along the lines of what we were hoping for so this is looking really really good so um there's a few things that I you know want to mention or talk about before we actually start moving into this one tablo has their own whole section called map up here um 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 um it whoops it adds a little bit of depth a little bit of um 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 got a lot brighter um something that you know you can do is add something like a label and before that would have made sense um 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 uh 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 um go over here go to label and then adjust that label to how you like it I think that is perfectly acceptable um now these colors aren't to my taste as you can see over here we have this um 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 whoops by going to color clicking on that going edit colors so um I don't know why I pulled it over there I'm gonna pull it back doesn't make sense it's I personally like reds oranges um 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 uh 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 sake of um what we're doing you can do something like this and again it's the personal taste okay so if you don't like this one don't use it I I don't want you to use it I want you to find one that that really looks good to you um and just know that anyone that you choose you'll still have this right over here okay so you should be all right let's do 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 it's a row but you know 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 uh 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 um all right I think 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 a 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 and I can do you know 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 um you just have to add multiple things that that marks uh teachable moments just trying to try to keep it kind of keep trying to keep the learning alive um let's go on to 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 um 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 um so what we need to do is we need to bring over the date and we want that to be on our um a column because we want it to show the progression over time uh 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 um and look it already tried its best to create something um and and it really did it tried its best um 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 um 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 um but let's let's do this really quick let's put month um it's breaking out by month um and now I'm regretting making it larger um if you notice it doesn't have 2020 or 2021 in here at all um it just has January, February, March, April, May and June, July so it's breaking it out per month um let me go back to make it small again it's breaking it out per month and that's not what we want um and we don't quarter either we want to have it by year we 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 can 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 day and it gets very specific um and you can do it this way um and so on each day um you can do the percent population effect and as you can see it's going higher and higher that's not there won't be that way um in just a little bit that's summing the percent um of all the countries so you know we have it like this um 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 look so look at it like this so you know just the way it has it and then look at it like this um it's just what I would consider a little bit easier okay so you don't have to do like that um do it however you would like um whoops that is not what I was trying to click so we want to break this out by each individual um country okay we don't want the sum that's not what what we want so let's go down down here let's say average um that's not what we want either why did I do that um 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 um and as of right now this is a this is a hot mess um they're all in there let's look at this one andora they're all in there but they look horrible um I mean that's that's not what you want um so you know let's we can easily break this out oops by color and 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 um this looks 10 times better than it did just a minute ago it still looks terrible um and we can limit this to specific locations um I think it's right up here let me see is it sort I don't know if it's sort um let me see let me see if it's location maybe it's filter here we go so if we go I'm gonna restart if you didn't see that so I'm just gonna go to location I'm gonna do the drop down I'm gonna go to filter and what I'm gonna do is I'm gonna look for a few specific countries so I'm gonna go to none um I want to do the United States as well as the United Kingdom um let's do Mexico we'll do India we'll do China and where else should we do um any other 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 okay so as you can see um it's still summing it let's go ahead doesn't that go to sum 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 uh or hardly anything you know what for simplicity simplicity sake I don't want to get into um all that stuff we're just gonna keep it with average um so it's going to over that month what is in that month what's the average in that month if you the maximum it's breaking up 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 that 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 there's you can see the United States we're just unfortunately doing well I'm in this category and as of April of 2021 um you know we have a 9.5 this is by the way this is that 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 and and um update that in your tables to get the most recent data for may um 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 um you know we can add labels and and excuse me um and if we do add labels really quick why why not we'll add a locate 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 um we can also do let's see let's see what else we want um do we want to add the path because we could let's see what the path looks like oh that looks terrible we see if the the order changes anything um no it's just accidentally ate it whoops um let's see what else we can get in here um so dimension no I don't I'm just messing around real quick to see if I can um find anything interesting um but the colors are auto-generated you can always change the colors um 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 pr predictive analysis or forecasting like where are these numbers going to go in the future so all you have to do is go to analysis go down to forecast and just say show forecast and that's about as easy as it could possibly be um at least you know I mean it could be easier that's about as easy as it's going to get um now I want to know I want some additional information in here just for me myself and I so I'm going to do this percent population um 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 okay so now it's showing um now it's showing our numbers okay so it went back to march and then it's forecasting ahead now if I shrink this a little bit to like june when it starts like ramping up the forecasting will go away um I I can do that I could do I can do an exact oops let me not do that I can do like a custom range um let me see if I can what am I doing what on earth am I doing um is it format let's take a look in here uh I genuinely don't know what I'm looking right now I'm trying to um 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 um I don't remember where did I go to do that um but that's okay just imagine shrinking it to like june and the forecasting go away going away because it needs I believe 12 months of data to be able to predict into the future um and these look numbers look pretty accurate it's it's predicting till march to the end of the year um and if I know the US yep that's uh probably pretty accurate so by the end of this year it's projecting about 20 percent it's very possible um and who knows who knows we're starting to love loft right right you see this curve it's starting to go down yeah I'm gonna go straight back up so um this right here I mean it's pretty good right we're doing all right so let's rename this let's call this percents population infected now this is just what I wanted to do you don't have to do this you can do um 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 um I don't want a whole 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 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 uh let's change the size just do automatic makes it the largest um and let's start let's start adding things I'm just going to start adding them because well I can um and let's do this out of this map and let's add this just a 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 um we'll stay stay in here oh that looks terrible I'm just going to keep it there I'm going to drag try to drag this let me see how can I get this to stay up top oh here let me um let me try to extend this one that's not that's not really how that helpful 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 um formatting in these things I am not a fan of um um but you know what can you do whoops let me go right here to drag picture covers a lot of countries um okay this is very close I mean we could get closer but I mean this is about it uh and let me stop right here and just say if you've made it here you're doing a really good job um I don't know if I went too fast or too slow or what I did but you know we got the data into tab low we looked at our data we um we then created each of the four visualizations and then put it into a dashboard and as is right here we're pretty close right there's some things that need to be changed um 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 um 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 um and if I had three hours four hours five hours uh you know we could do that but honestly that that would just be insane um 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 um I had to readjust things I had to go back and look at my queries in all actuality this took me a week um or probably the more advanced one took me a week and and so I don't want you to get this picture in your head like this is just only takes an hour and a half like legitimately this could be weeks of work um to look at the look at the data make sure that the data is clean to make sure that your visualizations do what you want um you may want um to have some type of theme some code of 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 um a little quite a bit more there's so much that could go into this um 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 um legitimately a week on and off working on it um like an hour or two at night because I just 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 you didn't think that I was some genius because I don't want anybody to think that is not uh 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 um this could be a little larger um and honestly I should make that a little bit larger yeah I don't know why I didn't do that make it a little bit larger and and so now we're done now we want let's say say okay uh you know I finished my dash where I want to share this to LinkedIn I want to share this as a portfolio project in on my resume how do I do that so so simple we're gonna go to file we're gonna do save to public or tablet public as it's gonna basically say what is it and I'm gonna say um I'm gonna say COVID dashboard let's say tutorial you don't write that that's nice tutorial tutorial I am uh as you can tell I talk to myself a lot when I'm spelling helps me sound things out so we're gonna 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 um 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 um again oh 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 um I didn't want this to be three hours which it was before and so I condensed it maybe this is now like 45 minutes which I would be super happy about to be honest I'm the shorter the better um 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 right on my on my alex 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 um this is your tablo portfolio right your portfolio for sequel your portfolio for python those are going to be in github and those you'll need multiple of those as well so don't just stop here with one okay let this be um a starting place and then you grow from here this should not I don't think this should be your final product it's it's not bad but you can go further from there and and improve on what we've worked on today and make it awesome so that is all I got uh you know I I hope this has been helpful I you know I 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 um to get the kind of visually visualization they were hoping for I really appreciate you watching this I hope again I hope it was helpful uh if you liked it be sure like and subscribe because I have a lot more content coming out um 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