Business Intelligence Tools Comparison 2017 Pentaho Vs Power BI Vs Tableau Vs QlickView Vs SAP BO Vs MSBI Vs IBM Cognos Vs Domo Vs DUNDAS Vs Microstrategy

There are many BI tools available in the market and it make it very difficult to choose the right option. Some tools are open source and free of cost and others are licensed. Some have ETL capabilities while others are purely Dashboarding and data visualization toolkits. We have compiled a comparison of some of these tools so that you can make an informed decision.

Parameters	BI - Tools
Launching Year of Tools	2004	2014	2003	1993	2001	1990	2005	1969	2010	1992	1989
Available Versions	Pentaho Community CE Pentaho Enterprise EE	Power BI - Free Power BI Pro(Trial)	Tableau Public - Free Tableau Desktop (14Days free Trial) Tableau Server (free Trial) Tableau Online(free Trial)	QlikView Qlik Sense	JasperSoft Community JasperSoft Enterprise Edition	SAP - Business Object	BIDS --SSIS , SSAS and SSRS comes as a package with SQL server	IBM Cognos -business Object		DUNDAS BI
Free Trials
Operating System Compatibility	Windows, Mac, Linux	Windows Only	Windows and MAC (restricted)	Windows and MAC	Win/Mac/Linux	Win/Mac/Linux	Win/Mac/Linux	Win/Mac/Linux	Win/Mac/Linux	Win/Mac/Linux	Windows and MAC
Open Source
ETL Tool	PDI (Penthao Data Integration)	Inbuild - uses SSAS internally	does not require ETL	does not require ETL	Jasper ETL	BODS	SSIS				Inbuild
Size of Organisations	Any Size	Any Size	Any Size	Any Size	Any Size	Enterprise Business	Any Size	Any Size	Any Size	Enterprise Business	Any Size
Features	Pentaho Features includes Data Visualization , Data Warehousing , ETL , Schema Workbench , weka , PRD report Designer, Hadoop Shims, Works really well with Big Data	Power BI is Powred with features like Self Service Analytics, Data Refinement , Data Warehousing, Data Visualization	Free versions of Tableau has limited Data Sources support but paid versions lets you connect to more data sources Dashboards are self service,more interactive ,lots of chart options to plot data and has best data visualization capabilities , Internal help to find the best chart as per data set. Faster Dashboard Delivery and Tableau Online to share Reports. Features like "Show me" is really helpful	Excellent product that leads way in data discovery and visualisation Qlik View has more interactivity ,gives you lots of options to build charts from, Internal help to find the best chart as per data set. Faster Dashboard Delivery	Analysis, Reporting , ETL, Dashboards,Cloud BI Solutions available.	Takes care of All BI vertical full end to end software with wide presence and market Leader in fortune 100 companies	Data Refinement , Data Warehousing, Data Visualization, CAS Sercurity , Active Directory Management,Cube Management	Reporting, Dashboarding, Analysis , Data Integration, Visualization , Self service Data Analysis, Data Warehousing, Real Time data Analysis	after free trial ,DOMO will take care of all the requirements , No development or platform details provided	45 Days Free Trial , after which DUNDAS will take care of all the requirements , No development or platform details provided.
Category	Free Open Source BI	Free Cloud BI	Proprietary BI Software	Proprietary BI Software	Free Open Source BI	Proprietary BI Software	Proprietary BI Software	Proprietary BI Software	Proprietary BI Software	Proprietary BI Software	Proprietary BI Software
Restrictions	Enterprise functionalities missing in Community Edition: Scheduling of Reports, Active directory integrations, Ad Hoc reporting , Analyzer Grids, No Support facility	Data Refresh: Daily,Data Capacity Limit : 1GB free Data Streaming : 10K rows/hour Power BI cannot be installed on AWS Server	Does not works with Unix/Linux , Limited features in free version, Data that you will use for free version will be made public and Development cannot be done on MAC systems	does not works with Unix/Linux Limited features in free version, Data that you will use for free version will be made public	Enterprise functionalities missing :- Ad Hoc Reporting	adding a new data source is really a big job in SAP BO and also you are fully dependent on SAP Team for implementation	Cannot define color of your choice, poor UI Less chart to choose from, need skilled developers to develop the charts.	Data Capacity : 1,00,000 Records or 500 MB not more than 50 columns
Pros	Free and Open Source, Support for all major data sources , No dependency and gels really well with all cloud systems , good ETL Capabilities, Good Connectivity with hadoop and has Data Mining tool weka	Power BI gives Better Visualization ,Analytics capabilities , Faster Dashboard Delivery, Simple to use and can be adapted by business Users , Self Service BI is something many BI Users need.	A large collection of data connectors and visualizations. Intuitive design, faster and better Analysis, does not require ETL for small scale implementation/ Tableau has pared with informatica for ETL capabilities	Intuitive, easy to deploy, good at joining datasets together	Open source Software with Reporting and Dashboarding Facilities. It provides all the required tool under one umbrella	security and brand name are the biggest pros , company provide trainings and support to its customer,Good for big Enterprises ,Highly Scalable Software.	Highly Secure as the data stays on premises , also strong active directory authentication both at report level and data Level.very well integrates with all Microsoft products like Office and Sql server			Faster and hassle free dashboard delivery without any ETL or Olap Analysis
Cons	Not Stable, Depends highly on community which is not active, Dashboard Building approach is fairly Technical and need knowledge of SQL, HTML and JScript, Self Service BI and Mobile BI are not a part of Community Edition, development time is more compared to other tools, Limited Charts Components,Pentaho Data Integration is often Slow when dealing with Larger Data	Cannot let's you deal with Larger Data sets on free version, Need to learn DAX Queries to work with the tools, less data Sources to connect to in the free version	Bit of a learning curve , does not gels well with all data sources on free versions but connects to all Data Sources in paid versions.	Bit of Learning curve , does not gels well with all data sources on free versions ,comparatively costly	Self Service BI only available in Enterprise Versions,reports are simple and less interactive	Implementation Cost ,Adding new Data source is very messy ,SAP is not very flexible with UI cannot use it for predictive analysis." Confusing Licensing process, frequent support fee hikes	Less Themes and Designs , vanila Dashboards with less interactivity.		they do not take projects less than $50,000 and less likely to negotiate
pricing	CE: FREE	FREE(conditions apply)	FREE(conditions apply)	Trial Free	Free	Free Trial	Free Trial	Free Trial	Free Trial	Free Trial	Free Trial
	EE: Negotiable depend on the components you want for EE visit: www.pentaho.com/contact	Power BI pro : $9.99 /user/hour with 10GB /user ,refreshed hourly with 1M rows/hour	https://www.tableau.com/pricing	$1,350/user and concurrent users are $15,000	Purchase JasperSoft from www.jaspersoft.com	Purchase SAP BO from www.sap.com/india/product/analytics/bi-platform	Need to purchase the SQL server suite with BI capabilities		$50,000 minimum charge to get started and about $1500 per user after that.
