Getting Started With Logistics and Delivery Weather

Many businesses ship weather-sensitive products such as wine, food, beverages, and pharmaceuticals. Shipment Weather uses worldwide weather forecast data to verify that the weather at the shipping destination is within provided parameters that will not damage the items being shipped.  Users can plan shipments that reduce product spoilage and increase customer satisfaction. The tool helps …

How to use historical weather data to forecast the weather for any day of the year.

When we need to know what will happen with the weather in the next couple of weeks, we can turn to the traditional weather forecast. The standard weather forecasts are based around computer models that simulate what will happen with the weather over the next few weeks.  But what happens when you aren’t interested in the next …

How Weather Data can add real value to your home automation system

Home automation systems are becoming increasingly popular as they offer homeowners a way to control their homes remotely and automate various tasks. While these systems can provide many benefits, one of the most significant is the ability to use weather data to improve home automation functions. There are a number of ways that weather data …

Importing data from a JSON Weather API into Microsoft Excel using Power Query

This article shows how to import data into Microsoft Excel using Power Query from a RESTful Weather API. This API returns JSON-based data. We are also going to explain how to create a loop within our script so that we can call the API multiple times for multiple locations and create a combined result table …

How to Load Weather Data into Microsoft Excel using a Web Query Data Connection

One of the powerful features of the Visual Crossing Weather Service is the ability to query data via a Web Service or URL.  This benefits not only coders but rather can be utilized to import data into most Business Intelligence Systems including Excel.   When you include your data into Excel, you can refresh the data …

How can I download weather forecast data as a CSV file?

In this article, we will show you how to easily download forecast weather data as a standard CSV file that can be imported into thousands of data analysis and storage applications such as business intelligence systems, visualization tools, statistical analysis packages, and databases. If you would like to download weather history data as a CSV, …

Adverse winter weather forecast across the western and north-central US

Parts of the northeastern United States and the western and north-central regions should expect to see bad weather from a massive winter storm system until at least February 23. From the western coast into the inner west, over the northern Plains, Upper Midwest, and Great Lakes, and into northern New England, the storm will deliver …