Tableau MasterClass: Build and Publish COVID-19 Dashboard | Data Visualization Intro | Dee Naidoo | Skillshare

Tableau MasterClass: Build and Publish COVID-19 Dashboard | Data Visualization Intro

Dee Naidoo, Data Nerd

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
12 Lessons (1h 48m)
    • 1. Introduction to Tableau

      1:18
    • 2. Installing the Free Full Version of Tableau

      1:46
    • 3. A quick note

      0:34
    • 4. Creating the COVID-19 Datasource

      5:12
    • 5. Getting the Google Sheet Link (Check About Section)

      2:28
    • 6. Connecting your Data to Tableau

      12:33
    • 7. Preparing your Data for Analyzing

      7:28
    • 8. Auditing your Data

      8:30
    • 9. Creating Charts on Tableau

      21:23
    • 10. Creating Calculations on Tableau

      26:25
    • 11. Building a COVID-19 Dashboard

      17:13
    • 12. Publish your Dashboard to Tableau Public

      2:50
16 students are watching this class

About This Class

We are living in a data world right now. And, as a Data Engineer practicing in the real world, I know there’s a wealth of information out there that many people and companies don’t know what to do with!

This course will introduce you to Tableau, a data visualisation tool which enables you to create beautiful dashboards quickly with little use of code. Data visualization is so important as you are able to ingest and understand data based on trends and patterns.

This Introduction to Data Visualization will help you build a dashboard as the one below on Tableau!

b1f79141

What you'll learn:

  • Create a beautifully designed dashboard about the Coronavirus
  • Share your dashboard online for the world to see
  • Connect to real, live data through Google Sheets
  • Perform calculations on Tableau
  • Build graphs and learn how to format them

By the end of this course, you will know the fundamentals of Tableau and building modern dashboards. You can even add a link to the dashboards in your resume!

Links:

Link to Google Sheet:

https://docs.google.com/spreadsheets/d/1VXj2h0qLF3kIVulVSCOG1L6oVdc81IA9kzqyDyXhDcA/edit?usp=sharing

Guide to Dashboard Best Practices
Download Tableau (Free 14 day trial)

The project brief and the lesson "Creating the COVID-19 Datasource" covers how to create a datasource.

Also, check out my other class on Skillshare:

Transcripts

