Using Weather Data in Business Intelligence – Part 3
How to make intelligent decisions using BI and weather forecasts
Now, armed with the insights that we found in part two, we are ready to apply those insights using weather forecasts. As we did when analyzing our historical business records using weather history, we will use the high-quality weather data service that we identified in part one of this article series. Then, we will join this data with our business locations. Only this time, instead of finding existing patterns we will apply the patterns discovered to make more intelligent decisions.
Using Weather Data in Business Intelligence – Part 2
How to analyze business data using historical weather records
In this article we will continue where part one stopped. Once high-quality, BI-friendly weather data has been found, we next need to understand how it can be used to analysis historical business data, Most business intelligence systems have a warehouse containing years of business records including locations and dates. This article will show how to match those records to weather data and identify useful patterns and trends.
Using Weather Data in the Legal Profession
Lawyers, paralegals, and other members of the legal profession often need high-quality weather data to help them better understand and prove their cases. However, the requirements for this data are often somewhat different than in other weather data use cases. Unlike other data users who often need a large amount of data representing a broad …
Continue reading “Using Weather Data in the Legal Profession”
Weather Alerts for Excel
Filter and Alert on Large Volumes of Weather Forecast Data. The Weather Alert Workbook is designed for the end-user who wants to query a large number of site forecasts and be alerted to exceptional weather conditions at those locations. It is a free Excel Workbook for all of our users to download and use and/or …
Weather Workbook for Excel – Customization
Learn how the Weather Workbook is constructed and how you can modify it to make your own custom interface. Background Many of you may already be familiar with the Visual Crossing Weather Workbook for Excel. If you are note and want to learn more we encourage you to first download the workbook and pull data …
Continue reading “Weather Workbook for Excel – Customization”
Getting Started With Weather Data Services
Weather Data Services provides an easy way to access weather forecast data, historical weather observation data and historical summary data. The data is accessible in three ways – directly in the browser, as a data download or as a Restful API link. We will show you how to build the query in your browser and how …
Continue reading “Getting Started With Weather Data Services”
How to Find Weather Data for your Next Data Science Project
The use of weather data in data science is hugely varied and there are applications in all applied verticals. However at the heart of all data science projects are accurate, trustworthy weather datasets. In this article, we’ll explain the types of weather data available for data science, how to get them, how to make sure …
Continue reading “How to Find Weather Data for your Next Data Science Project”
How can I load historical weather data into Google Sheets?
In this article, I’m going to show you how to easily load historical weather data into Google sheets. We’ll walk through the process step-by-step showing you how to construct the query in Visual Crossing Weather and then use the query URL to import the weather results into Google Sheets. Also see our companion article that …
Continue reading “How can I load historical weather data into Google Sheets?”
Will the weather be nice on my vacation?
The Summer might may be drawing to a close but there is still time to squeeze in a vacation before the weather turns colder and it is more suitable for skiing than sunbathing outside. Planning a fall vacation can be extremely rewarding but one of the most important questions that arises typically is, “Can you …
Using Microsoft Excel to Analyze Gardening Weather and Climate – Part 1
PART 1 – CREATING AN HISTORICAL WEATHER DASHBOARD It’s hard to think of an activity that depends on the weather and climate more than gardening. How cold does my location get? When is the last frost date? Is it too hot for this kind of plant? Do I need to water, or will it rain …
Continue reading “Using Microsoft Excel to Analyze Gardening Weather and Climate – Part 1”