Connect Microsoft Power Pivot

CONNECT Microsoft Power Pivot WITH ALL YOUR DATA WITH JUST A FEW CLICKS OR SQL COMMANDS
CONNECT Microsoft Power Pivot WITH
PIPES
Data Virtuality + power pivot
CONNECT Microsoft Power Pivot WITH THE
LOGICAL DATA WAREHOUSE
Data Virtuality + power pivot
Connect Microsoft Power Pivot with all your data

About Microsoft Power Pivot

Power Pivot is a Microsoft Excel ad-in that transforms Excel into a powerful Self-Service BI platform. Power Pivot extends the power of Excel to import millions of rows of data from multiple data sources into a single Excel workbook.

DataVirtuality Benefits


Connect in 5 minutes

DataVirtuality is providing a simple wizard to type in your data source credentials to establish a connection. It only takes minutes and you see your data in a SQL query-able tables instantly after.


SQL Transformation

Query connected data sources with SQL. Query, join and integrate data from Google Analytics, Salesforce, Oracle, MySQL and many more data sources using SQL commands. 


Read and write data

Read and write data from connected data sources. Integrate data into an analytical database and write data back to data sources based on triggers.