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 …

How Historical Weather Data Records are Created from Local Weather Station Observations

Visual Crossing Weather Data offers historical weather data coverage for most locations in the world. To provide as accurate a historical weather data picture as possible, the product looks at multiple nearby weather stations so that the most accurate weather picture is created.  This article explains the process used to create the historical weather records, how …