Tableau Crash Course: Build and Share a COVID-19 Dashboard
4.5 (615 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24,165 students enrolled

Tableau Crash Course: Build and Share a COVID-19 Dashboard

In this crash course you're going to learn how to build a COVID-19 dashboard using real data and publish it online.
4.5 (615 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24,165 students enrolled
Created by Dee Naidoo
Last updated 7/2020
English
English [Auto]
Current price: $12.99 Original price: $19.99 Discount: 35% off
8 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 3 articles
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
  • Create Sets and Top 10 Calculations
  • Check and audit your data
Requirements
  • A computer with an internet connection
Description

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. 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

  • Bonus Section: Create a dashboard analyzing Trump's Tweets about COVID-19.

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!

Who this course is for:
  • Anyone who wants to learn more about Tableau and Data Analytics
Course content
Expand all 25 lectures 04:32:52
+ Section 1: Introduction to Tableau
2 lectures 03:04

Hi!

In this lesson we are going to install the free 14 day trial of Tableau!

Please navigate to this link below:

https://www.tableau.com/products/trial

Thanks,
Dee

Preview 01:46
+ Section 2: Connecting and Preparing Data
6 lectures 36:26
A Note before watching the next lecture
00:14

Hi!

In this lesson we are going to create a google sheet which imports text data from a url! The link to connect to the dataset is below:

https://data.europa.eu/euodp/en/data/dataset/covid-19-coronavirus-data/resource/260bbbde-2316-40eb-aec3-7cd7bfc2f590 or https://data.europa.eu/euodp/en/data/dataset/covid-19-coronavirus-data

If you are having issues connecting, please feel free to use my google sheet instead.

Sometimes the EU data portal goes down or links break. If this does happen, feel free to use my Google Sheet:

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

Just a note, I will try and update this as much as I can!

View the project brief attached if you would like to see the full steps to create your datasource.

Thanks, Dee

Importing data to a Google Sheet
05:12

Hi!

Sometimes the EU data portal goes down or links break. If this does happen, feel free to use my Google Sheet:

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

Just a note, I will try and update this as much as I can!

Linking to a Google Sheet
02:28

Hi!

In this lesson, we're going to connect to our Google sheets datasource. You're also going to learn a bit more about the Tableau's different connection options and how the datasource window works.

I've also included some additional information on Tableau joins.

Hope you enjoy!

Connecting your Data to Tableau
12:34

Hello!

In this lesson we're going dive deeper into our data. This will include:

  • Knowing the difference between dimensions and measures

  • Changing the types of fields

  • Renaming Fields

  • Learning about Tableau's auto-generated fields

Hope you enjoy the lesson!

Dee

Preparing your Data for Analyzing
07:28

Hey!

Thanks for joining me again. In this lesson, we're going to deep dive into our data and figure out how to display the most accurate results. This is a very important process which every data analyst needs to do.

Hope you enjoy!
Dee

Preview 08:30

A short quiz to cover your knowledge on connecting and preparing data.

Connecting and Preparing Data: Quiz
3 questions
+ Section 3: Creating Charts and Calculations
2 lectures 47:48

Hi!

We're going to cover building charts including a world map. Tableau maps are quite cool and there are a lot of functionalities you can use to get clear and concise maps which get to the point. I will also be covering formatting and styling of charts as well.

Thanks

Dee

Creating Charts on Tableau
21:23

Hello!

In this lesson, we are learning about calculated fields on Tableau and using a logical function. I use logical functions all the time on my Tableau dashboards- and they're relatively easy to grasp! We are also going to learn how to calculate Growth %.

I hope you enjoy the lesson.

Thanks

Dee.

Creating Calculations on Tableau
26:25

This quiz will cover some basic content on Maps and Calculations.

Maps and Calculations
4 questions
+ Section 4: Building and Publishing Dashboards
2 lectures 20:03

Hi again!

We're finally at the part where everything comes together. I've decided to show you how exactly I've built hundreds of dashboards- and it's through using containers.

This lesson we're going to cover laying the dashboard out, using containers and fixing it to a specific size. Hope you like it.

NB: The coronavirus image for the dashboard is available in the resources section

Thanks

Dee.

Building a COVID-19 Dashboard
17:13

Hi!

For this last lesson, we are going to cover how to publish your dashboard to Tableau Public. For that, you need a Tableau Public account. It's free and super simple to set up. The link is below:

https://public.tableau.com/

Thanks so much for joining my course. I hope you enjoyed it!

Dee

Preview 02:50
+ Bonus Section: Build a Dashboard Analyzing Trumps Tweets about COVID-19
1 lecture 01:00:06

Hi! This is a bonus lecture! (And there will be more coming!)

In this lecture we build a dashboard which analyzes Donald Trump's Twitter. You will learn:

  • How to flag popular phrases by using the CONTAINS function

  • How to use more complicated IF statements

  • How to use dashboard actions.

Dataset:

Check the resources, the file "trumptweets.xlsx" is the data we will use.
We also use a small picture of him on the dashboard which I've included as well (donaldtrump.jpg)

If you having issues downloading the dataset OR you want more updated data, check out my blog article.

https://databudd.com/data-analytics-for-business/build-a-tableau-dashboard-trumps-tweets-about-covid-19

Thanks, Dee!

Build a Dashboard Analyzing Trumps Tweets about COVID-19
01:00:06
+ Older Version of this Course
12 lectures 01:45:24

Hello! I've decided to update this course. The updated version is in sections 1-5 above.

This section contains the older version of the course and does not need to be completed as the newer version covers everything and more!

In the old version, I was using Tableau COVID-19 datasource on Google sheets. Unfortunately, Tableau has been changing this datasource often which is affecting the dashboards and making it appear blank.

I recommend using the new version of the course as we import data from a text url into Google Sheets so it sorts this problem out.

Thanks!

Important Note: I've updated this course.
00:22

Hi!

I'm Dee, a Data Engineer and I've been working on Tableau for a GOOD while now. I just wanted to say thank you so much for choosing my course. We're going to have lots of fun!

In this lesson, we are just going to cover what Tableau is as well as the benefits of learning Tableau.

I've also included some slides to cover this content.

Thanks!

Introduction to Tableau
01:14

Hi!

In this lesson we are going to install the free 14 day trial of Tableau!

Please navigate to this link below:

https://www.tableau.com/products/trial

Thanks,
Dee

Installing Tableau
01:46

Hi again!

In this lesson we are going to connect to Tableau's official "live" COVID-19 data source. Please note, that the data source I am using is Tableau's Google Sheet. You can view it here:

https://docs.google.com/spreadsheets/d/14quQPFErG-hlpsrNgYcX85vW7JMMK5X2vNZrafRcH8c/edit

Important: If you notice the dataset I use is different to the link above, then that means Tableau must have changed the dataset. If this is the case, please use the link below. It's the exact same data used in the lesson.

https://docs.google.com/spreadsheets/d/1wt3I4--yBMrcQfR_VKAmAvEnW2dyF6h9VE_EXtNEFs4/edit?usp=sharing

The links are also available in the project brief attached.

Thanks!
Dee


Connecting your Data to Tableau
17:33

Project Assignment:

Now that you have the skill to create quick dashboards on Tableau. Let’s design dashboard only applicable to a country of your choice.

Read the description and try see if you can build a similar dashboard from scratch!

Project: Create a COVID-19 Dashboard for a Country of your choosing.
01:07

Hello!

In this lesson we're going dive deeper into our data. This will include:

  • Knowing the difference between dimensions and measures

  • Changing the types of fields

  • Renaming Fields

  • Working with hierarchies

  • Learning about Tableau's auto-generated fields

Hope you enjoy the lesson!

Dee

Preparing your Data
11:15

This is a short quiz to cover what we've learned about connecting data with Tableau.

Connecting and Preparing Data
4 questions

Hey!

Thanks for joining me again. In this lesson, we're going to deep dive into our data and figure out how to display the most accurate results. This includes using relative date filters which are useful when you're connecting to a datasource which updates frequently.

Hope you enjoy!
Dee

Audit your Data
10:40

Hi!

We're going to cover building maps. Tableau maps are quite cool and there are a lot of functionalities you can use to get clear and concise maps which get to the point. I will also be covering formatting and styling maps as well.

Thanks

Dee

Building a map on Tableau
09:54

Hello!

In this lesson, we are learning about creating and styling bar charts. We're also going to learn about calculated fields on Tableau and using a logical function. I use logical functions all the time on my Tableau dashboards- and they're relatively easy to grasp!

I hope you enjoy the lesson.

Thanks

Dee.

Creating Bar Charts and Calculations
32:40

Hi again!

We're finally at the part where everything comes together. I've decided to show you how exactly I've built hundreds of dashboards- and it's through using containers.

This lesson we're going to cover laying the dashboard out, using containers and fixing it to a specific size. Hope you like it.

Thanks

Dee.

Building a COVID-19 Dashboard
11:34

Hi!

For this last lesson, we are going to cover how to publish your dashboard to Tableau Public. For that, you need a Tableau Public account. It's free and super simple to set up. The link is below:

https://public.tableau.com/


Thanks so much for joining my course. I hope you enjoyed it.

Dee

Publish your Dashboard to Tableau Public
05:41

Hi!

If your published dashboard is showing up blank please watch this video- if not then you're welcome to skip this!

Since we are using an external datasource created by Tableau itself (COVID-19 Google sheet by Tableau)- it may give you an issue when you publish it.

If your published dashboard is showing up blank- then you need to change the date filters. You will have to change all date filters from date = yesterday, to a specific date which is available on your dateset i.e April 11, 2020.

To do this, select "range of date" and change it to a maximum date on your dataset. Apply this to all the sheets of your dashboard. You can then republish it.

Regards

Dee

Important Note: Is your dashboard blank when you publish it?
01:37