How can I find past weather information for my insurance claim?
Weather conditions play a role in many of life’s events, both positive and negative. Hollywood has made a fortune with scenes showing lovers frolicking playfully in a surprise rainstorms and heroes battling the elements to save they day, umbrellas optional. And who doesn’t fondly remember a beach trip sitting on a lounge chair, warm sand …
Continue reading “How can I find past weather information for my insurance claim?”
How to load weather data using Python
In this article we load historical weather data and weather forecast data using Python
I think that I’m seeing bad weather data. What should I do?
Occasionally when reviewing weather data you come across a weather record that simply doesn’t seem right. Perhaps the precipitation is too high based on what you know about the location or perhaps the temperature is too low, and you know because you live there. At other times you may find missing data within your weather …
Continue reading “I think that I’m seeing bad weather data. What should I do?”
How can I load historical weather data into Microsoft Power BI?
In this article, I’m going to show you how to easily load historical weather data for any worldwide location into Microsoft Power BI for further analysis. We’ll walk through the process step-by-step showing you how to construct the query in Visual Crossing Weather web interface and then use the query URL to import the weather …
Continue reading “How can I load historical weather data into Microsoft Power BI?”
How to Build a Weather Dataset for Download, Bulk Import or Scheduling
If you have ever tried to download weather data for your specific location(s), timeframe and format needs you will know that it is a challenging exercise. Most of the time the solution is for you use the API to build a script or using coding to create this set. This creates additional cost, time and …
Continue reading “How to Build a Weather Dataset for Download, Bulk Import or Scheduling”
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 …
How to build a great Weather Dashboard
Dashboards are one of the most effective ways to communicate data to users. Originating, from the dashboard in cars and vehicles, data dashboards typically combine multiple data visualization elements such as charts, maps, grids and KPIs to provide users with a fast, concise, and clear way to interpret a set of data. For businesses, organizations …
Certificate error running Weather API requests
If you are getting an expired certificate error running Visual Crossing Weather API queries, this article will explain the likely cause and how to fix it. The problem On September 30, 2021, an old version of the Let’s Encrypt “intermediate” certificate expired. While our servers have been delivering the updated version of this certificate for …
Continue reading “Certificate error running Weather API requests”
Using Weather Data in Business Intelligence – Part 3
How to make intelligent decisions using BI and weather forecasts
Now, armed with the insights that we found in part two, we are ready to apply those insights using weather forecasts. As we did when analyzing our historical business records using weather history, we will use the high-quality weather data service that we identified in part one of this article series. Then, we will join this data with our business locations. Only this time, instead of finding existing patterns we will apply the patterns discovered to make more intelligent decisions.
Using Weather Data in Business Intelligence – Part 2
How to analyze business data using historical weather records
In this article we will continue where part one stopped. Once high-quality, BI-friendly weather data has been found, we next need to understand how it can be used to analysis historical business data, Most business intelligence systems have a warehouse containing years of business records including locations and dates. This article will show how to match those records to weather data and identify useful patterns and trends.