DIFFERENCE BETWEEN TABLEAU AND POWER PIVOT | EXCEL

Here we comparing two of the top self-service BI tools on the market, Tableau and Power Pivot. We only discussing the data connection supported by both.

Connection supported by Microsoft Power Pivot vs Tableau

Connection Source	Power Pivot	Tableau
Actian Vectorwise	Yes	No
Aster Database	Yes	No
Cloudera Hadoop	Yes	No
Data Feeds	No	Yes
DataStax Enterprise	Yes	No
EMC Greenplum	Yes	No
Firebird	Yes	No
Google Analytics	Yes	No
Google BigQuery	Yes	No
Hortonworks Hadoop Hive	Yes	No
HP Vertica	Yes	No
IBM DB2	Yes	Yes
IBM Netezza	Yes	No
Informix	No	Yes
MapR Hadoop Hive	Yes	No
Microsoft Access	Yes	Yes
Microsoft Analysis Services	Yes	Yes
Microsoft Excel	Yes	Yes
Microsoft PowerPivot	Yes	No
Microsoft Reporting Services	No	Yes
Microsoft SQL Azure	No	Yes
Microsoft SQL Server	Yes	Yes
MySQL	Yes	No
OData	Yes	Yes
ODBC	Yes	No
OLEDB/ODBC	No	Yes
Oracle	Yes	Yes
Oracle Essbase	Yes	No
ParAccel	Yes	No
PostgreSQL	Yes	No
Progress OpenEdge	Yes	No
Salesforce	Yes	No
SAP HANA	Yes	No
SAP Netweaver Business Warehouse	Yes	No
SAP Sybase IQ	Yes	No
Sybase	No	Yes
Teradata	Yes	Yes
Text File	Yes	Yes
Windows Azure Marketplace	Yes	Yes

And here the Winner is Tableau