Articles for "weather history"

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 …

How can I download weather history data as a CSV file?

In this article, we will show you how to easily download historical weather data as a standard CSV file that can be imported into thousands of data analysis and storage applications such as business intelligence systems, visualization tools, statistical analysis packages, and databases. If you would like to download weather forecast data as a CSV, …

Guest blog: Your Wedding Weather – How to use weather history to plan your wedding day

Guest blog: Your Wedding Weather - How to use weather history to plan your wedding day

n this guest blog, Wedding Planner Falade Kunle Tom describes how to incorporate historical weather information into your wedding planning It’s over 5 years now that I have been handling events for various clients, especially wedding events. From experience, it is easy to have control over a number of things that include the guest list, …

How to use the Microsoft Excel WEBSERVICE function to retrieve weather data

The Microsoft Excel WEBSERVICE function retrieves data from a URL into a single cell within an Excel worksheet. In this article we describe how to use WEBSERVICE to retrieve weather forecast and historical weather data directly into Excel without the need for macros or scripts. However, is it always the best way to work with …

Replacing the OpenWeatherMap API with Visual Crossing Weather

Visual Crossing is a superior replacement for the OpenWeatherMap API (also known as the OpenWeather API) in both cost and functionality. By offering up to 1000 free results a day and full access to forecast historical data, Visual Crossing Weather makes it easy for everyone to test the API, compare data, evaluate extended weather functionality, …

How to import weather data into Microsoft SQL Server

When you want to drive data analysis of all types including data science and business intelligence applications, loading weather data into a relational databased is often the first step. As one of the most popular database platforms in the world, Microsoft SQL Server is the backend datastore for millions of applications from homebrew to enterprise. …