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."It is a pretty straightforward and flexible solution for data integration and modeling. It is a low-code solution. When you are doing data integration, you can use the GUI, which is very simple and straightforward. You can also do very intricate custom queries and model it at different levels. It is very easy to use and scalable."
"Its visualization capabilities are pretty good. It is very easy to use. You can easily make your dashboard."
"Technical support has been great."
"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."
"Microsoft BI is scalable."
"Most of the clients I am interacting with are looking towards Power BI because of the cost and simplicities. It provides an entire feature set and a complete solution. It has tight integration with Office 365, Dynamics 365, Microsoft Technology Stack, and datatypes like R and Python."
"It gives us, the ability to do a lot of analysis quickly, similar to ad hoc analysis."
"We found the initial setup to be straightforward."
"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."
"We were able to install it without any assistance from tech support."
"The most valuable feature of Pentaho is the Tableau report."
"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."
"Easy to use components to create the job."
"The solution could improve by providing more free visuals. A lot of them are very nice but you have to purchase them."
"The on-premises version lacks some technical features that are available with the Cloud version."
"I think that they can add more types of charts because the selection on the desktop version is limited."
"I would like Microsoft to include some inbuilt machine learning so that it becomes point-and-click, rather than us developing models out of API and BI connecting to that and getting the results. That process gets in the way of continuity."
"One of the more difficult things to do is to export some of the data from Power BI to Excel."
"The integration in Microsoft BI could improve for other solutions, such as Oracle DB and PostgresSQL. Additionally, the reporting from the databases to Microsoft BI should be in real-time and the overall performance could be better."
"If you have to pull multiple data sources performance is somewhat lacking."
"From any improvement perspective, I want the product to be made available to users free of cost...The stability and scalability of the product can be better."
"Another concern is that Pentaho is not customizable or interactive."
"Pentaho Business Analytics' user interface is outdated."
"Logging capability is needed."
"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."
"The repository should be improved."
"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."
"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 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.