Pragmatic – Leading provider of open source business applications OpenERP, Ruby on Rails, Node.js, Talend, jaspersoft  – Pragmatic
Beyonce Adams

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.

Leave a Reply

Subscribe to Blog via Email.

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Related Posts