How to integrate weather data for postal codes in The Business Cloud of DOMO.

Especially in solutions that combine data analysis and visualization with collaboration and planning weather is a valuable asset to identify business dependencies as well as adjusting planning and organizing day to day work-schedules. This tutorial shows the necessary steps to load weather aggregated to postal code or other geographical entities.

Please see our YouTube Channel as well.

Step 1 – Log into Visual Crossing Weather Services

The first step is log in to Visual Crossing Weather Services. The bulk option is available as part of the corporate plan or alternatively as a la carte on-time download. For details on the latter please see the Visual Crossing Weather One-time Options overview.

Step 2 – Navigate to the bulk download section

On the button list in the upper right corner click the ‘Bulk’ labeled button.

Step 3 – Copy the data link to the data set required

You will see the list of available datasets. For additional areas or geographical aggregations please contact Visual Crossing Support under support@visualcrossing.com

Click on the required data set list entry and on the following page click the ‘Copy link’ icon to copy the link to your clipboard. The advantage to use the link to the data versus simply downloading it and then upload the CSV file into the DOMO platform is the option to schedule the reload in DOMO so you have an automatic refresh of the data.

Step 4 – Log into DOMO Business Cloud and define the data source

Once logged in into your DOMO Business Cloud select the ‘Data’ icon from the menu bar.

On the following screen select the ‘File’ option to proceed.

Step 5 – Set the parameters for the CSV Data connector

On the ‘Add new data upload spreadsheet’ click the ‘More Upload Options’ button.

This will open the ‘Data connectors’ panel. Select the ‘CSV Advanced’ connector,

and click the orange ‘Get the data button’

In the details section make sure your protocol is set to HTTP from the drop down and past the URL generated under Step 3 to the corresponding form field.

Additional settings to be set are in the ‘Advanced’ section where you need to confirm the delimiting character being set to ‘Comma’ and set the ‘Header Start Row’ to ‘1’ and the ‘Data start row’ to ‘2’. Click the ‘Next’ button afterwards.

Define your scheduling as required and click ‘Next’ again. The datasets are updated depending on the weather information included.

Finally name your data set and hit the ‘Save’ button.

Step 6 – Create weather data analysis

Start your analysis by hitting the ‘Create Visualization’ button

Now you can utilize the full visualization power of the DOMO Business Cloud on your weather data set.

Closing thoughts

As you can see, importing weather data for the areas you run your business in into the DOMO Business Cloud is very straightforward. If you have any questions, please let us know below in the comments or send an email to support@visualcrossing.com

Leave a Reply

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