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 sharing features are vital, especially the ability to share and test different shared dashboards."
"We like the drag and drop interactability visualization. We really like that. It's user-friendly."
"The capability to add custom visuals and create Power BI apps. You can package datasets, synchronization details, and dashboards into a single app."
"Its connectivity with other Office applications, mostly with Excel, and the ability to deploy it very easily are the most valuable features. It comes sort of bundled with the cloud, so you don't need to set up a server and a standalone infrastructure. So, getting into the system or building something that you can deploy is very easy and very cheap. With other systems, you need to have a server, and you need to have a license for the server. The initial setup is very costly."
"The most valuable features are the flexibility, how many ways you can interrogate the data, and the the graphical visualization."
"The standard BI visualization capabilities are great."
"It's a straightforward setup."
"Microsoft BI allows us to connect to any database or any dataset."
"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 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."
"Easy to use components to create the job."
"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."
"The most valuable feature of Pentaho is the Tableau report."
"The initial setup is a little bit technical."
"Microsoft BI lacks some of the scheme features. It would be beneficial if there were a way to show how we move values in a different way."
"We would like to have better SQL support for queries."
"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."
"The DAX features need some improvement. It's not as easy as Excel. They need more DAX formulas."
"I would like them to provide a license that just allows us to see dashboards. What I don't like about this solution is that in order to just watch a dashboard, you need a license. Currently, you need to purchase a full license of Power BI Pro just to see something, which is not attractive. If you have a license, you can see a shared dashboard, but you can also build a dashboard or you can collaborate with other people. However, if you only want to see a dashboard, there is no license for that. I only want to see the dashboard, and I don't want to do anything more than watching the information on the dashboard. There is no license that allows you to see a shared dashboard. This is one of the areas of opportunity because I would like a lot of people to be able to see a shared dashboard, not to interact with it or to collaborate online with it. I would like to see more compatibility with non-Microsoft data sources. Given the fact that everything is related to Microsoft Azure and all services available on Microsoft Azure, I see that they're building more connections to Microsoft Azure services instead of other non-Microsoft services. I understand the strategy, but it would be good to have more compatibility with non-Microsoft data sources."
"The solution doesn't integrate well with third-party tools."
"In my opinion, the software is a little bit limited in terms of the flexibility it offers, with regard to the design of the visualization."
"Pentaho Business Analytics' user interface is outdated."
"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."
"Version control would be a good addition."
"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."
"Logging capability is needed."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
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.