Where can I find historical rainfall data?

Announcing the Weather Data Academic & Research Program

Timely, accurate and complete weather data is vital across many disciplines - business analysis, emergency planning, personal investigation and many more. None may be more important than using weather data in academic research and investigations.

To help students, academics and non-profit researchers, we are pleased to announce our Weather Data Academic & Research Program designed exactly for researchers.

Read More
Where can I find historical rainfall data?

Where can I find historical rainfall data?

Historical rainfall data is easy to obtain from various sources, but the best options differ depending upon your needs. Below, we’ll help sort through the options to find the easiest and best way to obtain historical rainfall data for your project.

Read More
How we process the NOAA Integrated Surface Database Historical Weather Data

How we process the NOAA Integrated Surface Database Historical Weather Data

We use a lot of sources for our weather data. One of the richest sources of historical weather data is the Integrated Surface Database (ISD) from NOAA. The amount of data available is impressive. Hourly or subhourly weather records for 1000s of weather stations that are, in some cases, over 100 years old. However obtaining and manupulating the data so that it fits your needs can be a daunting task. In this article we describe some of the lessons we've learned along the way and some of the processes that we use to make the data as useful as possible.

Read More
Create a Growing Degree Days Calculator in Microsoft Excel

Using Microsoft Excel to Analyze Gardening Weather and Climate

Part Three - Create a Growing Degree Days Calculator

In our final part of the series on using Microsoft Excel to analyze Gardening Weather and Climate, we are going to combine past and future weather, so we can create a “Growing Degree Days Calculator”.

Read More
Where can I find historical weather data?

Installing a Microsoft Excel Add-in via Microsoft AppSource

This step-by-step guide will show you how to install a add-in for Microsoft Excel via the Microsoft Office AppSource store.

Read More
Where can I find historical weather data?

Precipitation coverage is the most important weather metric you don't know

Precipitation Coverage is a metric commonly encountered in weather data yet its meaning is often misunderstood. In this post I will discuss the differences and similarities between Precipitation and Precipitation Coverage, and how to gain significant additional value from using Precipitation Coverage in your own analysis.

Read More
Where can I find historical weather data?

Where can I find historical weather data?

If you have spent some time looking for historical weather data, you will have found that finding a reliable source can be a timeconsuming and length affair. In this blog, we are going to use Microsoft Excel to find the historical weather and climate information for a location.

Read More
A gardener's weather forecast in Microsoft Excel

Using Microsoft Excel to Analyze Gardening Weather and Climate

Part Two - Weather Forecast

In this edition of our series on using Microsoft Excel to analyze weather for gardeners, we add a second worksheet to our Gardeners Weather Workbook to summarize the weather forecast for the coming week. Using this information we can then plan our gardening activity and understand whether the weather will affect the garden in a way we need to plan for - will it rain? will it be hot? will there be a frost?

Read More
It's worthing taking time to under weather unit conversions

Weather unit conversion in Microsoft Excel

One of the most common stumbling blocks for people beginning to work with weather data from around the internet and around the world is the myriad of units that you encounter. In this post, we’ll discuss various conversions commonly required for weather data analysis and how to accomplish them efficiently in Excel.

Read More
The London Marathon

Does weather affect the results of the London Marathon?

It's late April and for runners that means it's time for the London Marathon. Can weather change the race? In this blog we investigate how London Marathon finishing times vary with the weather.

Read More
A Mountain of Weather Data

A Mountain of Weather Data

Does the number of people who visit Mount Rushmore depend on the weather? In this blog I investigate the correlation between the daily Mount Rushmore visitor counts and the weather that occurred on those days.

Read More
Using Microsoft Excel to Analyze Gardening Weather and Climate

Using Microsoft Excel to Analyze Gardening Weather and Climate

Part One – Creating an Historical Weather Dashboard

Every plant and every activity that takes place in the garden is dependent on the weather. In this three-part blog series, we are going to use Microsoft Excel to answer common garden weather questions.

Read More
Weather in Microsoft Excel

Weather in Microsoft Excel

Does weather affect my business? This seems like a simple question but as many of us have quickly learned, it is not a simple task. In this blog, Sean discusses how he used Visual Crossing's Weather Add-in for Microsoft Excel to answer five critical questions.

Read More
Five Things to Consider When Placing a new Retail Location

Five Things to Consider When Placing a new Retail Location

Are you a new business owner looking to place your first retail location? Or maybe you looking to expand by adding additional stores? In this post, we are going to use Location Analysis to help identify and analyze possible options for a new store location.

Read More
Using Location Analysis for retail placement in Virginia

Are we in a drive-in theater renaissance?

Explore the demographic and geospatial data behind this nostalgic trend.

Read More

Announcing Visual Crossing Location Analysis

Announcing Visual Crossing Location Analysis, the powerful, new way to use demographics and spatial analysis to optimize your business locations.

