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 …

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 …