1. Introduction to Tableau: Hi, everybody. Welcome to my course. So covert 19 has sort of turned the world upside down, and the one thing we need more off is data, and the best way to view data is through dashboards. So in my course, we're going to do exactly that. We are going to bolt some really called dashboards about the covert 19 crisis and the really cool thing about the dashboards as they are going to update every day, and you can share the link with family and friends. As you can see, these dashboards are in directive your user can filter by date. Have a look at the top 10 countries with the most number of cases and the top 10 countries with the most number objects. We will create a world map as well as a graph displaying the cases per day. We also create these really handy headline cards that display the total cases, the total deaths, the mortality rate and the growth since last month. And we learned but more about publishing on tableau public, where your friends and family can view the stash board that gets updated daily. I've also included a bonus model where we analyse Trump's tweets using a tableau dashboard , so that's pretty cool as well. Anyway, I really hope you enjoy this course. Let me know your feedback and I will see you in the next lesson by 2. Installing the Free Full Version of Tableau: Hi and welcome to this. Listen, So this is just a little clip so we can install tableau and get it up and running. So open your Web browser and type the link. Www dot tableau dot com slash products slash tile So that's tableau dot com slash products slash trial. Right, And this is actually tableau desktop. It is the 14 day trial, and it's free. So it is the tableau with the full capabilities. So what you going to do is into your email address. You can use any email. It doesn't have to be a business email and click download free trial. Now just do not. If you are a student or teacher, you can get a one year free license if that applies to you as well. But I'm not a student or while technically, not a teacher. So I'm just gonna click download free trial, and we're good to go. Okay, and as you see, it shows up in your downloads. Its around 472 megabytes onda. Once the download is done, you can just double click on it and follow the instructions to get tableau up and running. So that's it's um I hope everything is set up for you. And in our next listen, we'll learn a book more on how to connect a data source to Tableau. So see, then. 3. A quick note: Hi. So this is just an early warning sign that the next listen where we create a covert data source, it doesn't work anymore. I do explain why in the listen following that, but just a warning that you're welcome to skip the lesson. However, if you do on to learn how to use import functions in Google sheets than I recommend just watching it to get some mom knowledge and I do provide a solution on how to connect to the covert data in the lesson following that cool see there by 4. Creating the COVID-19 Datasource: Hi, guys. Thank you so much for joining me. So in this lesson, we are going to create our data source and we're going to do that by importing a U. R L into Google sheets. And then we can connect our tableau workbook to that Google sheet. So before we get into it, let's just recap our dashboard. So just to summarize out into goal, this is the dashboard that we are going to be creating. And I think there's two main sitting points off this dashboard. The 1st 1 is that the data updates daily, and the second point is that you get to publish it on a public platform and you can share the links with your family and friends. So in order to create this dashboard, we need to connect to a data source, which updates frequently, and the state of source needs to be on Google sheets because tableau public will only be ableto update this dashboard if its data source is a Google sheet. So what we're going to do is we are going to create a data source on Google sheet and then eventually connected to tableau. So let's get to it. Okay, So in this project brief, which is attached in the resource is diction. You will find this link over here. Okay, so this is the you open data portal, and it actually has updated covert 19 data on a text file, so we're going to use it. So I want you to click the link. Okay? So you'll get taken to this page, which, as I've said, is the you open data portal and we all going to never gate down over here where it says additional information. And I want you to copy this link. So right, click and say copy, link address. Now, if you click on this link, this actually downloads thetacticsroom while for you. But we don't really need it. We just need with the link. Now, if you click on this link, it actually downloads the text 12 for you, but we don't need it downloaded. I just need the link. OK, so let's open a new tab and let's type in doc's dot google dot com. Okay, let's never get to spread treat. So click on the hamburger, many on the top left and go to sheets and it's quick blank. So this plus sign. Okay, Cool. So let's just name the spreadsheet. So call it covert 19 data and click on the cell A one. Now we're going to write a formula. So Google, she tell with these cool functions called import functions. And what you can do is import data from a link. Essentially. So Chris equals and import data. Open records, quotation mark paced. So, control V Command be quotation marks again. Enclosed records. So this import data can only take CS avi files, so just be aware of that. And click enter up now. It might load for a while. Maybe a minute or so, maybe ISS. Okay. Awesome. So you can see how useful this is, because now we can use this as a data source and connect our tableau filed to it. So before we move on, I don't know what's happening yet. It's converting dates to numbers. So let's just change that. Selected the a column and where you see you. 123 Here, click it and just change it to date. Okay, Great. Now let's go to the top, right? And Wade says she click it and you're just gonna get the share a building Once you get the link, maybe double click here and just say off. Only specific people can access. Okay, copy Link, and we're done. Okay, So what the sheet does is that it import data from the U data portal and brings it into the Scougall sheet, and I think it does it every hour. All right, so this was just a quick lecture on how to create your data set through Accessing a C is we link. And whenever you do this, just be weary and make sure that the links that you're accessing our from proper data sources Okay, So let's end Offiah. We've created our data source and are we ready to bring it into tableau? So I'll see you in the next lesson by 5. Getting the Google Sheet Link (Check About Section): Hi. Thanks for joining me again. So just a quick update to this. Listen, it's I think the 14th of July 2020. Um, and usually at the stage, students would create a data sit using the you open data portal and Google Sheets. The problem is that now we're quite a few months in the pandemic, and thus the data set is actually getting larger. And the traditional way that I've designed this course to draw data doesn't walk anymore. So what we're gonna be doing is just using my Google sheet, which is here to connect to your data source on tableau. So what you going to do is you are going to copy this link. This link will be available in the course description below, so make sure you copy it and open tableau, right to want to open tableau. You are going to connect to a data source. The data source that we are going to connect to is Google Sheets. So once you click on it, if you cannot find Google sheets here, you click more and such foot, they'll be Google sheets over here. So click on it now, once you gonna click on it. It is going to ask you to authenticate the browser. So make sure you do have a Google account and you gonna sign in. It's gonna ask you for access, which is fine. Click allow. And it's that in. So it's gonna ask. You can close the browser. I just leave it open and let's open tableau again. Okay, So once you open tableau, you see there's this new window and wait Say's such by sheet name into your Well, this is where you gonna pastry link. So come on to control we and pick such Okay, so you can see it comes up and you're gonna click Connect, And now it should be connecting. So that's how you connect to the database by a Google Sheets. I will update the state, uh, as much as I can, hopefully at least a few times a week. So you will get updated data and I'll see you in the next lesson by 6. Connecting your Data to Tableau: Hi, guys. Welcome back to the listen. So in this last listen, we have created our own data source. It's on a Google sheet, and it's ready to actually be connected to tableau. So let's go ahead and copy the link so you can click on the top toolbar and just control. See it and open tableau. Okay, so when you open tableau, this is the pain that you see, and I'm just going to give you a quick tour on it. So on the left is all your different connection options. The good thing about tableau is that it has a lot of connection options. If you own a server, you can connect to Temple several. You can connect to aesthetic files such as Excel files, text files and Jason files, and here is where you can connect to your servers. So this includes the AWS cloud databases, snowflake, red drift, Google sheets, which we will be using soon. And there's much more. So if you click on more, there's actually ah, hold on of connection options. Now, Tableau does have some saved data sources, and these air sample data sets that you can use if you playing around tableau. They're quite cool, so I encourage you to have a look at them. What these save data sources is also sample workbooks as well, and these are designed really nicely. So also, when you have a chance, have a look at them and on the right inside is where tableau has some important notices. Training, content and resource is, and also, if there's any updates, I should update soon, but I've just been very lazy. Okay, so let's connect. It is a Google sheets, so that is what we're going to be connecting to. If you can find Google sheet here, just click more and such for Google sheet and then click it. So now it's going to ask you to authorized Have though desktop on your Google account. If you don't have a Google account, you can create one. It's free. I do have a Google account, so I'm going to sign in. And now it's going to ask you to authorize tableau desktop on your Google account. So pick allow. Okay, that's it. You can close the window if you want and go back to tableau. Okay, so when you on tableau, you are greeted with a new pain because you are signed into your Google account. It actually access is all your Google sheets. So you can select the Google sheet that you created in the last Yes, and or if it's not showing up, then you can into the link here and search for it. And that's it. And once you selected, we are going to click Connect, Okay, And now you're in the data source window. Sometimes it may take a few seconds for tableau to execute the query. Let's take a quick tour off this. Okay, So this window is just all about the data that you've connected. So usually the connections show here, and if you need to add anything else you can, so you click, add, and you can select whatever connection you need to bring in. We are just using this one cheat. So we're good this option off using a data interpreter. So this is quite handy, especially if you have some Missy Excel sheets. For instance, when you working on an accelerant port and someone puts emerged role with the title of the report, if you bring it into tableau as your data sources probably gonna miss up with the column names, but the data interpreter can decide and structure your data and cleaning that data set, which is quite handy. And here it has a sheet name. So on our covert 19 data source, our one sheet was called Shed one. We are going to change it soon, and there's New Union. Okay, so what is a union? So let's just say we had multiple sheets and each sheet represents a month off data off the Corona virus. We would be able to append each sheet by using union, but because we have one sheet, we don't need to do that. Additionally, this is where tableau joins happen as well. So joins a quite popular in sequel to Blow Dozen as well. If you need to join related tables to a data sit, all you do is you add your data sit, and you can bring it into this pain. Now, if you guys are more interested in tableau joins, I have included some slides there for you to have a look. I would love to show you guys an example of joins, but we can't join anymore sheets. Otherwise, our data source isn't going to update on tableau public. So we're just gonna stick to one sheet for now. Okay, So first literary name the data source. So let's just call it covert 19 data. So click on it and it's green and the sheet one to say covert 19 data. So what you do is you hover over it and double click, and now you can rename it. Obviously, this is not essential to rename, but it is good practice we to get into the habit. Okay, so let's move on. They are two different views. You can look at this. You can look at this with a normal table view, or you can switch to just view headings. Click on this icon and I will just tell you the column name the table it's from and the field name. It's switch back, and you can also order the column. So this is just how they appear on a global sheet. But I usually like sorting it a to Z ascending. So that's what we're going to do. Click on data source order and say A to Z ascending. Okay, let's have a look at the actual data. So this represents the number off cases It's cold cases and we know it's from DeKoven 19. Data sit and you can notice in each column disease, little icons. And this just represents the type of column. So cases is a number, and it's a number hole that makes sense. We can't have 15.1 people with Corona virus. Okay, The next column. This looks like continent. It says Continent E XP. So we should rename it. But we won't at the moment, and the type is a B C. So if you click on it, the type is a string. Now you can't change it. If you do notice it's assigned an incorrect type, it does happen. But I think all the types are correct, que countries and territories. So this just looks like normal country, and it's assigned ABC again country and territory. I think these are just codes. Okay, date to rip. So this is probably the date the count was taken Day. So this just represents a day off. The date dips. So this is the number of deaths that happened on that day, G E. Old. I'm not sure what this is. Obviously, it's relating to countries probably a country short code month. So this related to the month off the date and pop data 2018. So this is the population off the actual country, which is quite cool, and we are going to use it. It's as off 2018 which is fine and finally year, and that's the year off the date. So they are some fields that definitely need to be renamed, and they are. Some fields will be probably on going to use, and the fields are. We know that we definitely not going to use its get rid of them because we don't want a cluttered workbook. So Fergie old we can get rid of this field to get rid of this field. Click on the name, and when this aero shows up, click on it and say Hide and it's do the same for country territory code. Because we have a full names, we don't need a code, so click on it, click on the arrow and hide. So now we won't be able to analyze data on those two fields that we've removed. But it's fine because we don't really need them. Okay, so let's move up to the top right before I covered this. Let's just talk about falters. So photos in tableaux are pretty common and we are going to use them. And faltering on the specific window is very different to faltering on a tableau worksheet or a tableau dashboard. So, for instance, maybe you want to analyze just a specific month. Only then you should implement a full two here. So to do this, click add and now this pain shows up. Click ad again, and these are the fields you can call to your date on. So maybe a specific country, like I said, maybe a specific date, a specific year. So let's do a specific country. So click on countries and territories. Click OK, and now you can select any country here. So let's just select Australia. You can also search if you want, so if you search for Australia, you can select it. And if you go down, it's a selected A one out of 206 countries. Click OK and click OK again and I against either data set only has the Australian Corona virus data. And just remember, if you decide to falter it on this window using the photos card here you won't be able to analyze data on other countries could you won't get that option. Okay, so obviously we do want to analyze data on other countries. So we are going to remove the filter. So click edit on the top, right, and wade stays countries and territories keeps Australia selected and kick on. Remove click. OK, and now we're back. So those are falters. Another final important section is connections. So you get two options with tableau. You have a live connection and you haven't extract. So what does a live connection mean? Well, the name says it all. So this means that while you bold in your dashboards, you are going to connect to a live data source, which and very sounds good, but it's not the best practice. Specifically, if you do have a large data set which you know gets updated often while you building your tableau dashboards, it's really going to slow down your workbook. Tableau extracts, on the other hand, are much more beta, so tableau extracts are basically static snapshots off your data which are optimized, and the extracts are basically loaded into your system memory and it can be called rather quickly for data visualization, so they just tend to be much more faster. And you can publish your dashboard with the extracts packaged online. So generally good practice is always use a tableau extract. Make sure you hide fields that you don't need and only use life. If it is a small data set that doesn't get updated, so select extract. And now we ready to start building some charts. So click on the orange sheet one. And now it's going to show you were to save your data. And now you need to choose a place in your computer. We save your data. Once you've done that, click save usually does take a while. Okay, great. Okay. So now we are at the main tableau window, and I think I'm gonna end of the lecture off here. And in our next lecture, we're going to prepare data for analyzing. So I'll see you then. By 7. Preparing your Data for Analyzing: Hello. Welcome back to this. Listen. So in this lesson, we are preparing our data to analyze it, which involves cleaning up some of the fields and just explaining how to blow works in general. So let's get to it. Okay, so this is the main tableau window. This is where you are going to bold your charts and create your dashboard. So let's have a look around it. Okay, so on the top left, you can see it's showing you the data source that we connected to. And if you right, click this and you can see you have a few options here so you can edit your data source. You can refresh your data. If you feel like the data has been updated and you just want new data to come through, you can view the actual data. So this is quite handy if you interview the back in data, so click view data. And as you can see now, this is just a table with the raw data. It's close it. Okay, right, cookie again. You can also rename your data set. You can duplicate it, you can completely remove it, but I don't recommend doing that It indicates here that we are currently using an extract and you can decide if you want to refresh your extractor gain. I think that's about it. That's important to now. So let's close it, so just click anywhere. Okay, so now you noticed is a section called Dimensions, and it has some fields from a database and is a section called Missions. And it has some fields on a database, and dimensions are basically fields in your database, which are categories you can't do any mathematical operations on them, For instance, recalling to multiply countries together you can't multiply days together doesn't make sense. Measures on the other hand off things that you can do mathematical operations on them. We can add cases together. We can add debts together now. Tableau usually separates this automatically, but sometimes it does make a few mistakes, and the other thing to note is, you can see the field type has been brought in a game, so it's quite similar to what we saw on a data source. Pain. So Continent E XP is a string countries and territories is a string Damon Theo. It hasn't flagged as numbers similar to measures cases is a number. Deaths is the number. Population is a number. Okay. It's also important to know that some fields have states assigned to them. They can either be discreet, well, continuous and discrete. He usually means separate values, and continuous usually means connected values on tableau. Generally, your measures are continuous and they are green, and your dimensions should be discreet and should be blue. I think because day, month and year numbers tableaux assigns them as continuous. But they should be discreet. So let's just change that. So click on the arrow and say, Convert to discrete. Now let's do the same for month, Click on the Arrow, convert to Discrete and do the same for Leo. Click on the Arrow Convert to Discrete. Okay, so let's talk about the field number off records, and a low automatically generates us on every data sit, and it just represents the number off rose. Okay, so before we actually start boarding our charts, let's just change some field types and rename some columns for Continent E XP. Let's rename that so hover over it. Click on the arrow and rename, and it's just call it continent again. For countries and territories. It's renamed that to just countries. So help over. Click on the Arrow click rename next base countries. And while we here, let's change the type. So this is a string, but it also has a geographic role. So click on ABC never get down to geographic role, and it is country. So go to country slash region and click on it, and you can see as soon as we've done. That tableau automatically generates the latitude and longitude for the countries, which is pretty awesome, and we can use it later on too bold a map. Okay, so let's change date rip. Let's rename it. So if you click on it once and you click on it again, you can rename it like that. So, backspace, let's call it date and click out. Okay, so this looks pretty clean. Let's move on To measures. Cases is fine. Deaths is fine. Pop data don't like that name. Let's change it to population, so click on it once, click on it again. Backspace population. So it's just a quick example of how tableau works too bold charts, so to book tableau charts, it just involves a simple dragon drop interface So, for example, if I want to know the number of records, I can click on it and click and drag to rose and you can see a small bar chart appears. And if you hover over this bar, it gives you number off records 11,900 to remove this. I click on this. It's called a poll P I L l So click on it and drag it out of your screen. The other shortcut you can do is if you double click on the field. So number of records double click it. It brings it in your pain. Okay. The other thing I want to do is maybe change the date type off this field to date. So click ABC and you can see now it's a string. Let's change it to a date. So click on it. Great. Okay, So everything is looking good, and I think I'm gonna endo fia in the next lecture. We are going to ordered our data to make sure the data is making sense so we can start building charts and dashboards cell C then by 8. Auditing your Data: Hi, everyone. Welcome back. Thank you for joining me again. So in this lesson, I am going to show you how to order your data to make sure it's making sense. And it's really important to you. Do this because obviously a wrong dashboard is a useless one. So get into the habit off. Even before you start boarding charts, too. Make sure your datas 100% correct. So first things first. Let's verify the case count, so double click on cases. Okay, now we have this bar chart, so just hover over it and it's going to show you the case number. So for me, it's saying that as off today, there's 2.3 million Corona virus cases. Okay, that number does make sense. I think the last time I checked there was run 2.2 million cases, okay, so the number might not to be exact as what's being currently reported just because different countries get updated at different times off the day. But it should be quite close, and I just want to do the same with deaths. So click on some cases and take it out of the dashboard to just drag it out and go to debts and double click on it. Okay, so I am seeing 164,000 deaths, and I'm just checked it online, and the number is showing at 169,000 currently, So that's good enough for me. I think the next step we should do is maybe verify the cases by country. So let's click on country and bring it into Rose and click on cases. Just click ones and double click it. Okay, so I'm gonna scroll down to the U. S. A. But you can pick any country that you want, okay? And it stays that the United States of America has 759,000 cases. That's quite close at a Google search now, and it's recording 784,000 cases, so you are going to get a bit of a leg. But as long as it's not too off, you're pretty much fine and let's bring in debts. So to do that, click on debts and double click it again so you can see it's pretty fast, and you could be used to this interface quite quickly. So for deaths for the USA. It's just over 40,000 and on the Internet it's recording 41,000 right now. So the numbers are pretty close and I'm happy about that. It's clear this works you to do that. You click on this chart icon with a cross. Okay, so the last thing I want to check is the population count. So let's double click this and it's hover orbit. Okay, so the population count for the whole world is 700 billion. That's obviously completely wrong. I know The population count currently is around 7.5 billion. So something is happening here, and what this is is it's a cumulative count where Tableau is summing every roll off this population field. Okay, so this is the Google sheet that we are drawing our data from and just have a look at the population field, which is pop data and on our data, said we know that one row of data represents a specific day for a specific country. So in this case for Afghanistan, on the 20th of April, they were 88 cases coming in three deaths. But population the population field is different. You can see that they just report the total. And what tableau is doing is that it's summing up this whole column, and that's why the number is so high. So to make it correct, we just need a photo on a specific day and bring in the population. Then we should be getting correct numbers. So let's do that. Okay, so let's bring in the date field as a falter. So to do that, you click on date, click and hold drag and place it under photos. And when you fall to a date gives you a variety of options. So firstly, you can falter. A relative date. This is a date falter that references today so you don't have to follow along here. I'm just going to go over the different date options, so the 1st 1 is relative date, and if I click next, it gives you the option off altering your date according to today's date, so you can pull to it just on today's results. Yesterday's on tomorrow's. If that's on your date, is it? You can also felt it on the last 30 days or whatever amount of days you want for the next 30 days. You can also do the same for weeks can do this week, a previous week and next week or last X amount of weeks, and you can do the same for months, for quarters and for years, the range of dates is where you can select maybe a specific range in what your data can be faulted on. You can also photo your data based on anything that happened off to a specific date or if you click on ending date before a specific date. But I'm not going to do that. So I just want a full two on one date. All right, So let me just go back, Okay? So I covered thes two options, and this is pretty self explanatory. You can fool to your data on years, quarters, months, days, etcetera. The most common one is month Theo and Month Day, uh, so select month, day year, select next and on the scroll button. Let's go down to the most recent date on your date, is it? So for me, it's the 20th of April selected. Make sure it's a selected one off 112 values and click. OK, Okay, so this is 7.5 billion this makes sense. So now we know that whenever we use the population field, we need to make sure we falter the date on a specific day. Otherwise, it just keeps duplicating. Okay, so let's rename the sheet to order it. So double click on wait a sheet one and select everything backspace and call it boarded. And whenever I d ordered sheets are always write notes about them. This is good. If you decide to open up this workbook a month later, referring back to your order, cheat to check if there's any rules or logic is very, very useful. So presenter. And now I'm going to say cases Paul confirmed correctly. Deaths are confirmed. Cukaricki and me select into again and say population needs to be folded on the specific date. Okay, so highlight ordered Emboldened click. Ok, All right. And let's rename the sheet to order. So where it's a sheet one at the bottom left. Double click it and call it ordered. Okay, so now we are actually ready to start building some charts because our data is looking clean and good, so we will cover that in the next. Listen, I'll see you then. Bye. 9. Creating Charts on Tableau: Hi, everybody. Thank you so much for joining me again. In the last lecture we covered auditing out data on in this lecture. We're ready to start holding some charts. So let's get to it. And we're going to create a bold map first. Okay, So to create a new worksheet, go to the bottom left of the sheet and where it has a chart icon with a plus sign. Click it and it's renamed the sheet to world map. So hover over she to double click on it backspace and say world map. Okay, so creating maps are quite easy. Selected the field letter to generated and double click it and do the same to longitude generated so selected and double click it. Okay, so you should see this world map appearing. And now the next step would be indicating to this world map what we're going to do. And to do that we're bringing in country and we dragging it on top of your marks card to detail, so select and drag it and dragon on top of your marks called to detail. Okay, so now you can see all these little dots appearing. Just want to zoom in the But you can do so on these two icons. Okay? Or if you wanna fix the map, you can click on the spoon, and it should bring you to a bit of you. Okay, so these dots are all pretty much the same size, and you just have country labels on them. Now, I want these dots sized by the number of cases. So if a country has a large number of cases, it should have a large dot And if a country has a small amount of cases, it should have a small dot. And to do that on tableau is pretty simple. So gonna click on cases, and I want you to drag it over to size and want you on top of it. Drop it. Okay, so now I can see things are looking up a different. We have much more smaller dots in countries with the large amount of cases have the larger dots. So let's increase the size about to do that. You click on the size option in the marks pain, and here you can drag this option depending on how large you want the dots. So obviously don't make it too large to a. You can't see the actual continent, and this looks fine. Okay, The next thing is that actually want labels off. The case counts. So next to each dot I want the label showing up. So that's also quite easy. Click on cases and drag and drop it under label. So click on it, drag it and drop it under label. Okay, so the next thing I want to do is I don't like this plain blue color on a change the color . So countries with large amount of cases get a deep red color, and countries with small amounts of cases get a more lighter in color. So it's sort of like radiant distribution. And to do that, it's quite simple. So because I wanted based on number off cases, go over to your cases field and click and drag to the color box, Drop it. Awesome. So now we do have some difference in colors, but let's make it rid so select color and click edit colors. Okay, so this is where you can change your color. If you're looking for a specific color, you can click on this blue box and choose whatever color you want, But Tableau also has some generated colors. So let's click out of this and click on paella to it is automatic. Click on it and I'm gonna do red color and click. OK, okay. Something that looks pretty good. And then the next thing is that I like my dashboard to generally be a darker color, and I'm just gonna show you how I would form at a dashboard. So want this map to obviously be darker. You can change Mac colors on tableau, but it's not that. First the towel. So go to map on the top toolbar. And over here there's some options for maps. So if you go to background maps, you can choose light. You can choose a normal, so this gives you a bit of ocean. Let's go to map background maps. I want to choose, Doc. Okay, I just think it looks better, but you can choose whatever color you'd like. If you go back to map and go to background images, you can add a image behind the map if you want. If you have custom geo coding, you can also import that so specific latitudes longitudes. If you find your data's a 19 baby countries are spelled incorrectly. You can also change it by kicking it locations. So if you click on edit location, you can see that something is up here. So, for instance, tableau recognize that a country was labeled this and it couldn't actually mep it to a country. This is probably one of the cruise ships that are near Japan. I'm just gonna leave it out. But if you want to include this into Japan's numbers, you click on unrecognized and just type in Japan. Now it will map the numbers at this cruise ship got to the country, Japan. But I'm not going to do that, so I'm just going to reset that. So this option is quite nice if you have spilling areas, except that you can actually change it to the correct country or region camera click. Cancel, and it's go back to map and select meh players. So if you look on the left, there's some other options that show up so under style again, you can select the way you map looks can also select. If it's a washout and former players, you can add some additional layering, so a terrain or coastline. Sometimes it doesn't make that much of a difference to a world map, but for a specific country does add some more detail. So it's up to you. I am gonna add water labels, and now you can see the oceans are named okay. And then the last thing I'm gonna tread about when it comes to maps is this toolbar that appears. It's pretty self explanatory. You can zoom and UN's oum. This penpix is the position of the map. So if you decide to zoom in, if you click on the spoon, it resets it. If you click on this arrow is another zoom function here, so let's select it. And if you click on a specific area, you can zoom into that click on the pen a gain it zooms out. This icon here is just for you to Panyu map, and these three icons are select tools. So if we select the circle, then we can basically make a selection off countries by a radius so you can see what's cool . Here's ones are selected it it gave me some summary stats, so 27 countries were selected. Their total sum was 924,002 slipped out. You just click anywhere and it's done and its recent the size. OK, let's change this title. So double kick it, highlight everything backspace and change the fund to tableau Bold. So click on here, and I think it's too up to tableau bold. We're gonna keep it 15 and it's centralize it. Let's call it cases by country and click. OK, okay. And here on the left, some legends come up. It's just to help the user read it. But so over here it's saying that we've sized the dot spy number of cases, and over here we've colored the dots by a number of cases, but this is pretty self explanatory. So I'm going to get rid of this. So click on the small arrow and say, Hide cod and click on this small arrow and say, Hide cod, Okay, and the last thing I want to do is I want to show you how to edit the tool tips. So tool tips are these little windows that appear when you hover over the icons. So to do that Select told up in your marks card and just to make it a bit more modern. I'm going to say amount of cases in a country, so select some cases, cut it and it's just backspace. All of this leave country here religious, backspace that and then paste it. So control. Come on, be space in space country and select some cases. Let's change it to tableau Bold. It's changed the fund size to 14 and let's change the color to rid that's at cases. Yeah, and let's click OK tonight the hobo. It looks a bit better. You can apply this to all your charts, but I'll just be applying it to the world map. The process is still the same. Okay, so things are looking good here. Let's create another chart. So at the bottom, click on the Chart Icon with the plus sign Let's rename Sheet three. So double click on it and quoted cases per country backspace cases country. So here I just want a bar chart, maybe showing the country and the number of cases. So the field we need this country So let's go over to the left and Dragon Drop Country to you, the Rose and Cases. Let's just double click on cases. Okay, Great. Now I want this as a botched shot. So to do this on tableau is quite easy. If you go to the top right, you'll see a Nikon code. Show me it's a ticket, and these are essentially all the graphs you can do on tableau. So if we hover over the first run, which is just a table you can see at the bottom, it gives you the type of graph and what you need. So for scared of plots, Unit zero or more dimensions and 2 to 4 measures. So for ticks tables, we need one more dimension and one or mo measure, and you can get other types of broth so you can get heat maps, highlight tables, pie charts, world maps like the one we've done. Bar charts, box and whisker plots, packed bubbles, etcetera. But I want to normal Bocian. So let's go over here and click on it to contract. Show me click on it once again and its contracts okay, and it's not sorted at the moment, so let's sort it to do so. You can click on either this icon and this icon, and it will sort you graph from smallest to largest or from largest to smallest. So let's click on the descending one. Okay, so now this is starting a graph by some of cases. Countries with the largest cases to countries with the smallest cases. It's looking good. Now do I really need to see every country? No, I don't think it's gonna be much use in my dashboard. So what if I wanted to just show the top 10 countries? You can do this by creating a sit on tableau, and a sit is basically a calculation logic on a specific part of your data. So in this case, I want the top 10 countries with the largest number of cases. Okay, so the main field here is country. So click on country, click on the arrow and never get down to create and creates it. And it's called the sit top 10 countries by cases and click on top, and this pain gives us options off. Creating sits with top 10 top 20 exit urologic. So wait is by field, click on it and jittery done for us, talked in by some of case. Is that correct? Click. OK, you can see the section appears and are set is here. So to bring it into a chart, we are going to drag this sit and drop it onto falters. Okay, this is looking great. So I think we just need some style. So first things first. This graph is quite small. It's expanded to foot the whole window. So on the top here, where it's a standard selected and select entire view and others graph stretches across the window. The next thing I want is peace. Some off cases to appear as a label here. So to do that, you click on cases and you drag it to label you drop it, and the next step is I want to get rid of these grid lines. So right, click anyway on your shot and click format, because it's a format option, and this is where you can sort of format your whole charts. So if you want a specific front, you can do it here. If you want to change the alignment off your labels and your text, you do it on this icon. If you want to change your chalk background, which were, you will be doing, you did with this. If you want to add borders he did with this icon, and the last icon refers to grid lines, So these are vertical grid lines, so they columns, so click on columns and you can see there is a slight grid line there. So let's remove it. So click on it and kick none, staying in the section a do on my chart to carry the same theme as my World map, which is a dark theme with white fund. So let's click on this full bucket and click on sheet because we want to change the color off the whole sheet and where it says worksheet, click on it and let's do the third black option. Okay, that's good. Now let's change the front because some of the front is obviously blended in. So go to a make sure it's selector on sheet, and they want to apply this to the whole worksheet. So select worksheet. Let's change the fund to tableau Bold. So click on it changed one up to tabla bold and change it to what? Okay, that looks pretty good. Now you can notice, are hitting disappeared because it's probably in the same color as our background, so let's sort that out So let's double click here and let's select all backspace. It's changed the fund color to white and change the fund to tableau bold and centralize it . And it's quoted cases per country. Select. Okay, okay, So my color scheme for my dashboard is basically either red or grey, and I want to do deaths. Maybe with rid. So let's change these boss to gray. So click on color and let's elect a lighter Grey. So maybe this one, it's really up to you go. But I think that's fine. You see, we don't really need this country hitting. I mean, it's pretty self explanatory that these are countries, so let's remove this. So make sure it's highlighted, right click okay and click on Hyde Field. Labels were rose. And then let's change this cases to a Capital C, and we can actually just change the field name. So let's rename it. So click on the arrow rename and put it as a capital C. A S E. S. And it's not would carry through the whole worksheet. Let's do the same food. It's so click on it, Click on the arrow rename deaths. OK, OK, so now the next try to be are going to work on is quite similar to this, but instead off cases on 12 deaths per country. So we're going to do a shortcut method where we duplicate the sheet. So let's get to it. So kick on cases, but country right click and click duplicate. Let's rename the stupid good sheet. So double click on it and say gets per country and it's you the same for this title. So double click on it and say, deaths per country click OK, and now, wherever you see some cases, we are going to replace it with deaths. So the city was based on top 10 countries by number off places. Now we need to create a new sit for top 10 countries by gets. So let's do that. Countries are main field. Never get to country field. Click on the arrow, go to create click on sit case. Let's name the sit. So the top 10 countries by this and select the top option by field and this time it's gonna be the top 10 by some off depths. So change this two deaths, Click OK, okay. So now we ever we see some cases. It's replaced this with debts, so click on deaths. Drag it and as you see some cases is highlighted. Drop it and let's do the same for the column poll. So pick on deaths. Drag it over to on top off some cases as soon as it's highlighted. Drop it. So this is your shortcuts that I generally do. We need to sort it out again. So let's click on the icon and night sorted by descending again. We need to replace the sit instead of top 10 countries by cases. We need to replace it with top 10 countries by deaths. So go to your sits, selected the depths yet drag it. And as soon as it's on top of this old sit, did it go? Okay. And now you have a graph about the deaths per country. Let's just change the color to make it up a different. So instead of gray, let's change it to read. So navigate to the color box in new marks, pain selected and change it to rid. Click out. Okay, so I think I'm gonna end this lecture here in our next listen. We are going to work with some calculated fields where we are going to calculate things like mortality and growth, which is quite interesting. So I'll see you then by 10. Creating Calculations on Tableau: Hi. Welcome back to this lesson in this. Listen, we're going to cover creating headline cards and using calculations, so let's dive into it. Okay, so let's create some headline cards before we do some calculations. So create a new sheet. Click on the trot icon at the bottom and let's name a total cases. So double click on it back space. Total cases, Kinta and just double click on the cases field. And I want to change this to a text. So click on Show Me So just never get to the top right click. Show me and it's the 1st 1 So the text table click on it. Okay, now let's change this view to entire view, so it's a standard on the top. Click and say, Entire view. Let's make this fund of a bigger and give it a label. So kick context, change the alignment, click on it and centralize its, which is horizontal. Click on the center icon. Okay, and it's headed this text. So it's a some cases click on the three dots next to it, and let's change this so it's licked it and change it to tableau bold. Let's change the fund size to 20. So click here changed to 20 press in tow and say total cases. It's highlight total cases and make it a bit smaller. So a change of the fund size to 12. Now I want the background to be dark, so this fund needs to be white, So select everything and change the fund color to white. Okay, you won't be able to see anything, but it's there. Let's change this background color. So right Click Pick for Mitt and Click Thief Full bucket, where it says worksheet, Click on it. And I think it was 1/3 1 down so this one can un selected. Okay, looks pretty good. So let's do a similar one. But for dicks, so we're gonna duplicate it. Go down to the sheet name, right Click Select Duplicate, and it's renamed the Sheet to total debt. So double click the sheet name and say total depths okay and ended up some cases on the left. Let's replace this field with addicts, so click on Deaths Dragon. And just as a pull highlights, drop it case and nights changing two deaths, and it's changed the hitting two. Instead of saying total cases change into total dicks. So click on text click on the three dots and wears a total cases. It's highlight cases and change it to dips. Select. Okay, now I want to add the mortality rate. So little work up the calculation to do that. Let's create a new sheet. So at the bottom, Tobar next to the total depths she'd name Select the Icon. Okay, so let's just compare cases and deaths. So kick on cases double click it, click on debts and double click it. And now a scatter plot gets created. But let's change it to a table. So go to the top right click on show me and change it to ticks Table. Okay, so the mortality rate would be the percentage of people who have died out of the confirmed cases. So the formula would be some of deaths over the sum of cases. And we need a calculated field to do this because we know this isn't present in our data. We need to create this field. So to create a calculated field, you never get over to this arrow so it stays dimensions just go but further right. Click on it and select create calculated field. Okay, so we taste Calculation one. Let's change that. So backspace and change it to mortality rate. And like I said, the mortality rate would be the some off your total debts over the some of your total cases . Okay, get ready to type in the formula to some open bracket. Type in debts, and you can see as soon as you type in d E E. This shows up so you can click it. Those records divide. Sign over some open records cases. See A you can see cases is the 2nd 1 The 1st 1 is a function. It has the icon f on it, which is a tableau Bolton function. This is actually referring to a field in our database. Islets licked it closed records, and that's it. That's how you calculate the mortality rate. So select okay are technically, but this is is this shows up as another column on outdated sit. So let's bring it in. Select mortality rate, drag it and drop it here under measure values and you can see it pops up, but it zero So why would it be zero? What mortality rate is a percentage. So we need to change this. Form it because right now it's a decimal. So click on mortality rate, click on the arrow and go right down to default. Properties and number format is where you can change the format. So click on that. And these are the options tableau gives used to. You can change your fields to numbers to just stand in numbers. Custom numbers. Two currencies to scientific notation and percentage. So click percentage, click OK, and it's a 6.99 so that looks correct. So now you're ready to bring this into our cards. So go back to total dicks and its duplicate the sheet right click duplicate that's renamed this total gets to to mortality rate. So double click and say mortality rate click out of it. Okay, So instead, off some deaths were gonna bring in mortality rate, so click on mortality rate and dragged right over some deaths, and 6.99% shows. Now we just need to remove this text to add in mortality ratings. Did so select text? Select the three dots and which is total deaths. It's backspace and say mortality rate and select. Okay, so now we're gonna do a bit of a challenge. It's a bit of a difficult calculation, but is useful. A lot of data analysts use it frequently, especially in tableau, and it's calculating growth. And basically, how it works is that I want to see how many cases they were this time last month compared to the current cases and calculate the growth. So did you do that? So you can select the sheet or you can create a new sheet. But I'm just going to select the sheet seven, and I'm going to clear it so you can go to this icon here with the chart in the cross and click it. Okay, So for the growth calculation, we need to know the number of cases that were present last month this time. So today is the 20th off April, and I want to know how many cases they were on the 20th of March, so we need to create to date fields we need to create a date field that shows whatever day today is. So for me, it's 1/20 of April, and we need to create another day feel to show last month's date, which was the 20th of March. So let's create a calculated field. So click on the Arrow got to create calculated field and renamed this calculation today. Okay, click on the pain and tableau has a neat function cold today, and it just picks up. What if a date today is so? It's not typing today and you can see this function shows up, so kick on it and it's good. That's it. Now, if you do want to know but more about functions, if you click on this arrow on the right, this is a functions dictionary, and it has all of tableaus functions. It gives a great example of it as well. Okay, so once we done select okay and let's bring it in so it's double click it, and you can see it stays year today. So what it's doing is it's aggregating the date to make it a bit easier to read. But I want the day of the month and the so click on the arrow and never get down. Now this diction here just shows two shows in one part off the date, so it will just show the eighth and this was just show May, but I want. Dame Anthea in the second section does that. So if you can select day, you can see it as a month. It has a day and it has a year so selected and now it's showing us that are calculated. Field is right. Look at quote Now we need to create another field, which is a one month before today's date. Let's create a calculated field. So click on the arrow, Say, create calculated field and let's call it last month Today. Now Tableau has a function which subtracts an interval from a date and that's called date. Add. So before we added in here, let's research a but about it. So open up the Functions Dictionary where it is inter search text, select their and and type date ad. Okay, so what does it say? It adds an increment to a specified date and returns than you date. So in the example the date ed function, it's adding a month. This is the interval, so three months on the state and you can see the answer is actually three months later. So we are going to do that. So to get last month, this time we're going to say month, but we going to say instead of plus three minus one and today's date. So let's do it to click on this pain called the Function. So type date ad open record The date part will be month. So quotation mark type in month, small case quotation mark again comma. The interval will be minus one because we subjecting a month Palmer and the date is our calculated field, which is today taken. Drag that field in and drop it here. Close. All right, click. OK, all right. So let's remove day today and let's bring in last month today. So click on it, drag it to rose. And instead of a year, we're gonna change it today, man Theo. So click on the arrow, go down past to this section, go to the stick and one says, month, day year, click on it and it says 20th March 2020. So the next day, if you open up this workbook, it's going to read today as the 21st of April and then this field last month. Today would be the 21st of March. All right now we need to create another field and this field is gonna tell you up the number off cases this month, so we're going to create another calculated field. So click on the Arrow create calculated field, and it's called Cases this month. But and for this we are going to create an if statement and if statements are logical statements, so let's have a look at what the tableau dictionary say's. So it's Inter such. Text it safe and click on this function. Just I have. And the description is tests a Siri's off expressions, returning the then very for the first true expression. So it's a bit of mumbo jumbo, but we're gonna break it down. So if statements are logical expressions and to put it in simple terms, they just test scenarios. And if a certain scenario happens, it outputs a different answer. So an example of an if statement would be If I have a Blue shut, I can play for soccer team won, and if I have a red shirt, I can play for soccer team, too, so you can see that what soccer team I play on depends on the color off my shirt. So this is our If statement is structured, so what I'm saying is that if a specific scenario happens, then give me an answer. But if anything else happens, then give me a different answer. And to calculate cases this month I want to say is that if the date the data came in is before today, then count the number of cases else give me zero. So if the date it's bringing dates, so click on day to bring it in is listen o equal to today. So click on today, bring it in, then show me the number of cases else. Don't show me anything at all. So this field should actually equal our total cases. But I just want you to understand the logic to this. So again I'm saying so if the date that our data has come in is less than today's date. So all data that came before well done today. Some of the cases for me, if not, then show me zero cases select okay, and it's double click lis and see how many cases they all it should actually read the same as your some cases. It's hover over it 2.355 so that the number off cumulative cases as off this month is 2.3 million. That's great Now, what was a number off cumulative cases as of last month? This time to answer that, we're going to duplicate this calculation. So click on this calculated field click on the Arrow duplicated can see a copy shows up, let it it. So click on the arrow off the copy, Select it it and let's call this cases last month. Now for this instance. What we're saying is that if the date our data has been brought in is less than last month state, then some of the cases otherwise don't some of anything. Okay, so let's change today to last month's date. So click on last month today, drag it and you can see once today selected. Drop it so this will calculate the number of cases as of last month today. So as of the 20th of March 2020 Select Okay, all right, so lettuce that are toe remove some cases this month from our shot and let's bring in some cases. Last month's a double click on this, and it was to 42,000 and that is correct. As off the 20th of March. Last month, they was about 242,000 cases. And now we can finally calculate growth because we have the number of cases that was counted last month this time, and we have the total cases as off today, we can calculate growth. Okay, so the growth formula is pretty simple. It is the prison number minus you passed number over your past number. So in our case, it would be cases this month, minus cases last month over cases last month. So let's create a calculated field on tableau. So click on the arrow, click on Create Calculated field and quoted gross percentage. Okay, so let's say some open records and it's gonna be prison. So case cases this monk click on it when it shows up close records minus some open brackets cases last month. Those records. And we need to divide this whole thing by cases last month as per the formula. So let's just put this whole thing in brackets. So Breck Attia and at the beginning Okay, go back to the end, have a divide sign and some cases last month closed records. Okay. All right. So just checking our formula here. So we taking the summer off all cases this month minus the sum of all cases last month, divided by the sum of all cases last month. Make sense. So let's click OK, and before I bring it in, remember, it's percentage. So let's change the format. So click on the field, click on the arrow, go to default properties, pick a number format and change 2%. Two decimal places is fine slicked okay, and let's double click on Growth presented to see how much in covert cases we have grown since last month. Okay, let's hover over it. So 872% growth, so that is correct. And finally, let's create the card. So where tase mortality rate on the sheet name. Click on it right click and duplicate the street. Let's change the name so double click backspace and it's called it growth. And now let's replace me. Just expand this. Let's replace mortality rate with growth, so let's click on growth dragged, and as soon as it gets highlighted on mortality rate, drop it. Yes, let's change this title to growth. Took a context and look on the three dots and where days. Mortality rate selected I didn't say growth growth from last month. And let's looked OK. Nothing. We need to create one more graph, and it's just gonna be the daily count off covert cases. You can either create a new sheet or erases the sheet seven. So I'm gonna click on sheet seven and just blank the sheet. So click on this icon. Okay, so you want number off cases today, so find date and double click on it. And instead of a year, let's do Dame Anthea. So click on the arrow and go right down to day and week, days, month, day year. Okay, it looks a bit weird now, but don't worry about it. And with these cases, let's double click on it. Awesome. I think we should leave it as a line graph because I feel like the bar chart looks a bit busy. I want to change the size off the line, so click on size and just make it a but bigger And I want to add labels on here with the number of cases. So let's click cases and drag it in to wear to his label and drop it right on top. Okay, so now it looks like this Too much labels we can change this I just wanted labeled for the most recent one. So click on label and what is marks to label? You can change it so it may be if you want to, man Max, But I want the most recent one. All right, so you know what comes next? It's a bit of formatting. So right, click on the sheet and let format. So we're gonna change the whole fund to White. So click on worksheet. Change to tabla. Bold can change to what? And change the background color. So keep on the full bucket where it says worksheet, Click on it and the third gray one. Okay, let's get rid of these grid lines that these are horizontal grid lines, so let's go right to the end. Click on it. Click on Rose, which is good lines. Click on it and Seligman. And lastly, on a change the color of the line. So on your marks card. Click on color and I'll change it to rid. It's at a title, so hover up and double click. Okay, lets electoral backspace change the fund to tableau bold and change the color off, the one to white. Centralize it and it's say it's Call it daily place. Count, Click OK, and let's rename the sheets So it's a sheet seven. Double click on it tech space and call it a daily count and we are done with all our charts . I hope that it wasn't too difficult for you. We have quite a few charts and cards now, and everything is looking good. Someone end off this lesson here, and the next lesson we are finally going to Boulder Dashboard, so I'll see you then. 11. Building a COVID-19 Dashboard: Hello. Welcome back to the Listen, we're finally here. We've done it with cleaner data. We've created a bunch of trot on cards and are we ready to build our dashboard? So let's get into it. Okay, So before we bought a dashboard, I just want to add a date falter because I want to bring that injured dashboard. So let's do that quickly. We can use the scruff so the daily can't graph select eight and drag it to Fulton's. And I want to do a range of dates. So So, like that. Click next and click, OK, and why I'm doing this is because I want to use us to have the ability to falter a certain age range. Okay, so let's leave it at this. And now let's create a dashboard. So you create a dashboard. We just need a select this icon, which is this window icon next to the new sheet icon. So was selected. And now this is where you board your dashboards. So on the left, you have a device preview. So this is nice. If you building a dashboard for a specific layout, like a phone or tablet. I just want to expand this about. Okay, this is where you can change the size of your dashboard. So if you select on it, you can do a fixed size. All you can do an automatic size, which scales to the screen or range of sizes as well. But let's you fixed. And while we here, let's change it to our size. So I'm gonna change it to a width of 1400 height off 900 to these old pixels. Okay, All right. And now you can see all the sheets that we've created appear here and hide works is that you can drag and drop charts to your dashboard by that actually gonna show you how I bowled dashboards. It needs to be designed a specific way to actually look nice. So that's what we're gonna do. So let's remove these charts. All right, So to start off with literacy color this dash put in. So go to the top bar, which is dashboard selected. Go to format. It has changed the shading. So kick on default and again of the 3rd 1 from black. Okay, let's remove this. Okay? So, in order to position your trots nicely. We are going to be using containers and containers are boxes at house all your charts. Okay, so first things first little work with all our headline cards. So to do that, I wanna create containers and you can do so via this. Objects pain. And let's do some floating containers first. So instead of tiled, select floating and wait is horizontal selected and drag it to your dashboard. You can drag it anywhere. Okay, it's expanded A. But okay, so to bring a card into the container, use like the card you want. So let's select total cases and select and Dragon. And as soon as it's over, this container want you to pre shift and you can see it highlights the container that it's gonna sit in. So once it's highlighted, drop it. So let's bring in another card. Let's bring in total debts so selected drag it and as soon as some top of this contain a hold shift and you can see it highlights. So once it's highlighted like this to the right off total cases want you to drop it. Okay, let's do the same with mortality rate. Click drag drug to it ditzes hold shift as soon as it's on the right. Drop it and you can see as we dragging. Dropping it actually gets fixed into a nice size by itself. Okay, let's do growth. That's a last card. Get click it. Drag it just over. Mortality rate, shift and drop. Okay, now they are titles. Your you can't see it unless you select the card. So just select the card and you can see there's a space here, so we're gonna hide it So right, click and say, Hi, title do the same here. So just go towards the top. Right click. Hi title, right click high title and here as well, right. Pick my title. Now, if you want to select this whole container, there's two ways of doing it. You can click on the card, click on the arrow and moved down to a J select container horizontal. And now you can move this around. Okay, the other way. What you can do is if you click on layout, let me just expand this about it shows you your item hierarchy. So this is a container, and if you click on it, it selects all the cards, and these are the cards. It's housing. Let's make it a smaller and it's just put a cheerful now. Okay, so let's bring in some more charts. So click on dashboard and now I want to have cases per country and debts per country, and I want them one on top of another, so that causes a vertical container. So that's bring that in so selected dragons and drop it. Just expand the container. But all right, so let's bring in cases. But country, so selected, drag it. And as soon as it's over the container hold shift and it go do the same for debts so selected. Drag it as soon as it's in trouble. The container hold shift and I wanted right below. So here. And to be honest, I don't really see a need for these access because we have labels, so let's get rid of it. So to get rid of this excess, right, click it and D select show hitter and do the same for this right click it de select to show hitter. And if you want to get rid of this white line here, you can. So if you select on a chart right click format, and it would be an excess ruler. So go to the grid lines and what is access Rulers. Just click none and do the same here as well. So click on the chart. Go to grid lines, Access rulers None. It ends up looking a bit better, so I'm just showing you sort of tips and tricks that I used to get my dashboards to look. Pretty case. We have too much what's left. I think we have the Daily Count and the world map, so let's bring in another vertical container. So click it. It's drag a chap expanded and let's bring in daily count, so click on daily can't drag it. Wait's over the container shift and it go cool and it's do world map. So click it dragged with over this container shift and I wanted below. So writer let go. I think the hitting disappeared. Solar, trist it. It's a double kick your and select all. Okay, it's just the same color as the background. So let's change it to white. Okay, so I zoomed in. Okay, Yeah, I don't want the title. I mean, it's pretty obvious it's a date, so let's edit this excess of click on it, right click in a Texas, you can do some general excess editing here if you want a fixed excess. Well, maybe a reversed one. And here is where you change your titles. So access titles. So click on it and just backspace and close it. Okay, so it's pretty much coming together. Um, I just want a title and a picture. So So let's create a horizontal container. Click it dragon. And once it's on top of total cases, hold shift and as soon as it's to the left of it, drop it. Okay, so some cards may disappear, but it's just the sizing, so just make it a bit smaller. Okay, so over here we're gonna have a picture in the title. The link to the picture that I've used is in the description below, so just save it some leeway weekend reference it. Okay, so that's it at an image to this container. So go down to objects. Image. Click on it, Dragon. Drag it to the top of the container will shift as soon as it's in this container. Let it go so this pain comes up and let's choose an image so ever. You stored the image that you've done noted, just never get to that folder. And it's this image here flicked open and select foot and center. And OK, okay. And now let's add a title. So it's like text on objects. Click it drag, and it's basically on the actual covert image. Hold shift, and I wanted to the right. Okay, so this opens your tics. Pain. Let's change the fund to tableau Bold Change the hitting to size 24 and change the color to what? And it's call it Cove it 19 dashboard and maybe put your name in it's Centralize it and let's make the name but smaller. So maybe 14. Okay, I think it's always nice to get into the habit off, adding your name to whatever dashboard you publish publicly. Eso No, these sizing looks a bit off, but we are going to fix it now. Okay, so how we're going to fix it is by taking each of these containers, putting it in one mess of container and fixing that size. So let's do that. So before we do that, I just wanna decrease the size of all these containers so slightly out. Just make your containers just a bit smaller. Okay? So select dashboard. And what I want to do is we're gonna stick each of these containers next to each other, so bring in a horizontal container and just leave a job, all right, slickly out and select a particle container. So that one, you're gonna click it and drag it to this container. It's a click as soon as it on top of this container. It's a shift in drum. I'm going to do the same for this container. So this vertical container click and drag, and as soon as it's on the left jump. Now we need you at this container on top. So it involved getting one more container where we stick this container and this on top of each other. So go to dashboard. It's gonna be a vertical one because we're doing it on top of each other. Drag and drop it Anyway, Let's bring in this container to that so quickly out and select the container. Drag it over to this container, hold shift and drop. Let's do the same for this so selected drug. It's and wondered on top like this drop. Okay, and now you'd see everything is on this one main container. So if you're selected, which is right on top, we're going to do one more action, which is click on this arrow and which is floating de selected, and now it looks better. Okay, so let's just make this a bit bigger so you can see and expanding it, and this map is all weird. Um, so let's kick on this planet and don't wanna make this title, but bigger. And there's one more thing I want to add. So remember, we brought in the full talk on this chart, so I want to bring it into this dashboard. So select this chart slicked the arrow where'd stays falters, bring in date and I concede, appears as its own container. It's just selected, and it's just drag to Yeah, maybe. Okay, you can see things get upset, but let's just reduce the size of this. Maybe we should bring us to the end so selected and just drag it over here. Okay, that looks pretty good. Now, if we falter this so let's select a date. Drag this to beginning of April. You can see only this chart gets affected, but I want all of these charts to get affected. So I want a date range off covert cases from the first of April to the 20 s. All of these charts my show me that date range. So to do that, click on the filter click on the Arrow Select apply to worksheets and wade saying all using this data source selected. And now you can see all of this is faulted on the date range. Hair growth from last month would be blank since we only faltering on one month. But the cool thing is, now the user can decide what date range they one of you to clear the falter. You can just select on this little photo icon. Next, he is it. Okay. And finally, let's rename this dashboard. So double click on the sheet name backspace, and call it a covert 19 dashboard. Okay, so I think we're done here. I'm happy with the way it looks. So in the next lesson, we are going to publish it. I'll see you there by 12. Publish your Dashboard to Tableau Public: Hi, guys. Welcome back. This is a final descent. I hope you had fun and enjoyed it. And in this listen, we are going to publish our dashboard to tableau public. So before we do so, we need to create an account. So open up your browser and never gate to this link, which is public Doctor Blow. Don't come and sign up for an account, So click sign up. Okay, Fill in your details and sign up. Also, just to not make sure your email is verified. Okay, So once that's done, we can go to tableau so to publisher to you navigate to the top ball and click on server and go down to tableau public and click on Save to Tableau Public. Here you are going to sign into your account, and here you can click signing. Okay, So let's rename the workbook so you can say co but 19 dashboard by your name. And please remember where taste google sheets select. Keep my data in sync with Google sheets and embed my credentials. This is how it updates automatically. Click save. Okay. So you may have to wait a bit for the query to run and is there we go through. Dashboard is published and ready. So give it a test run. The falters should work, and all your data should be there. And every time you log on, you can check when the data was last updated. I think have low public updates it one today. But you can request an update. If you want new data and that's it. Feel free to share this link anywhere. Okay, that's it's I really hope you enjoyed the story away and you got to learn, but more about tableau for beginners. Course, this was quite in depth. And this is exactly how someone would build a tableau dashboard as a data analyst for clients. So it's a really good use case. Thank you so much for joining me. If you like the course, please let me know. I appreciate any feedback, and I hope you got to learn about more about tableau. Thanks. Bye.