How to add historical weather data to Qlik Sense

This article shows the necessary steps to quickly and easily load historical weather data for any location of the world into the cloud solution ‘Qlik Sense’ for further analysis.  The tutorial shows step-by-step how to construct the query in the Visual Crossing Weather web interface, how to access the automatically generated connection string and then …

How to load weather forecast data into Qlik Sense?

This article shows the necessary steps to quickly and easily load weather forecast data for any location of the world into the cloud solution ‘Qlik Sense’ for further analysis.  The tutorial shows step-by-step how to construct the query in the Visual Crossing Weather web interface, how to access the automatically generated connection string and then …

How to download weather forecast data as a Microsoft Excel Workbook

In this article, I’m going to show how to download weather forecast data as a standard Microsoft Excel file. The estimated time to complete this exercise is less than 5 minutes. Step 1 – Open the Visual Crossing Weather Data Page We’ll start by going to the Visual Crossing Weather Data page.  Then we need …

How to include sunrise, sunset and moon phase data into your API requests

In addition to providing historical weather observations and weather forecast data, the Weather API also provides astronomical information. This astronomical information includes sunset, sunrise and moon phase data. Why is astronomical information useful? Sunset, sunrise and moon information goes hand-in-hand with weather data in many use cases. The information can help answer some basic questions: …

How to make a WordPress plugin that uses shortcodes to show the weather forecast

Note – If you want to use this plugin right away, you can download the ready-to-install version from the WordPress plugins directory. WordPress is a hugely popular content management system used by hundreds of millions of sites across the internet to build websites and blogs. In fact, it bills itself as “the world’s most popular …

How to load historical weather data into Tableau Desktop?

Downloading historical weather data for multiple locations provides a fast and simple way to enrich your business data in Tableau Desktop with relevant weather parameters to analyze their impact. This article shows the necessary steps to quickly and easily generate the weather data for any location of the world and how to load it into …

How to look up the current weather conditions in the Weather API

Many weather data applications such as weather widgets, weather analytics tools and information displays find it useful to communicate the current weather conditions. These conditions include current temperature, wind speed and direction, recent precipitation and more. Looking up the current weather conditions for one or more locations is easy in the Visual Crossing Weather API. …

How can I load historical weather data using Google Apps Script?

Google Apps Script also known as Apps Script or sometimes Google Script, is a scripting language based on JavaScript and used within Google’s G Suite applications. Although it started life as a side project within Google Sheets, today it is used as a scripting language within all of the Google apps family including Google Sheets, …

How to use Python and Pandas to join historical weather data to road accident data

I am currently investigating the relationship between weather conditions and accidents by using a dataset of road accidents in Fairfax County, Virginia obtained from the Virginia Department of Motor Vehicles. The first step to perform the analysis is to combine the accident data with the historical weather conditions. In this article, we will discuss how …