Compare Microsoft BI vs. Pentaho

Microsoft BI is ranked 2nd in Business Intelligence (BI) Tools with 29 reviews while Pentaho is ranked 20th in Business Intelligence (BI) Tools with 2 reviews. Microsoft BI is rated 8.2, while Pentaho is rated 8.6. The top reviewer of Microsoft BI writes "Valuable dashboard and automated reporting features but should have better integration with RPA and Tableau platforms ". On the other hand, the top reviewer of Pentaho writes "Pentaho is best fit for small and medium enterprises where the quantity of data and the workload are not critical". Microsoft BI is most compared with Oracle OBIEE, Tableau and IBM Cognos, whereas 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
49,789 views|42,620 comparisons
Pentaho Logo
12,071 views|7,872 comparisons
Most Helpful Review
Find out what your peers are saying about Microsoft BI vs. Pentaho and other solutions. Updated: September 2019.
371,917 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.

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.

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.
371,917 professionals have used our research since 2012.
Ranking
Views
49,789
Comparisons
42,620
Reviews
29
Average Words per Review
318
Avg. Rating
8.3
Views
12,071
Comparisons
7,872
Reviews
2
Average Words per Review
255
Avg. Rating
8.5
Top Comparisons
Compared 13% of the time.
Compared 9% of the time.
Compared 6% of the time.
Compared 27% of the time.
Compared 15% 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
Energy/Utilities Company16%
Financial Services Firm16%
Manufacturing Company12%
Logistics Company8%
VISITORS READING REVIEWS
Software R&D Company21%
Financial Services Firm11%
Comms Service Provider9%
Government7%
REVIEWERS
Software R&D Company15%
Financial Services Firm15%
Energy/Utilities Company8%
Consumer Goods8%
VISITORS READING REVIEWS
Software R&D Company17%
Financial Services Firm17%
Comms Service Provider14%
Retailer12%
Company Size
REVIEWERS
Small Business38%
Midsize Enterprise15%
Large Enterprise47%
VISITORS READING REVIEWS
Small Business31%
Midsize Enterprise11%
Large Enterprise58%
REVIEWERS
Small Business45%
Midsize Enterprise19%
Large Enterprise35%
Find out what your peers are saying about Microsoft BI vs. Pentaho and other solutions. Updated: September 2019.
371,917 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