What users are saying about

Pentaho

100 Ratings

Microsoft BI

594 Ratings

Pentaho

100 Ratings
Score 7.5 out of 101

Microsoft BI

594 Ratings
Score 7.8 out of 101

Add comparison

Likelihood to Recommend

Pentaho

As far as generating and maintaining a data warehouse, Pentaho does an excellent job and I would highly recommend it. For analysis and gaining insight into your data, Pentaho is excellent. For visualization, dashboarding, or executive grade reporting it may not be as beautiful or flashy as your clients require
Jordan Squire profile photo

Microsoft BI

Flexibility, engagement, training resources, updates, cost, implementation, ease of use, support; these are the reasons why I would recommend Power BI. Power BI is best suited for situations where collaboration is needed among several different groups who are working concurrently on different activities. Where there are multiple levels of data that need to be parsed through. It's difficult to think of a scenario where it wouldn't be beneficial other than the obvious.
Jason Leidig profile photo

Feature Rating Comparison

BI Standard Reporting

Pentaho
6.7
Microsoft BI
8.2
Pixel Perfect reports
Pentaho
6.5
Microsoft BI
8.1
Customizable dashboards
Pentaho
6.9
Microsoft BI
8.1
Report Formatting Templates
Pentaho
6.8
Microsoft BI
8.4

Ad-hoc Reporting

Pentaho
6.2
Microsoft BI
8.5
Drill-down analysis
Pentaho
7.1
Microsoft BI
8.6
Formatting capabilities
Pentaho
6.6
Microsoft BI
8.3
Integration with R or other statistical packages
Pentaho
6.2
Microsoft BI
8.3
Report sharing and collaboration
Pentaho
4.9
Microsoft BI
8.8

Report Output and Scheduling

Pentaho
6.6
Microsoft BI
8.7
Publish to Web
Pentaho
6.2
Microsoft BI
8.7
Publish to PDF
Pentaho
7.4
Microsoft BI
8.5
Report Versioning
Pentaho
6.5
Microsoft BI
8.8
Report Delivery Scheduling
Pentaho
6.9
Microsoft BI
8.8
Delivery to Remote Servers
Pentaho
6.1
Microsoft BI
8.5

Data Discovery and Visualization

Pentaho
6.1
Microsoft BI
8.8
Pre-built visualization formats (heatmaps, scatter plots etc.)
Pentaho
6.1
Microsoft BI
9.0
Location Analytics / Geographic Visualization
Pentaho
6.4
Microsoft BI
8.8
Predictive Analytics
Pentaho
5.9
Microsoft BI
8.5

Access Control and Security

Pentaho
7.4
Microsoft BI
8.7
Multi-User Support (named login)
Pentaho
7.5
Microsoft BI
8.8
Role-Based Security Model
Pentaho
7.3
Microsoft BI
8.6
Multiple Access Permission Levels (Create, Read, Delete)
Pentaho
7.4
Microsoft BI
9.0
Single Sign-On (SSO)
Pentaho
7.2
Microsoft BI
8.5

Mobile Capabilities

Pentaho
6.1
Microsoft BI
8.5
Responsive Design for Web Access
Pentaho
5.4
Microsoft BI
8.4
Dedicated iOS Application
Pentaho
6.5
Microsoft BI
8.7
Dedicated Android Application
Pentaho
6.5
Microsoft BI
8.5
Dashboard / Report / Visualization Interactivity on Mobile
Pentaho
5.9
Microsoft BI
8.5

Application Program Interfaces (APIs) / Embedding

Pentaho
6.0
Microsoft BI
8.4
REST API
Pentaho
6.7
Microsoft BI
8.6
Javascript API
Pentaho
6.3
Microsoft BI
8.4
iFrames
Pentaho
5.0
Microsoft BI
8.4
Java API
Pentaho
5.9
Microsoft BI
8.3
Themeable User Interface (UI)
Pentaho
5.6
Microsoft BI
8.7
Customizable Platform (Open Source)
Pentaho
6.4
Microsoft BI
8.0

Pros

  • The Data Integration tool is fantastic. A novice user can get up to speed quickly with it and the GUI is intuitive
  • Support. As an enterprise customer, I am always thrilled with the fast turnaround on support tickets that I open.
  • Job Scheduling. The Job scheduler is easy to use and very reliable
  • Data Analyzer Tool in "User Console". The drag and drop UI makes it easy for me end users to see the data in whatever way suits them. They can even GEO-MAP the data instantly!!
Sandro Frattura profile photo
  • Connecting andJoining Multiple Data Sources Together - Multi-Dimensional SSAS
  • Usability in Report Creation for Business Analysts (Excel via Analysis Services specifically), Executives (Performance Point and Power BI) and Power Users (Report Builder)
  • Collaboration (via SharePoint only, before the release of Power BI Designer)
  • Speed of Analysis - Specifically when leveraging SSAS on databases up to 5 TB
  • Speed of ETL processing - Multiple Parallel Sequential Jobs with SSIS/DTS
