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."PowerBI – Self-service BI."
"It has provided customer purchase patterns and great visualization."
"The Microsoft Power BI app is very good. It's also very flexible."
"It gives you an edge if you are on the Microsoft platform. If you have been using Microsoft products for a long time or if you have the Microsoft infrastructure, this is the right tool for you. It has seamless integration with Microsoft SQL Server and other sources, and you get the best of the three things (SSIS, SSAS, and SSRS) in one suite."
"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."
"Reports, dashboards, and visualizations are most valuable."
"Microsoft BI is better than most solutions we have. It's pretty easy to conduct analysis with it."
"Technical support is quite responsive."
"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."
"The most valuable feature of Pentaho is the Tableau report."
"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."
"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."
"Easy to use components to create the job."
"The smart phone application could be improved, along with better graphics and faster updating."
"If you are having millions of rows of data or you have a large database, Microsoft BI's performance depends upon how powerful your hardware is. When I am handling large amounts of data I do not use Microsoft BI or Tableau because of this, I use D3."
"Microsoft BI lacks integration capabilities, so it needs to consider increasing its integration capabilities."
"I'm looking for something that can make it much easier to incorporate Power BI visuals or dashboards into, let's say, Power Apps – custom Power Apps or anything like that. The most important thing would be to seamlessly embed reports in applications. For example, to have buttons that can be navigated through multiple solutions – from Power Apps to Power BI to SharePoint – via links or something like that."
"The UI looks awkward once the graphs have been generated in the console. This is what Microsoft can work on."
"When you go to the cloud, its licensing is not intuitive. It is a little bit complex. When you have to purchase a new license, it is difficult to understand on their website what exactly you need to pay and how you can group. It is something that is applicable to all Microsoft products. They're not always so simple and clear when it comes to licensing. Their support can also be better in terms of explaining how they resolved an issue and what steps they took to resolve it. They are able to resolve the issue, but they can be better at explaining the approach they took to resolve the issue. It could have something in the direction of machine learning. It can have some kind of integration with machine learning where you can ask for some reports with natural language."
"The accounting data needs improvement."
"You do need to do some hard coding for certain things in Microsoft BI."
"Pentaho Business Analytics' user interface is outdated."
"Another concern is that Pentaho is not customizable or interactive."
"The repository should be improved."
"Logging capability is needed."
"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."
"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."
"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.