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 historical weather data is updated
Visual Crossing combines multiple nearby weather reports into a single hourly report. This is done through interpolation which is a powerful feature of the Visual Crossing system for locations that are not near a major reporting station, or where the geography is such that it can create temperatures changes in a short distance. This feature …
How to replace the Dark Sky API using the Visual Crossing Weather API
With the Dark Sky API shutting down in a few months, now is the ideal time to convert your weather application to use a more stable provider. The Visual Crossing Timeline Weather API provides the direct replacement that you need to minimize your conversion effort and ensure that you data costs remain stable. Both the …
Continue reading “How to replace the Dark Sky API using the Visual Crossing Weather API”
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?”
Weather Workbook for Excel
Visual Crossing has introduced a new Query Builder tool scheduling service for creating bulk, scheduled datasets that can be downloaded at any time. We have updated Weather Workbook to download these datasets directly into Excel. In this blog we will show you how to get the Weather Workbook, enable it with your own link and …
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 …
How to look up weather by address
The Weather API and Weather Data Services page allows the user to request weather data by a location value. The location value includes the ability to specify an address or partial address. The location value can also be a latitude and longitude value, a US zip code or weather station ID. When specifying the address, …
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 …
Continue reading “How to use the Microsoft Excel WEBSERVICE function to retrieve weather data”
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. …
Continue reading “How to import weather data into Microsoft SQL Server”