We performed a comparison between Microsoft Power BI and Pentaho Business Analytics based on real PeerSpot user reviews.
Find out in this report how the two Reporting solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable feature of Microsoft BI is its visualization and its ease of use."
"The most valuable feature is integration with Python."
"My favorite feature is the power query editor, where it can do the data transformations."
"It is very well integrated with other Microsoft products, including PowerApps and Excel, as well as Access, so it fits well into our workflow."
"There is continual improvement year-over-year."
"It's pretty easy to set up the product."
"It's a very easy-to-use solution."
"The initial setup is simple to do."
"Easy to use components to create the job."
"The initial setup is pretty straightforward."
"Pentaho Business Analytics' best features include the ease of developing data flows and the wide range of options to connect to databases, including those on the cloud."
"Pentaho is an analytics platform that can be used when an organization has a lot of big data storage systems already installed and needs to manage and analyze that data. It has a specific use case for unstructured data, such as documents, and needs to be able to search and analyze it."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
"We were able to install it without any assistance from tech support."
"The most valuable feature of Pentaho is the Tableau report."
"Its price could be better. Its licensing cost is very high."
"In an upcoming release, the solution could be simplified and have a more complete product package rather than a suite of products that we have to put together."
"I would like it to be a little bit more secure when I'm using the design feature on my desktop. For example, to have the ability to set up security passwords for opening the file. Currently, they don't have that. Tableau, for example, has a visual way of doing data processing steps, whereas the Power BI system still has some code, although it is very low code. It would be great to have the kind of view that Tableau has."
"Creating dashboards could be easier."
"The solution could improve by providing more free visuals. A lot of them are very nice but you have to purchase them."
"We did have some issues building the Microsoft blog."
"Our expectation is putting BI to work in real-time data collection systems in the maritime environment."
"We found out that you can't share a report with others unless you have an additional package. That caught us off guard. It came as a program that somebody could go in, build a report, and show it, but you can't share it without having additional licenses."
"Logging capability is needed."
"Version control would be a good addition."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"Pentaho Business Analytics' user interface is outdated."
"The repository should be improved."
"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."
"Another concern is that Pentaho is not customizable or interactive."
"Deployment is not simple. It is not simple because we are dealing with a lot of data; we are dealing with a lot of storage. So, it's not a simple process."
Microsoft Power BI is ranked 1st in Reporting with 297 reviews while Pentaho Business Analytics is ranked 16th in Reporting with 42 reviews. Microsoft Power BI is rated 8.0, while Pentaho Business Analytics is rated 8.0. The top reviewer of Microsoft Power BI writes "A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)". On the other hand, the top reviewer of Pentaho Business Analytics writes "Flexible, easy to understand, and simple to set up". Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and Oracle OBIEE, whereas Pentaho Business Analytics is most compared with Databricks, Microsoft SQL Server Reporting Services, SAP Crystal Reports, Tableau and KNIME. See our Microsoft Power BI vs. Pentaho Business Analytics report.
See our list of best Reporting vendors and best BI (Business Intelligence) Tools vendors.
We monitor all Reporting 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.