Build a Tableau COVID-19 Dashboard

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
[Music] all right thanks for tuning in everyone this is anthony smoke go check me out on that definitely hit subscribe YouTube as always if you learned something go ahead and hit that like button and make sure you so yeah we are in unprecedented times right now I hope everyone is social distancing and watching youtube from the comfort of your home I want to give a huge heartfelt thanks to all of our medical workers our delivery people our grocery workers you know they're keeping society functioning right now at the cost of their personal safety so so much respect our heart goes out to a New York City and and of course other places around the world in this video I wanted to show you a dashboard I put together using some of the the kovat 19 the Johns Hopkins kovin 19 data set that tableau has kind of put all together in one file right so there's three parts of this video I just want to quickly show you some of the functionality on this dashboard I'll show you where you can get the data and then we'll put together some of the pieces needed to build out the - but I'm not gonna build out the whole dashboard with all the formatting and all that stuff but you know just a quick kind of overview of how you put together some of these these pieces here so you can see we have confirmed cases through April 7th 2020 I've got confirmed cases and confirmed deaths and then I you know you can get a breakdown by a state or province same thing if I if I go to us it'll only show states here you know again heart goes out to to New York New Jersey everywhere around the country and if we do this right you can see how we can see the growth of our cases and our deaths over time you can see on the map China starts out with a huge lead or we look here in the bar chart and then other countries start to to catch up right us way out in front here as we're dealing with this this year but if you look at this on the on a linear scale here right the growth the rate of growth increases substantially already gives the impression that all of our hard work in social distancing isn't working but if we look at this on a logarithmic scale right even though the overall numbers are still increasing on the logarithmic scale as our access just increases by a factor of 10 every every time here you can see the point at which the rate of growth starts to level off sadly it's starting to increase more but that's what a logarithmic scale allows us to see allows us to kind of zoom in and see when that rate of growth levels off that exponential growth has stopped so again this is using the Koba 19 case is maintained by Johns Hopkins cleaned and organized by tableau so let's show you I'm gonna get out of this and I'm gonna bring up Explorer here I'm sorry Firefox I should say but this is a tableau side you can see the the link here and then once you go in here you'll notice that there is a access to the data right and then a CSV file I can use a direct download and when I do that it's gonna take me to data dot world so you're gonna have to make a login for data dot world to get this this data set if I go down here to kovat 19 cases dot CSV I can hit this download and it'll put that CSV file on my my laptop locally there's some metadata as well right so we're gonna be using the case type that helps us delineate between our confirmed cases and our death the cases which is a point-in-time snapshot you'll see what I'm talking about there here soon we've got our date you get the country you've got the province state for some of those countries and then it even breaks down into for us the county and then also we'll use the latitude and longitude right so let me let me break open a a tableau sheet here show you the data so this is data imported from data dot world that tableau has maintained you can see our case type we have debts and confirmed you'll notice we have cases and you have difference so I use the cases but again it's a point in time data right so for each date there's gonna be a case number so let me show you what what I mean by that so this is an example sheet that I have just kind of showing how the data is is laid out so I'm filtered by us and the state of Georgia that's where I'm broadcasting from and I have a date in here so you can see this is the first date I have it filtered by cases greater than than 0 so this is the first date that there was a a confirmed @ case here in Georgia in the data set so you can see the numbers go up but I can't just sum up all of these numbers because I'd be overstating right if I had two cases on the 3rd and I still had two cases on the fifth that doesn't mean I have six cases right I still only have two cases so I have to look at this data at at a point in time so as a four seven twenty twenty we've we've grown to 8800 confirmed cases and so it works the same you know with deaths as well right and even want to make sure that you do not select both because then you're overstating right so you don't want confirmed or or deaths right so we're gonna go with confirmed here I just wanted to show you that so let's put together the map now looking at the data you see we've got a latitude and a longitude generated so I'm gonna double click on both of those right that brings up a map and then what we want to do is want to bring our country our region into detail and that brings all of our data points there and then we want cases let's put the cases on sighs right and I'm gonna play with size here we're gonna bring to bring that up and we want to make sure so if we were to look at this you'll see us 3300 sorry three million three hundred thousand cases we know that is not that is not the case because we need to have a date on here right we need to have a date first and foremost we want to keep case type though right so I want confirmed only on here say okay and then for the date watch I'm not gonna put that on the filter I'm gonna put that on pages and so we want to make sure not year I want this to be the exact date and so what that's done is let me let me get rid of this hide card what that's done is it shown me a representation of the data on January 22nd 2020 and so what I can do I'm gonna pick fast speed here select show history I want to make sure the history is shown for all and if I click the button here you'll see that as time progresses for each date my data points increase in size so the page is shelf lets you break a view into a series of pages so you can better analyze how a specific field affects the rest of the data in the view right so as that date increases my size increases as well and you know again I said I wasn't going to go into a lot of formatting but I'm just gonna change the just show you that you can change the color and you can change the border here you know you can do whatever you you want to it here let me let me show you some some map options here map layers so you can play around with light normal dark right you can just have kind of different options here I'll go normal now once I've selected normal I can do this I can go in here and say format and I want to select the shading and if I go to the pane let's select this color here you might say okay nothing has happened and so what I need to do now if I go to map layers and take off the base and the land cover you can see let's turn on the coastline and our country-region borders you can see I get this this color of my choosing for the map so not a lot of people know that you can do that just because they may have the land cover or the base on here so you can leave the land cover on if you wanted to but it's that base that that covers up your custom color so just keep that in mind if you kind of want this this look right here so we've we've done the map let's do the line graph of our confirmed cases right so let's take again we always want to take with this data set we're gonna take our case type we know that we want this to be confirmed we're gonna say okay there and let's drag the date to two columns all right and I want that to be B so I'm sorry I want this to be the exact date so I get that there and so I can bring my cases two rows right you see we get that that linear chart here and then Lana graph and I want to hold down control and I've got two here and so what I have is I have one believe that's this top one and then this bottom one so on the bottom one I want to change that to an area right and then once I do that oh I've already must have pre hidden hidden my my axes here so here let me turn this on we've got show header show that header there we go so so that comes back so what I can do now down at the bottom I'm gonna say dual axis right so that gives me those two axes right here and I always say synchronize just to make sure I don't need this one right here so I'm going to unselect show header right there right and then what we want to do now I can I can edit this axis right here I'm gonna come in here and I'm going to let's get rid of the cases and on the tick marks I'm gonna make this zero go fixed zero to three hundred three hundred thousand okay so so we have that I can play around the top here I can play around with the size of the the the line graph here the outer line if I wanted to and so the key on this right if I bring in once I bring in the date two pages right that's the key and I want to make sure that it's again exact date okay where did everything go right just hide this where'd everything go I'm going to show my history I'm gonna make sure that it's all here and so now if I go through here you can see I kind of lost that area but it puts this little line here as it progresses through and that's how how I did the the growth of the confirmed cases and I know worldwide according to the the data center about 1.4 million so I'm gonna go ahead and keep that and so obviously with formatting you can turn off borders you know it's always interesting trying to find the right places to to turn this stuff off in tableau so I'm going to say none that turns that off so that's that's my borders and I can come in here two lines make sure my grid lines and 0 lines are not showing as well so I like this fresh and clean look and then obviously I can for the color if I'm on all it will change the color for everything but I'm just gonna change the circle here I just select that right we just get this this this result right here I can again play with the size if I want a bigger from one bigger marks or not anyway that's how we get I don't need two dates in the tooltip but that's how we get this this line graph here right all right so let's move on to let's do bar charts all right before we get off a confirmed cases just wanted to go back and show you that if you edit the axis this is how you change to a logarithmic right if we change that the axis here to logarithmic this is how our data's gonna look so that's how I got that log that logarithmic axis on the dashboard we can change it back as well just wanted to show you that and then obviously if I wanted to I could change this to circle and then have more control over the size here right but I typically leave this as line you know when you throw it on the on the dashboard it just behaves a little better but again that's just a personal preference so let's go over to the bars here so we're gonna make the the bar chart the first thing that we have to remember is we need to put the case type on the filter because we want to show our confirmed cases so I'm gonna say okay there and let's bring a sum of cases over here to columns and then let's bring our country and region over here to rows and you'll see we have a number of countries here I'm just gonna apply a filter and we'll put the cases on the label and you'll see that these these numbers are not correct right because we need some sort of date all right this is point in time data if you don't have a date it's gonna sum up everything incorrectly so there's two things I want to do because I only want the top 10 not based upon this this wacky wrong number I want the top 10 based upon he confirmed cases on my max date which is April 7 so you know in order to to put that filter on here to get the top 10 let's do this I'm going to let's go to filter and you know this is a little bit of uh you know a little bit of cheating a little bit well not really engine let's call it engine which I'm going to put this formula in here so what we need is I only want the top ten country I only want to some of the cases for the top ten countries right so I want a sum of cases if the date is April 7th 2020 that is the maximum date in my dataset and the case type is confirmed right if those two conditions are met right the date is my max date for seven twenty twenty and the case type is confirmed then some cases right and I want the top ten countries that meet that criteria so there the reason why I say it's cheating is because I don't like hard coding I tried using a max in here but it will give you an error you can't mix an aggregate and non aggregate you know items together so you know if you out there you know hide my mentality you know wisdom of the crowds if you know of a way for me to dynamically get that in here without me having to go in and change this hard code this to a date I welcome that feedback please put it in the comments right so we can all learn from it so I'm gonna say okay and what that does is it brings me right back those those ten countries and I know that that this is wrong information at least that's showing here the the filters right but what's showing is incorrect because we don't have a date in here so our date filter is essentially gonna be our page right if I bring the data up to pages and I say exact date now when I look at this right go to here to show history all make sure you do that and then say ok we can watch this grow and hopefully that shouldn't get four million like I did previously all right we see China stall out and then the US comes on 396 oh six nine if I go back to my dashboard for a United States 396 oh six nine so I know that that is the right number and so now how do you get the sort right when I saw it it's it's sorting by cases not on a particular date right it's sorting by that that wrong number that we showed in the beginning where China had four million right I'm going here to label and show allow labels to over lap each other so I can see everything so again another little cheat here that I do for the the dashboard I can go in here I can do a sort right but I'll do a manual sort yeah I know you know it gets the job done so I just have to kind of take a look so I'm not gonna put you them here I'll do one I'll bring the u.s. up top right and then we know coming in at number two here I can just take a look I can see it's Spain and Italy right so if I get on here and select Spain and then Italy and I'm not gonna put you through watching me do the other sort I'm just going to do it really quick all right so magically I have manually sorted the countries in the order of confirmed cases here at Gantt if I if I needed to move something you just kind of kind of push it up there and you'll see in the visit that it changes places that's all I did fairly fairly quickly here so I have that in place you know I can do entire view here you know I like to get rid of this I like to do the formatting and make everything clean here so let's go to make sure we have no gridlines change that right so I like that clean look and then you can keep a consistent color so that's how we do the the bar chart so like I said it's a little a little bit of a workaround in that I have to hard code in the max date and I do a manual sort based upon the date based upon just kind of eyeballing once I put in the date filter so last but not least the band you know bands and tableau you know I do tableau I do power I like bands in power bi it's a lot a lot easier to do but you know it's it's not horrible in in tableau again start off with the case type here in filters go with confirmed let's drag our let's just drag our data pages right now change it to change it today right and then I want that to be right not day I want to make sure it's exact date because when you look at these you want to make sure all of these are date are not exact date because you throw them on the dashboard it's going to you need to synchronize all of these pages and it's gonna be looking for the same field so make sure it's it's date make sure they're consistent right so once we've done that I can take cases here some of cases and put that on text and you'll see I get a number here right and as I if I change it go all the way top I get that one point four to five and so now it's just a matter of going in here right and you know I can say something like confirmed cases sure I don't do that let's go with a font of 12 and for my summit cases let's go let's make that a little bigger here let's go 18 right and then I can again make that consistent color here let's go with fancy apply okay so we have that I'm gonna hide the title I don't need that and then back in here if I go to alignment is that is that where I do the alignment no that's not where I do the the alignment here if I go to that is where I do the alignment just have to go entire view sorry so yeah once I got an entire view that is going to show up and obviously I can change the background color of this as I want so as you can see we've gone through kind of the different examples we've got the map here we've got confirmed cases our bar chart and we have our band so in order to make the instead of confirmed cases we could again change all of these filters over to I show the filter if I needed these to be deaths instead of confirmed cases right that's all I have to do to switch that over there a little bit of a change here you would do the same thing here you show deaths but you would just have to make sure that when you change the if I say edit the filter you want to make sure that your case type is deaths right here and then you would just redo that that manual sort simple here just change this over to two deaths instead of if I show the filter change that over and that that represents deaths now and so once you have all of those pieces all you have to do is throw it in on a dashboard right so again it takes it takes some formatting I'm not saying it doesn't take any formatting but it takes some formatting to kind of get it look like this and arranged like this if there is interest I may show another video on you know how you bring these things together how you get the logarithmic and the and the default axis into one container I may show something like that if there is interest just you know leave leave your comment down below if you think you have an interest in that [Applause] but you know how to do pieces and you know where the data is so I would say you know get out there do some great things with your data and please please please it's been Anthony smoke thanks for watching [Music]
Info
Channel: Anthony B. Smoak
Views: 91,569
Rating: 4.9251614 out of 5
Keywords: Tableau, Anthony Smoak, Business Intelligence, Data Visualization, Tableau Tips, Tableau Charts, Tableau dashboard, tableau dashboard design, tableau dashboard actions, Tableau bar chart, Tableau Public, Tableau Youtube, Tableau Training, Analytics, Coronavirus, Dashboard Example, Tableau Project
Id: mvpGTXRLIQc
Channel Id: undefined
Length: 23min 44sec (1424 seconds)
Published: Thu Apr 09 2020
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.