Microsoft Power BI vs Pentaho Business Analytics vs Zoho Analytics comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
33,848 views|28,652 comparisons
92% willing to recommend
Hitachi Vantara Logo
1,134 views|830 comparisons
89% willing to recommend
Zoho Logo
1,165 views|497 comparisons
92% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Microsoft Power BI, Pentaho Business Analytics, and Zoho Analytics based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Tableau, Oracle and others in BI (Business Intelligence) Tools.
To learn more, read our detailed BI (Business Intelligence) Tools Report (Updated: April 2024).
769,630 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"My primary use is for view of the dashboard.""It's a pretty scalable product.""Its visualization capabilities are pretty good. It is very easy to use. You can easily make your dashboard.""The solution is very easy to use.""It's user-friendly and provides data abstracting capabilities. We are also able to share reports with our colleagues very easily.""The reports are easy to create.""In the early stage of an implementation, it not only helps decision making, but it allows people to have insight into problems with data so that they can go and get it corrected.""Its connection to every database: Whatever and wherever it is."

More Microsoft Power BI Pros →

"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 pretty straightforward.""I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."

More Pentaho Business Analytics Pros →

"It's a very strong analytics tool.""The most valuable feature of Zoho Analytics is its connectivity with ERP systems and the functionality to set up different fields for leads.""We can create advanced-level reports with the tool. We can get data from different Zoho applications and also from other third-party applications. We can create schedules for syncing data from third parties to Zoho Analytics. We can also use table queries for getting data from more than one table.""The front end of this solution including the graph generation using SQL has been most useful.""I like the way I can share dashboards and embed dashboards. I normally use embedding. So, I create a dashboard, and I embed it into specific websites. Sharing of the dashboard is seamless, and it is easier than any other visualization platform, even Tableau.""It provides insights into leads, information about the team and about various sales activities. The graphical representations in the form of charts is excellent.""We really like that it's user friendly and has a lot of combinations and charts. They're good compared to other tools. We used a free Elastic product, comparatively, this solution is good because of their support, UI, and connecting to databases is very easy.""Zoho Analytics is the best software for giving reports to customers and we can create any report that is required."

More Zoho Analytics Pros →

Cons
"The solution could be more customizable and you do not have too much freedom on the code.""I think that the solution is harder to use for people who are not experts in data.""The product’s on-premise reporting servers could support real-time data refreshing capabilities like its on-cloud version.""The solution could improve the mobile application design. It is difficult to use compared to the desktop version.""People without private emails cannot publish and, frankly, this doesn't allow for easy training.""It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes. It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable. I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community.""It should be more user-friendly and simple.""I would like to see a change in the premium capacity."

More Microsoft Power BI Cons →

"Another concern is that Pentaho is not customizable or interactive.""Version control would be a good addition.""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.""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.""We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost.""The repository should be improved."

More Pentaho Business Analytics Cons →

"The customer service and support for this solution could be improved by faster response times.""The platform's pricing needs improvement.""It would be great to have more user input fields which can be used on dashboards.""I like the solution's Query Table feature which helps me write SQL queries. We can get data from different tables and then use it to create reports.""They should provide white labeling with a cheaper option. I know they have a white labeling feature in which I can white label Zoho Analytics with my company theme, logo, and URL, but it seems a little expensive. If they can make it cheaper, it would be great. The same is applicable to Tableau.""The solution's tasks and project management tools are weaker than those of its competitors.""The solution does not provide call center facilities for customer support.""The navigation on the interface is not intuitive."

More Zoho Analytics Cons →

