How to connect to COVID-19 data in Tableau

Version 6

    Questions? Please post to the Forum so we can more easily track questions and answers.

     

    -----

     

    You want to connect to the latest COVID-19 data, using either the COVID-19 Cases - Starter Tableau Dashboard or a workbook of your own creation. There are a few ways to do this.

    .Hyper File (Direct Download)

    Refreshed daily by 9:00am EST. The COVID-19 .hyper format takes advantage of the improved data engine, which supports faster analytical and query performance for larger data sets.

     

    It is provided for current Tableau customers and can be downloaded on demand from the data.world COVID-19 Data Resource Hub.

    .CSV File (Link for Web Data Connector) (Direct Download)

    Refreshed daily by 9:00am EST.

    Web Data Connector

    data.world’s web data connector allows you to easily pull data directly into Tableau to create visualizations.

     

    1. Using your browser, login to data.world (ensure you create and authenticate your account before proceeding)
    2. Open ‘COVID-19 Cases.twbx’ in Tableau Desktop
    3. Go to a sheet
    4. Add a new data source using the Web Data Connector
    5. Paste the link to the CSV hosted on data.world
    6. Login to your data.world account
    7. Ensure query type SQL is selected and click connect


    Note: It is best practice to be logged in to data.world prior to attempting these steps. If you receive an “Incorrect Password” error after Step 7, close Tableau Desktop, login to data.world through your browser, open Tableau Desktop, and re-accomplish the steps.

    Publishing to Tableau Public

    If you plan to save your dashboard to Tableau Public, you will have to use one of these connectors: Microsoft Excel, Text file, JSON file, PDF, Spatial file, Statistical file, OData, Google Sheets, Web Data Connector. If you want your dashboard to update daily, use the Google Sheets connector.

    Joining Your Data with COVID-19 Data

    In Tableau Desktop there are a few different ways to bring in your own data:

    • Add new data source(s): If the data you want to add doesn’t have any logical relationship to the data in the COVID-19 dataset, you can add your data to the workbook independent of the COVID-19 dataset.
    • Join your table(s): If the data you want to add has common fields (that is, columns) with the COVID-19 dataset you can join your data to create a single, combined data source. For example, if you have Country, Province/State, and/or Date in your data, most likely you will be looking to join one or more tables.
    • Blend your data: If your data is large and a join would result in many duplicated rows, you can define relationships between data sources and Tableau will query each source efficiently based on their relationships.


    More information about deciding between joining tables and blending data can be found here.

    Need Tableau Desktop?

    If you don’t already have Tableau Desktop, you can either:

    • Download a free 14-day trial of Tableau Desktop Professional Edition here. If you need to access data in a database and/or save your workbook locally before saving to Tableau Public, Tableau Desktop Professional Edition is the way to go.
    • Download Tableau Desktop Public Edition for free here. This version of Tableau Desktop does not have an expiration, and you can always update to the latest version for free.

     

    With either version of Tableau Desktop, you can save to Tableau Public. If you plan to share your work in an accessible online location, saving to Tableau Public is recommended. If you need the dashboard to automatically update to the underlying data source, you will need to use the Google Sheets connector which refreshes dashboards daily.

    Still Have Questions?

    If you still have questions, please connect with us on the COVID-19 Tableau Community Forum.