How can I download weather history data as a CSV file?
In this article, we will show you how to easily download historical 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 forecast data as a CSV, …
Continue reading “How can I download weather history data as a CSV file?”
How do I load Weather History data into a Pivot Table?
Pivot Tables are an invaluable tool for displaying and analyzing data of all types. They allow users to pivot all types of data so that the data is formatted exactly as the viewers of data would get the most benefit whether they are viewing a grid of data or they are viewing graphs that require …
Continue reading “How do I load Weather History data into a Pivot Table?”
Automate recent weather history data retrieval using Microsoft Power Query
In our previous articles about integrating Weather History data into Power BI and Microsoft Excel, we have used the Visual Crossing Weather API to retrieve historical weather data. In this article we discuss how to make those weather data queries automatically read the latest weather conditions using Microsoft Power Query. If you would like to …
Continue reading “Automate recent weather history data retrieval using Microsoft Power Query”
Guest blog: Your Wedding Weather – How to use weather history to plan your wedding day
n this guest blog, Wedding Planner Falade Kunle Tom describes how to incorporate historical weather information into your wedding planning It’s over 5 years now that I have been handling events for various clients, especially wedding events. From experience, it is easy to have control over a number of things that include the guest list, …
Severe Convection Weather in the Midwest United States
Convective storms, and their products, thunder, lightning, heavy rains, hail, and tornadoes cause up to $17 billion dollars of damage each year in the United States. The factors influencing this figure include damage to property, deaths and injuries sustained. In addition, these storms cause disruption in farming and industrial activities. With the frequency of severe …
Continue reading “Severe Convection Weather in the Midwest United States”
How can I load weather forecast data into Microsoft Power BI?
In this article, I’m going to show how you can quickly and easily load weather forecast data for any worldwide location into Microsoft Power BI for further analysis. Visual Crossing Weather enables you to import forecast or historical weather data into Power BI. The data can be imported as CSV or JSON depending on your …
Continue reading “How can I load weather forecast data into Microsoft Power BI?”
What exactly is a weather record?
A weather record is the smallest unit of weather data that is used in the Visual Crossing Weather accounting process for our plans. Whether you have unlimited data access or are limited to 1000 records per day as a member of our Free plan, it is useful to understand the accounting behind weather records What …
Agriculture elements in the Timeline Weather API
The Timeline Weather API includes elements that are designed for use by the agricultural and horticultural industries. These elements are designed to providing weather data that influence those who grow plants or raise livestock. The elements on this page are available only to certain subscription levels. For more information, please see our pricing page. The …
Continue reading “Agriculture elements in the Timeline Weather API”
Energy elements in the Timeline Weather API
The Timeline Weather API includes elements that are designed for use by the solar and wind energy industries. These weather elements include measurements of the solar radiation at the earth’s surface and wind speeds and directions. The elements on this page are available only to certain subscription levels. For more information, please see our pricing …
Continue reading “Energy elements in the Timeline Weather API”
Weather Workbook – Legacy Version
For those of you familiar with the original Weather Workbook, this is the original mode of operation for users to connect Excel to the Visual Crossing Weather Server and retrieve, live, parameterized queries. This version differs from the new version that focuses on retrieving scheduled CSV datasets built using the new QueryBuilder and producing downloadable …