How do I load weather forecast data into Tableau Desktop?

This article shows the necessary steps to quickly and easily load weather forecast data for any location of the world into Tableau Desktop for further analysis.  The tutorial shows step-by-step how to construct the query in the Visual Crossing Weather web interface and then import the weather forecast results as csv file into Tableau Desktop.

If you are interesting in how to import historical weather data into Tableau, be sure to check out our second blog describing how to import weather history data into Tableau.

Step 1 – open Visual Crossing Weather Data Services

Open the Visual Crossing Weather Data Services log-in page and sign into your Visual Crossing Weather account.  If you don’t already have an account, you can sign up for a free trial on the same page.  Signing up for a free trial account will give you immediate access to a full 15-day weather forecast for any location.

Step 2 – specify your locations

The first page will prompt you to add the locations to retrieve the weather forecast for. There are two options in the web interface to manually add locations. As direct entry of either the physical address in clear text or as bulk entry in form of a file upload. The following steps refer to the file upload option – for more details please see the Visual Crossing Weather Data Tutorial section

mceclip0.png

Step 3 – import locations from a file

The next screen will prompt you to select the file containing your locations of interest. You can browse to the file on your hard disk. simply drag an drop it to the corresponding section or paste the content directly into the web page.

Step 4 – configure the location information

In the ‘Select the correct columns’ form, select the the address and the name column of your data set. For the forecast you can ignore the date column which refers to the retrieval of historical data. The address can be a Latitude / Longitude pair as well as simply address, a city name, or a postal code.  For convenience you see a preview of your data set. Once finished press the ‘Add new data’ button at the bottom

blobid2.png

Step 5 – Request Weather Forecast Data

On the next page you can select the type of data you want to download.
The options are forecast, weather history queries, historical data summary reports, and hourly data.  This tutorial will continue with the daily forecast option. Please see those or reach out to us if you need more information on the other options or browse our tutorial and video section for more details.
Select the forecast option and click the ‘Request Weather Data’ button.

blobid0.png

Step 6 – view and download the weather forecast data

The default view for the query results is the weather calendar.  This view provides a simple overview of the result data.  To further analyze the data you will need to download the full data set by clicking the ‘Download all data’ button.

blobid0.png

Step 7 – start Tableau Desktop

Once you have the data downloaded into a CSV file, you can load it directly into Tableau Desktop. To start the analysis first launch your Tableau application.

blobid1.png

Step 8 – import the weather forecast data into Tableau

You next need to load the data file into Tableau. So choose the ‘Open…” option from the ‘File’ menu.

blobid2.png

The file chooser will open and allow you to select the input data file for analysis. for this example, select the .csv file containing the forecast data downloaded in Step 6.

blobid3.png

Step 9 – configure the weather forecast data

Tableau Desktop now displays the full data set containing forecast metrics for the next fifteen days. The metrics include common values such as temperature, precipitation, and wind as well as less common value such as heat index, cloud cover and wind gusts.  For more information on the details regarding our weather metrics, please see our Weather Data Documentation.

blobid4.png

Step 10 – create weather data analysis

Now that the weather data is loaded into Tableau, you can begin your business analysis. You can bring all of the normal Tableau analysis tools to bear while you combine weather data and your existing business values. Like in the below example visualizing the tracking of rain events.

blobid5.png

If you would like to learn more about using Visual Crossing Weather options such as history data, multiple location import, and use within other analysis tools please see our other tutorials.

Leave a Reply

Your email address will not be published. Required fields are marked *