Articles, videos, and documentation to help you get the most from Visual Crossing Weather
The Historical Weather Data Dashboard provides a simple way to view historical weather observations. The dashboard gives easy access to a deep history of weather records around them. The data is presented in dashboard form to give you the most optimal weather data consumption available in the business world today. If you then need to …
Historical rainfall data is easy to obtain from various sources, but the best options differ depending upon your needs. Below, we’ll help sort through the options to find the easiest and best way to obtain historical rainfall data for your project. Single Location and Single Date If you need historical rainfall data for only a …
Continue reading “Where can I find historical rainfall data?”
We use a lot of sources for our weather data. One of the richest sources of historical weather data is the Integrated Surface Database (ISD) from NOAA. The amount of data available is impressive. Hourly or sub-hourly weather records for 1000s of weather stations that are, in some cases, over 100 years old. However obtaining and manipulating …
Continue reading “How We Process the NOAA Integrated Surface Database Historical Weather Data”
PART 3 – CREATE A GROWING DEGREE DAYS CALCULATOR USING HISTORICAL AND FORECAST WEATHER DATA Download the free Degree Day Excel workbook (no add-in required) Learn more In our previous gardening weather blog, we have learned how to use Microsoft Excel to analyze the historical and forecast weather data of a location. We can now identify the …
Continue reading “Using Microsoft Excel to Analyze Gardening Weather – Part 3, Growing Degree Days”
Precipitation Coverage is a metric commonly encountered in weather data yet its meaning is often misunderstood. In this post I will discuss the differences and similarities between Precipitation and Precipitation Coverage, and how to gain significant additional value from using Precipitation Coverage in your own analysis. Precipitation Before discussing Precipitation Coverage, it is important to …
Continue reading “Precipitation coverage is the most important weather metric you don’t know”
PART 2 – CREATING AN MICROSOFT EXCEL GARDENING WEATHER FORECAST In our previous gardening weather blog, we set up a Microsoft Excel workbook that displays a summary of the historical weather information for a location targeted towards the gardener. With the historical Excel workbook, we can understand the climate that they can expect for a particular …
Continue reading “Using Microsoft Excel to Analyze Gardening Weather and Climate – Part 2”
One of the most common stumbling blocks for people beginning to work with weather data from around the internet and around the world is the myriad of units that you encounter. Often times different data sources use different units for the same weather metric, and you will need to homogenize them if you want to …
Continue reading “Weather unit conversion in Microsoft Excel”
Does the number of people who visit Mount Rushmore depend on the weather? In this blog I investigate the correlation between the daily Mount Rushmore visitor counts and the weather that occurred on those days. I was in the process of considering a trip to visit Mount Rushmore, and being a data guy, I decided …
PART 1 – CREATING AN HISTORICAL WEATHER DASHBOARD It’s hard to think of an activity that depends on the weather and climate more than gardening. How cold does my location get? When is the last frost date? Is it too hot for this kind of plant? Do I need to water, or will it rain …
Continue reading “Using Microsoft Excel to Analyze Gardening Weather and Climate – Part 1”
Does weather affect my business? This seems like a simple question but as many of us have quickly learned, it is not a simple task. I have performance data for a set of stores and I am pretty certain that weather has been affecting my business, but I need create an analytical sheet to be …