What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
677 Ratings
105 Ratings

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
677 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8 out of 101
105 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.4 out of 101

Likelihood to Recommend

Microsoft BI

I found that Tableau is more efficient in providing options to calculate measures, percentages as compared to MS BI Power Pivot. Also, Tableau is more web-friendly. However, analytic capability is well suited in Microsoft BI. Microsoft BI is well suited in larger organization setup which requires various integration with external line of business applications. Sometimes, the cost impact can be bigger for smaller organizations as they look for savings while shopping for minimum viable product.
Ved Mishra profile photo

Pentaho

Do you need to integrate data from multiple sources? Pentaho is great for this. Previously, we were SSHing files around and importing with numerous cron scripts.Are your Finance and Marketing teams constantly asking for one-off queries? Pentaho puts this power in THEIR hands so they can pull and arrange the data they want into whatever view they want.Do you want to pay too much for a full-featured BI solution? Pentaho is very reasonably priced, and even has a free version!
Kenneth Panacy profile photo

Feature Rating Comparison

BI Standard Reporting

Microsoft BI
8.0
Pentaho
7.6
Pixel Perfect reports
Microsoft BI
7.8
Pentaho
7.6
Customizable dashboards
Microsoft BI
7.9
Pentaho
8.0
Report Formatting Templates
Microsoft BI
8.2
Pentaho
7.3

Ad-hoc Reporting

Microsoft BI
8.4
Pentaho
6.5
Drill-down analysis
Microsoft BI
8.2
Pentaho
7.2
Formatting capabilities
Microsoft BI
8.4
Pentaho
7.1
Integration with R or other statistical packages
Microsoft BI
8.2
Pentaho
6.3
Report sharing and collaboration
Microsoft BI
8.9
Pentaho
5.3

Report Output and Scheduling

Microsoft BI
8.2
Pentaho
6.8
Publish to Web
Microsoft BI
8.3
Pentaho
6.2
Publish to PDF
Microsoft BI
8.8
Pentaho
7.7
Report Versioning
Microsoft BI
8.1
Pentaho
6.8
Report Delivery Scheduling
Microsoft BI
7.5
Pentaho
7.1
Delivery to Remote Servers
Microsoft BI
8.2
Pentaho
6.2

Data Discovery and Visualization

Microsoft BI
8.1
Pentaho
6.3
Pre-built visualization formats (heatmaps, scatter plots etc.)
Microsoft BI
8.4
Pentaho
6.3
Location Analytics / Geographic Visualization
Microsoft BI
7.9
Pentaho
6.7
Predictive Analytics
Microsoft BI
8.1
Pentaho
5.8

Access Control and Security

Microsoft BI
8.3
Pentaho
7.2
Multi-User Support (named login)
Microsoft BI
8.4
Pentaho
7.5
Role-Based Security Model
Microsoft BI
8.1
Pentaho
7.2
Multiple Access Permission Levels (Create, Read, Delete)
Microsoft BI
8.5
Pentaho
7.2
Single Sign-On (SSO)
Microsoft BI
8.4
Pentaho
6.9

Mobile Capabilities

Microsoft BI
8.2
Pentaho
6.4
Responsive Design for Web Access
Microsoft BI
8.2
Pentaho
6.2
Dedicated iOS Application
Microsoft BI
8.4
Pentaho
6.4
Dedicated Android Application
Microsoft BI
8.1
Pentaho
6.4
Dashboard / Report / Visualization Interactivity on Mobile
Microsoft BI
8.2
Pentaho
6.6

Application Program Interfaces (APIs) / Embedding

Microsoft BI
7.8
Pentaho
6.2
REST API
Microsoft BI
7.9
Pentaho
7.2
Javascript API
Microsoft BI
8.3
Pentaho
6.7
iFrames
Microsoft BI
7.7
Pentaho
5.6
Java API
Microsoft BI
7.6
Pentaho
6.2
Themeable User Interface (UI)
Microsoft BI
7.8
Pentaho
5.5
Customizable Platform (Open Source)
Microsoft BI
7.5
Pentaho
6.3

Pros

