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."SSRS and the Tabular server/Vertipaq engine/DAX are probably the two most valuable components."
"PowerBi is used to import our production data and generate dashboards, then integrates other Excel sheets to provide managers dashboards. This helps them get insights to make better OEE improvement decisions, mainly where to focus resources. We became able to see indicators from any time frame (day, week, month, or year), then could make better decisions."
"As it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools."
"I like Microsoft BI's drill-down feature and its overall ease of use."
"There is a feature in Microsoft BI that allows JSON data to SQL on the dashboards effectively and quickly."
"Connectivity, installation, and configuration are pretty fast and seamless compared to Cognos."
"The most valuable features are the easy creation of reports, dashboards, and the ability to perform analysis. It is important for us to create reports because we have some operations during certain hours and we can use this tool to track the information."
"When we are introducing Microsoft BI to our clients, if they're familiar with Excel, the transition phase will be much easier for them. They can easily switch from Microsoft Excel to Microsoft BI. The core foundation or the base technology is the same in both tools. There are a few limitations in Microsoft Excel, and this is where Microsoft BI comes in."
"Easy to use components to create the job."
"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 initial setup is pretty straightforward."
"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."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
"The most valuable feature of Pentaho is the Tableau report."
"There's always room for improvement for Microsoft Power BI, especially for the UX and the menus to make it more accessible to business users."
"It needs more graphics and overlays."
"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."
"My data is restricted to my DB and I'm not sure how this would handle an extremely large dataset."
"This solution needs integration with SAS and more deep analysis functionality."
"The maps in Power BI could be improved. You deal with many maps over the years, like maps of America and Saudi Arabia. The maps aren't detailed enough, and there aren't enough visualization tools. Whenever I want to use a map, I struggle with choosing the right visualization."
"Microsoft BI's visualization could be better. Though Power BI's visualization has steadily improved over the years, it's not on the level tools like Tableau and SAS or some of the more expensive products on the market."
"Technical support could be a bit better."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"The repository should be improved."
"Logging capability is needed."
"Version control would be a good addition."
"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."
"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."
"Pentaho Business Analytics' user interface is outdated."
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, SAP Crystal Reports, Microsoft SQL Server Reporting Services, KNIME 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.