Lee Cullom profile photo

Cons

  • Pentaho could use some improvement of the integration of ldap into the User Console. We have unsuccessfully been able to deploy the Pentaho User Console to partners because it does not support a federated ldap model. Even attempts at integrating to our primary ldap has proven fruitless.
  • The Pentaho Suite as a whole tends to be a resource hog. Since we work with such large data sets we often find that large requests hang up or get an "oops error" which is a standard Pentaho error when the data set is too large. It would be nice to have some indication of our limits so that we are not guessing or we can limit the data set up front.
  • Upgrades on the Suite are a bit cumbersome for our Administrators. There is not a standard backup and install package so upgrades often involve our administrator on the phone with Pentaho during the upgrades to walk through a custom install.
Stephanie Dozier profile photo
  • The development tools for Microsoft BI in SQL Server 2012 and up are in a bit of flux at the moment. Initially with SQL Server 2012 they were all fully integrated and available with the installer, but now they have moved to it being a separate web download that you have know which version you need to get it working correctly with the version of SQL Server you are working on. Thankfully all of these tools still use Visual Studio as the starting point, but it would be nice to see the tools better integrated going forward and still able to be updated on a regular basis.
  • SSRS has not seen any major updates in the last couple of versions of SQL Server and it could really benefit from some of the new advancements that Microsoft has made with the Power BI line of products that are only available if you use the cloud based Office 365 service. It would be really nice to see some of the features that are available in Power BI added to SSRS to make it a more complete web based reporting tool and more accessible to end users as well as IT.
Steve Wake profile photo

Likelihood to Renew

Pentaho8.8
Based on 11 answers
Pentaho continues to fulfill our needs as previously described. We are regularly finding new uses for it as we expand our business and our technology stack.
Kenneth Panacy profile photo
Microsoft BI8.0
Based on 25 answers
The primary reason I give this a 10 is because of my previous experience with Microsoft. While I can be effective with other tools and solutions, my experience is primarily focused on the Microsoft solution stack and surrounding tools. Some people are Java-centric, some are C#-centric; I am Microsoft SQL Server-centric. Even with the explosion of "big data" tools, I always seem to gravitate toward the Microsoft solution because I know and understand it better than any other solutions.
Chris Utter profile photo

Usability

Pentaho5.0
Based on 1 answer
I would have liked some hands on help in trying to match what Customers were already used to. Plus having a team of Java/BI folks was difficult to assemble since what required to be done in an object oriented fashion could have easily been done via a SQL construct. This hash of technologies was difficult to manage.
Deepak Paramanand profile photo
Microsoft BI7.0
Based on 5 answers
The product is very usable compared to competitive solutions. I didn't give it a full 10 because Microsoft needs to improve their Report Builder module.
Robert Goodman profile photo

Reliability and Availability

No score
No answers yet
No answers on this topic
Microsoft BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

Performance

No score
No answers yet
No answers on this topic
Microsoft BI7.0
Based on 2 answers
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
Robert Goodman profile photo

Support

Pentaho9.9
Based on 2 answers
They were responsive to our questions when we raised issues.They gave us workarounds when required.They were quite knowledgeable when it came to issue analysis and providing fixes.They were forthright in informing us if a bug was not due for release soon.
Deepak Paramanand profile photo
Microsoft BI7.1
Based on 6 answers
We are not currently utilizing Microsoft's technical support.
Robert Goodman profile photo

In-Person Training

No score
No answers yet
No answers on this topic
Microsoft BI6.9
Based on 3 answers
This training was more directed toward what the product was capable of rather than actual programming.
Stephanie Grice profile photo

Online Training

Pentaho9.5
Based on 2 answers
Course Taken: DI1000 Pentaho Data Integration FundamentalsSetup A week before your class started, the instructor will start sending out class material and lab setup instructions. This is helpful so that you understand how the environment is laid out and can start reviewing the content. Ultimately it saved about a 1/2 day trying to setup with 10 other people online which was great! The CourseThe 3-day course was laid out like many other technical classes with 15-30 minutes instruction and 15-60 minutes of lab exercises. The instructor was very knowledgeable with the functionality from version to version and answered questions as we went along. I was amazed at some of the functionality that was available that I was not using at the time and quickly implemented changes to many existing transformations and jobs. The novice users seemed to catch on quickly and more experienced users explained how some of the functionality was used in their home environments. Towards the end there was enough time so that we were able to ask very directed questions about our own environments. Overall, I really found the class to be informative and deliver enough information to be dangerous. My skills improved and I was able to design better and efficient transformations for the HIE. Course Description: https://training.pentaho.com/instructor-led-training/pentaho-data-integration-fundamentals-di1000
Stephanie Dozier profile photo
Microsoft BI8.5
Based on 2 answers
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
Sean Brady profile photo