Final Analysis/Comments on free versions	Good for companies trying BI for the first time ,Pentaho will help in adapting the whole concept of BI with Zero Cost to Software also Enterprises with internal Technical teams can use Pentaho by training internal team members and enjoying the flexibility of open source pentaho Software. Pentaho is quickly adapting new trends of Analytics which makes it one of the important contender in BI market.	Came as a replacement to Excel by microsoft , for companies who need nearly real time and quick Dashboarding with interactive Visualization. Customers who are ready to pay for subscription charges can get the best in class visualization of Power BI though it needs a knowledge of DAX queries to get the max out of Power BI.	Companies that are already working with Windows and looking for interactive Dashboards and Reports without ETL and without spending much time and money in ETL can use Tableau and can create self service BI, Tableau is a Market Leader in visualization and Supports almost all data sources. Does not uses any DAX which is an added advantage.	Quite similar to Tableau and Power BI but very mature in terms of product as it is one of the oldest Data Visualization and BI Tool. but latest analysis shows it lacks few of the new visualization features that are there in Tableau. but it is as good as Tableau and other BI tools with quite high customer base. launched qlik sense with quite new features in analytics.	Jaspersoft comes with a community edition that almost has all features like pentaho. Mature Player with good presence. but does not have Analytical Features of Predictive Analytics , forecasting which pentaho Has. good for normal enterprise level reporting	A complete Products that takes care of everything. from Reporting to Analytics to Mining and OLAP. Costly in terms of implementation but nothing seems impossible in SAP BO space. qualified team which takes care of everything.	Good for Companies who already uses Microsoft Products and are very very strict in terms of Security of Data. Can compromise with Look and feel but not the Data integrity , Do not need cloud and have self sufficient Infrastructure and In house technical team		Here both the companies Implements everything at their end and there softwares are not available to use freely. after trails you have to pay and get the custom BI.