How to load weather data into Information Builders ibi WebFOCUS using the REST API

This article shows the necessary steps to quickly and easily load weather forecast data for any location of the world into the cloud solution ‘Information Builders ibi WebFOCUS’ for further analysis.  The tutorial shows step-by-step how to construct the query in the Visual Crossing Weather web interface, how to access the automatically generated connection string …

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 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 to load historical weather data into any database

Many business intelligence, data science, and academic research projects need high quality historical weather data to be available in a database. Weather data is typically quite large in volume, and its analysis often requires processing thousands or even millions of detailed records in order to find valuable patterns and apply them to the task at …

How to load weather forecast data into TIBCO Spotfire via ODATA request

This article shows the necessary steps to quickly and easily load weather forecast data for any location of the world into TIBCO Spotfire via ODATA request.  The tutorial shows step-by-step how to construct the query in the Visual Crossing Weather web interface, how to access the automatically generated connection string and then create a data …

How to add historical weather data to TIBCO Spotfire via ODATA request

This article shows the necessary steps to quickly and easily load historical weather data sets for any location of the world into TIBCO Spotfire via ODATA request.  The tutorial shows step-by-step how to construct the query in the Visual Crossing Weather web interface, how to access the automatically generated connection string and then create a …

How to load weather forecast data as a Microsoft Excel XLSX file

This articles shows how to download weather forecast data as a standard Excel file format that can be opened into Microsoft Excel or imported into other applications that understand the Microsoft Excel XLSX format. If you would prefer, you can also download weather data in CSV format. See how to download weather forecast data or …