Microsoft BI

  • The interfaces of the products are familiar to most people that currently use Microsoft products so its comfortable in that respect
  • Creating a report is easy to do with drag/drop functionality. You also have alot of dropdowns. You can use formulas the same way you do in Excel. They have "expressions" which are like formulas with a mix of SQL.
  • Publishing a report to the server is simple as well. You go to the server and upload the file from your file directory.
  • Setting up subscriptions is simple as well. Anyone can do it with minimal knowledge. Its sort of like creating a recurring calendar event.
  • The hierarchy within SSRS is intuitive. A Project is the top level item. You can add as many reports as you want to a project. Similar to any other IDE where you keep all your files in one project (HTML, CSS, JavaScript, JSP, Servlet) except in the case of SSRS its all reports.
  • Whether you choose to use 2008 or 2012 the interface is layed pretty much the same. So if you start of in 2008 and then upgrade, you dont have to re-learn anything. Their are slight differences in the two versions but it wont hinder your ability to build a report.
Mashhood Syed profile photo

Pentaho

  • Pentaho works as advertised -- it provides a truly drag-and-drop customizable interface for your data.
  • The Enterprise Suite has everything you need to start working and showing results right away.
  • Pentaho's customer support has been responsive and timely when we've had issues.
Kenneth Panacy profile photo

Cons

Microsoft BI

  • The end-user reporting tool, Report Builder, is not that flexible. We feel that the Cognos Report Studio tool is more robust in this area.
Robert Goodman profile photo

Pentaho

  • Heavy software to install
  • Requires licensing to enable all features
  • Difficult to integrate with other servers
No photo available

Likelihood to Renew

Microsoft BI

Microsoft BI 8.0
Based on 25 answers
We are pleased with the Microsoft BI solution, its cost, benefit, and our ability to easily find resources to support this technology stack.
Robert Goodman profile photo

Pentaho

Pentaho 8.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

Usability

Microsoft BI

Microsoft BI 7.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

Pentaho

Pentaho 5.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

Reliability and Availability

Microsoft BI

Microsoft BI 9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

Pentaho

No score
No answers yet
No answers on this topic

Performance

Microsoft BI

Microsoft BI 7.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

Pentaho

No score
No answers yet
No answers on this topic

Support

Microsoft BI

Microsoft BI 7.1
Based on 6 answers
I am basing this rating not on Microsoft's paid premium support, but rather on the resources available (both from Microsoft and 3rd parties) to BI consumers. There is such a huge community working with and building solutions with the Microsoft BI stack (SQL Server) that I have always been able to find a solution (or at least a workaround) to any problems that have come up.
Sean Brady profile photo

Pentaho

Pentaho 9.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

In-Person Training

Microsoft BI

Microsoft BI 6.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

Pentaho

No score
No answers yet
No answers on this topic

Online Training

Microsoft BI

Microsoft BI 8.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

Pentaho

Pentaho 9.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

Implementation

Microsoft BI

Microsoft BI 9.6
Based on 7 answers
Be prepared to help business users define their data. We found that different campuses had different definitions for the same thing. This took some change management and negotiating to get each team to come to a common understanding.
Robert Goodman profile photo

Pentaho

Pentaho 5.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

Alternatives Considered

Microsoft BI

Microstrategy - I went with Microsoft BI because of features, usability, integration capabilities, performance, availability of talent, cost, and end-user (self-service) capabilities.
Sean Brady profile photo

Pentaho

In terms of price, pentaho seems to be the clear winner for functionality that you get--especially with the community edition. If you don't need to license anything out, even the enterprise edition is fairly reasonably priced. With this in mind, it's a winner in the sense that it provides 95% of the data integration functionality that these other tools do without having to spend a fortune to do so.
Ivan Miller profile photo

Return on Investment

Microsoft BI

  • At the moment, the lack of use of Power BI has indered our market progression IMO
  • A large majority of customers keeps the solution once implemented, very few have switched platform
  • Once organizations implement Office 365, the potential for added business with Microsoft BI will really manifest. At this time, the slow adoption of Office 2013 or more recent is limiting the analysis and visualizations capabilities of our average client.
Charles Saulnier profile photo

Pentaho

  • Good client feedback - caters to specific requirements
  • Low learning curve for new staff
  • Good community backup
No photo available

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

Pentaho

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Pentaho Editions & Modules

Pentaho
Additional Pricing Details

Add comparison