Read More

Visualizing Capital Bikeshare Routes on Animated Maps

. We recently found the excellent open data from the Capital Bikeshare, the bike sharing service in the Washington, DC metro area. They have various datasets available, but the largest dataset is the one that looked most fun to map – that one is the full list of individual bike rental trips...

Read More
In a tool such as OpenJump you can move geographic features and also edit attribute data.

A Primer on Shapefiles - part two

In this second part of the series on Shapefiles we discuss how to add shapefiles into the Visual Crossing environment.

Read More
Drive Time Analysis With Customers.

Optimizing store location using Visual Crossing

One powerful use of a geographic analysis tool such as Visual Crossing is to find new and better business locations. Visual Crossing not only brings several valuable tools to bear on this task, but it also makes these tools usable by any typical user of Excel, SAP, or MicroStrategy, not just hardcore GIS experts. There are three areas of analysis that this video demonstrates. Those areas are visualizing store trade and coverage areas, using external demographic data on the map, and calculating driving time areas.

Read More
In a tool such as OpenJump you can move geographic features and also edit attribute data.

A Primer on Shapefiles

If you use mapping and GIS systems more than occasionally you will almost certainly run into the Shapefile data format. While most good mapping systems support various input file formats, the Shapefile format is one of the oldest and most ubiquitous. Visual Crossing is not an exception to this pattern and is totally capable of using shapefiles both as a source for geometries to represent business data as well as external information such as demographics, weather and more. So, if you are going to be working with Shapefiles, it is a good idea to understand a bit about them. In this article is the first in a series, we'll explore some of the fundamentals of the shapefile format.

Read More
Preparing Latitude & Longitude Data for Excel Maps

Preparing Latitude & Longitude Data for Excel Maps

Many mapping tools (and other applications like phones and GPS units) are able to create maps directly from columns containing latitude and longitude data. To use these in Excel-based mapping tools sometimes requires you to modify or transform the data. In this article we're going to go through a number of ways that you can quickly manipulate the latitude and longitude data you already have, and show accurate, high performing maps with 10000s of points.

Read More
Five reasons you should consider maps for your SAP Lumira deployment

Five reasons you should consider maps for your SAP Lumira deployment

Everybody loves maps and you see them cropping in up in products demos and pitches wherever you turn. But should you spend the time and resources to add mapping to your Lumira deployment? Will they save time, money or help my users make better decisions? Here are five reasons why maps aren’t just pretty pictures – they are valuable business analytic tool.

Read More
Visual Crossing supports SAP Lumira Discovery, Designer and SAP Design Studio

Key features of the new Visual Crossing Maps for SAP

We've deployed the latest cloud version of Visual Crossing Maps for SAP. This release is focused on enabling a variety of exciting features for all our cloud based customers in addition to making the maps even easier to use. Here are some of the highlights:

Read More
Visual Crossing Maps allow users to show and analyze the impact of hurricanes

Determining Hurricane Impact Risk in Visual Crossing

A hot topic this season is hurricane risk and impact. Due to the massive damage caused by multiple hurricanes in the 2017 season, businesses and organizations are scrambling to get data on how it affects them. This is one of the classic cases where geographical analysis goes far beyond typical business intelligence.  The ability to do advanced analysis such as a distance buffer capture of data along the path of the storm is invaluable.  Grids and charts simply cannot give enough detail and cannot organize the data geographically.  In this blog entry, we will explore how our customers analyze storms using map tools such as Visual Crossing.

Read More
Map drill from region, state to zip

Using distance-based heat maps and hotspots for improved data analytics

Heat maps and hotspots can be of great value to business users but they often get pushed aside in the GIS world as being statistically insignificant. The complaints of heatmaps relate to with smoothing algorithms as well as the interpolation of data points as not being based on real data. This is true in many cases, but we will discuss the Visual Crossing implementation of heatmaps and why it is different and how we enable our customers to gain significant business value.

Read More
Map drill from region, state to zip

What to expect in the new Visual Crossing for SAP release

This week we will be releasing a major update for the Visual Crossing platform for SAP. Here are the main features we have added to expand the depth of the SAP integration and added major features for cloud based users.

Read More
Map drill from region, state to zip

Map Drilling - give your users more than simple zooming

If you are a user of a Business Intelligence (BI) system like MicroStrategy or SAP, one thing clear is that BI users love their drilling. The ability to start at a simple, high-level dataset and drill down into details has become an invaluable staple of data analysts. Maps are also an essential part of business solutions so it also makes sense that users expect to drill on maps as well - combining the power of drilling and simple map navigation like zooming and panning creates an easy-to-use but extraordinarily powerful analytical experience.

Read More
Visual Crossing Map deeply embedded into Microsoft Excel

Getting started with Maps for Microsoft Excel

Learn how to get started with Visual Crossing map and geospatial analysis in Microsoft Excel.

Read More