Prepare your Business for Upcoming Freezing Temperatures

Does your business depend upon knowing when freezing temperatures may occur? Shipping temperatures sensitive items, water pipes/pumps, pouring concrete or outdoor employee safety are just a few areas where businesses can benefit by knowing exactly when a freezing temperature is predicted. Typically, systems like this can be a very expensive IT undertaking but in this …

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 …

Timeline Weather API

The Timeline Weather API is the simplest and most powerful way to retrieve weather data. You can request data over any time window including windows that span the past, present, and future. The API will take care of the combining historical observations, current 15-day forecasts, and statistical weather forecasts to create a single, consolidated dataset …

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 …