Homework

In this section a homework is provided to reinforce the learned materials of this section about Tableau Prep software. In fact, in order to re-examine our learned materials, for completing this homework, you need to download this dataset from of COVID-19 at the country level of the whole world: https://covid.ourworldindata.org/data/owid-covid-data.xlsx from Our World in Data repository.

Homework's dataset

COVID-19 at the country level of the whole world: https://covid.ourworldindata.org/data/owid-covid-data.xlsx from Our World in Data repository

Homework

Upload the new dataset given in this homework from Our World in Data repository into the Tableau Prep. Now follow this procedure and save the results in each section:

  1. Filter the dataset for COVID-19 of the United States of America from rest of the world.

  2. Clean the filtered dataset in the section 1 and make sure there is no NULL value in the cleaned data.

  3. Use calculated fields to define three days (3-days) and seven days (7-days) time windows based on date parameter that would be used for calculating the 3-days and 7-days moving averages (Note: make sure all the fields have consistent data type).

  4. Use table operations and calculate the 3-days and 7-days moving averages for:

    • Total cases

    • New cases

    • Total deaths

    • New deaths

  5. Save the final results into a spreadsheet that could be used directly for visualization in Tableau Desktop.