Lab 10 Visualize #Covid19 Data in #Tableau
Channel: LBSocial
Date: 02/02/2021

Objectives:
• To get familiar with Tableau Public
• To learn how to create special charts in Tableau

Viz of the demo: https://public.tableau.com/profile/xuebin.wei#!/vizhome/Covid19inVA/Dashboard1


Data: 
• Covid19 data from 1Point3Acres https://coronavirus.1point3acres.com/
• The total population and median household income from US Census https://www.census.gov/data.html 
 Steps:
1. Register a Tableau Public account at https://public.tableau.com   
2. Download the latest Covid19 data with the URL provided on Canvas. 
3. Use the population and income data from lab9
4. Open the lab9 flow in Tableau Prep and rerun the process to create a new hyper file.
5. Open the new hyper file in Tableau Desktop, filter the data to a state you are interested in, e.g., VA. Calculate the death rate and the case rate. 
6. Create the following sheets:
6.1.  A choropleth map showing the death rate and case rate per county
• Users should be able to switch between the death rate and the case rate with a controlled parameter. 
6.2. A Bollinger Bands chart showing the total cases over time
•  Users should be able to define the time range and number of standard deviations.
6.3. A bump chart showing the ranks of counties by the death rate per month
• The chart should only show the top 5 counties with the highest death rates.
6.4. A waterfall chart showing the change of total deaths per month
7. Combine those sheets in a dashboard. Add necessary filters and actions.
7.1. Add a dashboard title, data source, and other objects you think are necessary.
7.2. Check your dashboard in the phone layout preview.
7.3. Hide all the used sheets but the final dashboard of your worksheet.
8. Publish your dashboard to Tableau Public.