Pricing and Cost Advice
  • "There is room for at least 45% discount as compared to the initial price."
  • "MS BI comes with all the tools and it is, to the best of my knowledge, the most affordable solution."
  • "All in all, for the price, this is an excellent tool for helping your organization turn mounds of data into useful insights."
  • "I would advise that Microsoft BI products are rightly priced and the licensing is easy to follow and to fulfill."
  • "Remove the cost of a licence to show a dashboard within SharePoint. Why should readers of a dashboard have to pay to view? ​"
  • "Make it low in cost. It is a no-brainer!"
  • "Globally, we evaluated a number of products, including Salesforce's product, Microsoft won on the ground of simple functionally and cost."
  • "Paid for itself in the first month."
  • More Microsoft Power BI Pricing and Cost Advice →

  • "Free and commercial versions are available."
  • "Pentaho is expensive ."
  • "We were lucky enough to find a Pentaho OEM partner who offered a data warehouse model and the ETL software for about 60K SGD per year."
  • More Pentaho Business Analytics Pricing and Cost Advice →

  • "I would recommend looking at your usage and whether the Zoho One license model would work for your organisation. It is very cost effective if you use other Zoho tools."
  • "An exact ROI is hard to calculate. However, we have definitely made sales that would have been much harder, or unlikely, as a result of the speed with which we were able to prepare comprehensive analysis."
  • "I don't feel that price is an issue for this product."
  • "It is very reasonable, and it gives me a good return on investment. Compared to other tools, it is the best choice in terms of pricing."
  • "This solution is reasonable as far as pricing is concerned."
  • "The price is high. The solution advertises that it provides products for 55 AED per user, but these products contain only the basic features. Most of the features are locked. The version of the product that includes Zoho Analytics costs around 199 AED per user per month."
  • "For one license the pricing is about $35 a user."
  • "Zoho Analytics costs $ 4,200 per month, billed yearly."
  • More Zoho Analytics Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
    769,630 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Questions from the Community
    Top Answer:There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would… more »
    Top Answer:Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize… more »
    Top Answer:Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are… more »
    Top Answer:The organization has both options based on their needs and budget constraints. The Enterprise Edition is expensive with… more »
    Top Answer:The product to me is not as user-friendly as other players in the market. It also still needs improvement in the… more »
    Top Answer:Pentaho is a BIS(business intelligence system) that is designed to help customers make decisions based on their data… more »
    Top Answer:The most valuable feature of Zoho Analytics is its connectivity with ERP systems and the functionality to set up… more »
    Top Answer:The product is expensive. However, it is more affordable than Qlik Sense.
    Top Answer:The solution's Deals section could be improved because it's sometimes complicated, and I don't like how the comments are… more »
    Ranking
    Views
    33,848
    Comparisons
    28,652
    Reviews
    27
    Average Words per Review
    619
    Rating
    7.9
    Views
    1,134
    Comparisons
    830
    Reviews
    4
    Average Words per Review
    526
    Rating
    7.3
    Views
    1,165
    Comparisons
    497
    Reviews
    12
    Average Words per Review
    332
    Rating
    7.6
    Comparisons
    Also Known As
    SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
    Pentaho, Kettle, Hitachi Pentaho Business Analytics
    Zoho Reports
    Learn More
    Overview

    Microsoft Power BI is a powerful tool for data analysis and visualization. This tool stands out for its ability to merge and analyze data from various sources. Widely adopted across different industries and departments, Power BI is instrumental in creating visually appealing dashboards and generating insightful business intelligence reports. Its intuitive interface, robust visualization capabilities, and seamless integration with other Microsoft applications empower users to easily create interactive reports and gain valuable insights.

    Pentaho is an open source business intelligence company that provides a wide range of tools to help their customers better manage their businesses. These tools include data integration software, mining tools, dashboard applications, online analytical processing options, and more.

    Pentaho has two product categories: There is the standard enterprise version. This is the product that comes directly from Pentaho itself with all of the benefits, features, and programs that come along with a paid application such us analysis services, dashboard design, and interactive reporting.

    The alternative is an open source version, which the public is permitted to add to and tweak the product. This solution has its advantages, aside from the fact that it is free, in that there are many more people working on the project to improve its quality and breadth of functionality.

    Zoho Reports is a powerful, easy-to-use and highly scalable cloud-based reporting and business intelligence platform for small to medium-sized businesses. Its flexible pay-as-you-go pricing model and scope for customization allow businesses to tailor it to their unique needs.

    Sample Customers
    Accenture Adidas Aetna AIG Airbus Alibaba Allstate Amazon American Express Aon AT&T Audi Bank of America BASF Bayer Berkshire Hathaway Boeing Coca-Cola Comcast Cisco Coca-Cola Dell Disney Emirates Equinix FedEx Ford GE Google H&M Home Depot Honda IBM Intel JPMorgan Chase Kellogg's Kroger L'Oréal McDonald's Merck MetLife Microsoft Nike Oracle P&G PepsiCo Procter & Gamble Prudential Financial SAP Siemens Snapchat Spotify Starbucks Target Toyota T-Mobile Unilever Visa Walmart WeWork World Bank Xerox
    Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
    Suzuki, American Pacific Mortgage, KPMG, Air Canada, University of Michigan, BricozOr, WorldWide Express, The University of Melbourne, Novartis, SAIC
    Top Industries
    REVIEWERS
    Financial Services Firm15%
    Manufacturing Company13%
    Computer Software Company11%
    Energy/Utilities Company9%
    VISITORS READING REVIEWS
    Educational Organization35%
    Financial Services Firm8%
    Computer Software Company8%
    Government5%
    REVIEWERS
    Computer Software Company19%
    University13%
    Financial Services Firm13%
    Educational Organization6%
    VISITORS READING REVIEWS
    Financial Services Firm22%
    Government12%
    Computer Software Company12%
    Educational Organization8%
    REVIEWERS
    Educational Organization9%
    Computer Software Company9%
    Insurance Company9%
    Outsourcing Company9%
    VISITORS READING REVIEWS
    Educational Organization77%
    Computer Software Company5%
    Financial Services Firm2%
    Non Profit2%
    Company Size
    REVIEWERS
    Small Business39%
    Midsize Enterprise16%
    Large Enterprise45%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise42%
    Large Enterprise45%
    REVIEWERS
    Small Business50%
    Midsize Enterprise17%
    Large Enterprise33%
    VISITORS READING REVIEWS
    Small Business27%
    Midsize Enterprise13%
    Large Enterprise61%
    REVIEWERS
    Small Business73%
    Midsize Enterprise12%
    Large Enterprise15%
    VISITORS READING REVIEWS
    Small Business9%
    Midsize Enterprise78%
    Large Enterprise13%
    Buyer's Guide
    BI (Business Intelligence) Tools
    April 2024
    Find out what your peers are saying about Microsoft, Tableau, Oracle and others in BI (Business Intelligence) Tools. Updated: April 2024.
    769,630 professionals have used our research since 2012.