How to integrate OpenWeatherMap API in Microsoft Power Pivot

Learn how to connect OpenWeatherMap API and Microsoft Power Pivot and instantly get access to your data.

About OpenWeatherMap API

Open Weather Map API is providing current and historical weather data. Furthermore it includes an up to 16 day weather forecast, map layers, the UV index and air pollution data.

About Microsoft Power Pivot

Power Pivot is a Microsoft Excel ad-in that transforms Excel into a Self-Service BI platform. Power Pivot extends the capabilities of Mirosoft Excel to import larger amounts of data from multiple sources into a single Excel workbook. Users can create more sophisticated data models and run more comprehensive analyses.

What is DataVirtuality?

DataVirtuality enables companies to build an agile BI stack in 1 day. It connects to OpenWeatherMap API, Microsoft Power Pivot and more than 150 other databases and cloud services. All connected data sources can be directly queried with SQL and data can be moved into any analytical database. Customers of the DataVirtuality Logical Data Warehouse are digital businesses with the highest flexibility needs.

IMMEDIATE ACCESS TO DATA

Connect over 150+ databases, cloud services and files (XML, CSV, etc.) in minutes. Query data with your favorite analysis tools.

CENTRAL DATA MODEL

Set uniform definitions for their data and apply them to their analysis tools, regardless of the underlying data source.

ALL QUESTIONS IN SQL

With DataVirtuality you can query all data sources with SQL. NoSQL, CSV or XML File: We transform any connected data source in SQL.

REAL TIME REPORTING

DataVirtuality controls the exchange of data between all databases, cloud services, and analysis tools to help everyone in their organization get the information they need.