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 BI (Business Intelligence) Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."My favorite feature is the power query editor, where it can do the data transformations."
"The visuals are great and make everything look very professional. We can change the look and feel or manipulate the data according to our requirements. It's extremely flexible."
"I liked that Microsoft Power BI handles a large amount of data. I can handle hundreds of rows from Postgres in a few minutes. I also like how it detects the relationship between the tables without explicitly saying that. It just detects the relationship automatically. That made it easier to work with the data."
"The most valuable feature is that it's easy to use. It's very useful for non-engineers and it is the ultimate solution for providing information and insights. Power BI is the best visualization tool I have ever worked with."
"The ease of integration and connectivity stands out as the most critical aspect, followed closely by the flexibility to customize reports and dashboards."
"Technical support has been great."
"The solution is stable with reasonable performance."
"The best feature for me is Power Query. I know that probably sounds strange, but you can't do too much with visuals and reports if the backend stuff is horribly dirty and just bad. But for me, that is absolutely fantastic. I can load the data and do the transformation and be able to load it in a useful way. There are tons of connections, which is absolutely fantastic as well. It's been fairly easy, and it's intuitive."
"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."
"The most valuable feature of Pentaho is the Tableau report."
"Easy to use components to create the job."
"We were able to install it without any assistance from tech support."
"The initial setup is pretty straightforward."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
"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 would like to see a change in the premium capacity."
"A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it. The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation. There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this solution."
"Microsoft BI has its own challenges in terms of user interface and how quickly somebody can learn how to use it."
"The solution's documentation needs improvement."
"I would like to see integration with Excel."
"The reporting could be a bit better."
"The interface could be improved."
"I think that the solution is harder to use for people who are not experts in data."
"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."
"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."
"Logging capability is needed."
"Another concern is that Pentaho is not customizable or interactive."
"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."
"Version control would be a good addition."
Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 297 reviews while Pentaho Business Analytics is ranked 19th in BI (Business Intelligence) Tools 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, KNIME, SAP Crystal Reports, Microsoft SQL Server Reporting Services and Tableau. See our Microsoft Power BI vs. Pentaho Business Analytics report.
See our list of best BI (Business Intelligence) Tools vendors and best Reporting vendors.
We monitor all BI (Business Intelligence) 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.