Microsoft BI vs. Pentaho

As of June 2019, Microsoft BI is ranked 2nd in Business Intelligence (BI) Tools with 40 reviews vs Pentaho which is ranked 20th in Business Intelligence (BI) Tools with 3 reviews. The top reviewer of Microsoft BI writes "The ability to perform complex business modeling through DAX calculations stands out in a crowd". The top reviewer of Pentaho writes "Increases productivity and lowers costs, though should improve the construction of its dashboards". Microsoft BI is most compared with Oracle OBIEE, Tableau and IBM Cognos. Pentaho is most compared with Knowage, Tableau and Microsoft BI. See our Microsoft BI vs. Pentaho report.
Cancel
You must select at least 2 products to compare!
Microsoft BI Logo
87,452 views|41,939 comparisons
Pentaho Logo
36,692 views|9,124 comparisons
Most Helpful Review
Find out what your peers are saying about Microsoft BI vs. Pentaho and other solutions. Updated: May 2019.
347,745 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
There was a lot of manual work involved with Excel, whereas once we moved on to Microsoft Power BI, it was a cleaner dashboard and it was faster too.The uploading of information is very easy, as you just use an Excel sheet to start work right away and obtain the benefits of Power BI.Because this solution is very easy, and very visual, you can have results in minutes.It is a good platform for data analysis, organization, and all of the other interim performances that are necessary.Tech support is very helpful.My primary use is for view of the dashboard.It ingegrates nicely with Office 365.It is a powerful tool that helps our data analysis processes.

Read more »

Easy to use components to create the job.I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced.

Read more »

Cons
I think because I'm moving more into RPA, I'd definitely like to see integration across the RPA, Power BI, or Tableau platforms, because that integration could then make automation and mundane reporting much faster.I would like to see the product offer more graphics to impact different audiences.I would like to see a feature that connects with a Machine Learning platform like a RapidMiner or Azure Machine Learning Studio. It would be great to have a Machine Learning application link to connect.It could have more of a hold on big data. Manipulating big data on this solution complicates things. This needs to be improved.We did have some issues building the Microsoft blog.Powerpoints are not available in the report server.The report server feature is quite limited.It would be nice to use other connectors to link with the data.

Read more »

Logging capability is needed.Version control would be a good addition.Pentaho, at the general level, should greatly improve the easy construction of its dashboards and easy integration of information from different sources without technical user intervention.

Read more »

Pricing and Cost Advice
I very much recommend the free trial mode.It is reasonably priced.No comment on pricing.It is a cheap solution for our needs.No comment.It is free.It is part of our Office 365 license.The costs are small and the benefits are high.

Read more »

Free and commercial versions are available.

Read more »

report
Use our free recommendation engine to learn which Business Intelligence (BI) Tools solutions are best for your needs.
347,745 professionals have used our research since 2012.
Ranking
Views
87,452
Comparisons
41,939
Reviews
41
Average Words per Review
344
Avg. Rating
8.0
Views
36,692
Comparisons
9,124
Reviews
3
Average Words per Review
270
Avg. Rating
7.7
Top Comparisons
Compared 13% of the time.
Compared 10% of the time.
Compared 6% of the time.
Compared 28% of the time.
Compared 14% of the time.
Compared 13% of the time.
Also Known As
SSRS, SSAS, MSBI, MS BI, MS Reporting Services, Power BI, Microsoft BI Tools, Microsoft Big Data, Power BI ProPentaho Business Analytics, Kettle
Learn
Microsoft
Hitachi
Overview

Microsoft BI is a business intelligence solution that turns data into insightful and useful business information that is relevant to all levels of the business.

Microsoft BI combines familiar Microsoft tools - Office, SharePoint, and SQL server, with extra features for end-users, such as Power View and Power Pivot. This powerful product gives businesses a competitive advantage by allowing end-users to better analyze their data, collaborate and better present their data.

Pentaho is an open source business intelligence company that provides a wide range of tools to help their customers better manage their businesses. These tools include data integration software, mining tools, dashboard applications, online analytical processing options, and more.

Pentaho has two product categories: There is the standard enterprise version. This is the product that comes directly from Pentaho itself with all of the benefits, features, and programs that come along with a paid application such us analysis services, dashboard design, and interactive reporting.

The alternative is an open source version, which the public is permitted to add to and tweak the product. This solution has its advantages, aside from the fact that it is free, in that there are many more people working on the project to improve its quality and breadth of functionality.

Offer
Learn more about Microsoft BI
Learn more about Pentaho
Sample Customers
Konica Minolta, Klout, Mahindra Satyam, The Weather Channel, Argus, Credit Suisse, NCR, and Sysmex. Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
Top Industries
REVIEWERS
Financial Services Firm17%
Energy/Utilities Company17%
Manufacturing Company13%
Logistics Company8%
VISITORS READING REVIEWS
Financial Services Firm22%
Healthcare Company11%
Comms Service Provider7%
Government6%
REVIEWERS
Software R&D Company15%
Financial Services Firm15%
Transportation Company8%
Energy/Utilities Company8%
VISITORS READING REVIEWS
Financial Services Firm25%
Comms Service Provider13%
Retailer12%
Non Tech Company7%
Company Size
REVIEWERS
Small Business40%
Midsize Enterprise13%
Large Enterprise47%
VISITORS READING REVIEWS
Small Business36%
Midsize Enterprise11%
Large Enterprise52%
REVIEWERS
Small Business45%
Midsize Enterprise19%
Large Enterprise35%
Find out what your peers are saying about Microsoft BI vs. Pentaho and other solutions. Updated: May 2019.
347,745 professionals have used our research since 2012.
We monitor all Business Intelligence (BI) Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.

Sign Up with Email