Articles for "database"

How to add Weather Data to your MicroStrategy project

There are several options available to add historical weather data sets as well as weather forecast or typical weather. Directly from a Visual Crossing Map as a layer, as dynamic cube or directly into your RDBMS data warehouse. This tutorial provides step by step instructions for the first two options. For the direct load into …

Comparing the Visual Crossing Pricing Options to Dark Sky

As you already know, Dark Sky has announced that it is ending its popular weather query API service soon. We’ve already written multiple articles explaining the benefits and details of converting your app or webpage to the Visual Crossing Weather API. In this article, we will compare the pricing models of the two services. Specifically, …

Using Weather Data in Business Intelligence – Part 1

How to find weather data that works well with business intelligence analysis

In this series of three articles we will first discuss how to find weather data that is compatible with both your existing business data and your existing business intelligence systems. Then, in part two we will discuss strategies to analyze historical weather data in conjunction with your BI tools and with your data. Finally, part three will discuss how to apply the insights learned from the historical analysis to make more intelligent decisions using business patterns and weather forecast data.

How are weather metrics calculated over various time periods in different weather queries?

While it may seem like an easily-answered question, sometimes it is not completely obvious what exact time periods are covered by a given weather query and how the weather metrics are calculated. The fact is that the traditional standards and customs of weather reporting make up a standard that although logical may not always appear …

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 use weather to verify insurance claims?

Storm Damage

Insurance professionals are often called upon to verify insurance claims to see if they make sense given the surrounding circumstances. Frequently those claims involve questions relating to weather.  For example, the claimant may report that a heavy storm toppled a tree onto a shed.  Did a storm with destructive winds likely come through the claimant’s …