Implementation

Pentaho5.0
Based on 1 answer
Get the right people in before starting implementation. Start small and build as you go approach is time consuming and involves lot of rework.Evangalize within the organization the capabilities and limitations equally so that correct delivery expectations are set.Set expectations with the Customer that the tool cannot replace proprietary software in terms of stability/usability and that timelines could change given the new ness of the product.
Deepak Paramanand profile photo
Microsoft BI9.6
Based on 7 answers
Thorough project planning and requirements gathering ensured project's success.
Boris Skylar profile photo

Breadth of Deployment

Typically system analysts, business analysts and departmental managers were our target audience. 10-15 users was the most we could reach before we decided to go with another suite of Products. But who ever used it did appreciate the end to end flow of data that they could see as opposed to the data obfuscation they noticed before.
Deepak Paramanand profile photo
I have implemented Microsoft BI in small departments with less than 10 people all the way up to full enterprise deployments with multiple IT groups and 1000's of users. The only difference will be what of the provided Microsoft BI tools will you use and how many servers will it all be installed on. Once it is setup it is very easy to keep up-to-date and even expand in the future. Some of the tools do need more IT involvement to get up and running, but once it is setup and working it can easily go into a hands-off setup and just works. I have been oncall support for an enterprise SSRS deployment that was on multiple servers across multiple data centers and only received calls of issues once or month or less and most of time those were cause by human error and not following the procedures that were established.
Steve Wake profile photo

Alternatives Considered

It has been too long since we did the research (over three years) before choosing Pentaho so I cannot remember exactly which competing products we looked at. In the end, the problem with all the others was that they were too expensive for our small company. Pentaho was reasonably priced and was exactly what we were looking for.Microsoft, Oracle, SAP, SAS all provide similar, but very expensive products.
Kenneth Panacy profile photo
With over 20 years in IT, I have experienced a full range of relational and non-relational data solutions, from Oracle and Informix to MongoDB and Hadoop. In my opinion, the Microsoft BI stack is the most complete, well-rounded, high performing data management system on the planet right now. More and more, the ability to make data-driven decisions sets organizations apart from their competitors, and no one offers a better solution than Microsoft and its partners. As more and more of what we do in business life moves to the cloud, Microsoft is again leading the way with its Azure platforms.
Chris Utter profile photo

Collaboration and Sharing

Pentaho7.3
Based on 14 answers
Pentaho offers the possibility of sending to XLS, PDF or CSV, once saved on your local computer you can share with anyone. Reports used for PDF must have a special design from the start. Also, a special schedule to send report can be created in the .xaction and is working fine.
Mihaela Olariu profile photo
Microsoft BI8.2
Based on 27 answers
It is easy to export anything you build in Microsoft BI to Excel or other tools and then share it from there. With SSRS being a web based reporting tool, that makes it very easy to share reports with anyone that has access to the internet or the network. At this point the weak point in report accessibility is on tablets and smartphones, Microsoft is working to make all of their tools HTML5 compliant, but it is not there yet. Security for all of the tools is baked in and is easy to setup if you already have a Microsoft Active Directory infrastructure. If you are not using Microsoft Active Directory you can still enhance the tools to use your own security tools without a lot effort. I believe that in the very near future this rating will be a 10 as well, once all of the tools are supported on all platforms using established standards.
Steve Wake profile photo

Data Integration

Pentaho7.3
Based on 14 answers
This is one of the areas where I think pentaho has done a great job--and with every iteration of the product they seem to include more and more data sources to connect to. Given the data we've been working with, I don't think we've come across a situation yet where we haven't had a relatively simple connector to use.
Ivan Miller profile photo
Microsoft BI8.7
Based on 26 answers
There is no data that I have not been able to get with the Microsoft BI tools. The tools will accept flat files and access any database that has a way to query it, even if that is through a web API. If you need to get some data into a Microsoft BI solution, there is a way to do it. You can go down the custom development route if you have to, but in most cases there is someone else that has tried to do the same thing and shared their solution online for you to use. The Microsoft BI tools are used in so many different companies and scenarios that it is very rare these days that you are first one doing something. There is also the speed factor, depending on the source of the data I have run into more issues with the source systems not being able to keep up with the processing on the Microsoft BI side.
Steve Wake profile photo

Return on Investment

  • Good client feedback - caters to specific requirements
  • Low learning curve for new staff
  • Good community backup
No photo available
  • Business users easily learned self service BI with training and what to do and what not to do with self service BI
  • Learning curve for Powerpivot and other office 365 tools for IT team who already knew about data warehousing concepts is steep
No photo available

Pricing Details

Pentaho

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Pentaho Editions & Modules
Pentaho
Additional Pricing Details

Microsoft BI

General
Free Trial
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No
Microsoft BI Editions & Modules
Microsoft BI
Edition
Power BI
$0
Power BI Pro
$102
2. per user per month
Additional Pricing Details