Microsoft Power BI vs Pyramid Analytics vs Tableau comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
34,187 views|29,049 comparisons
92% willing to recommend
Pyramid Analytics Logo
1,325 views|919 comparisons
87% willing to recommend
Tableau Logo
26,326 views|22,778 comparisons
89% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Microsoft Power BI, Pyramid Analytics, and Tableau 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).
768,578 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
"Tech support is very helpful.""The interface is very fluid.""We found the initial setup to be straightforward.""Data integration is very useful in Power BI. It lets me collect data from many sources. For example, I can get data from Oracle databases and SQL Server databases at the same time.""I like the flexibility it offers.""The solution is stable with reasonable performance.""It offers a lot of information and is very flexible and interactive.""Because this solution is very easy, and very visual, you can have results in minutes."

More Microsoft Power BI Pros →

"The most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support for DAX queries.""It offers a wide range of analytics options including statistics and visualizations, as well as prediction capabilities, allowing users to make forecasts based on the latest data.""Pyramid has a wide level of uses, as it's a complete ETL process and has a good level of connecting to a lot of data sources.""It proved to be a very powerful and useful tool due to its breakdown capabilities, easy reporting features, flexibility in building custom calculations, and the ability to integrate them into reports.""The features I find most valuable are 'Discover,' 'Formulate,' and 'Model.' I use them regularly to build logic and create reports for my job.""It seems quite performant in analyzing multi-dimensional information sets and presenting them.""The on-premise version has quite good scalability.""I think the most valuable Pyramid Analytics feature is the solution's ability to drill down and dice in the loop. I think it is better than InExcel or Power BI."

More Pyramid Analytics Pros →

"Tableau is easy to use and it has great predictive features.""Tableau is easy to use.""It's the ease of use. It is also a self-service tool so it decreases the burden on having centralized IT-type teams or developers.""You are able to see and follow trends.""It's easy to use.""While using this solution I have found the valuable features to be ease of use and the visualization. It is a complete solution.""There is a lot of APIs available, which means that Tableau can be customized to a large extent.""The best part about Tableau is the visualization."

More Tableau Pros →

Cons
"If you look at the new tool, even though they promised that you could do data modeling, that you could do everything from the Power BI side, if your data is really large in volume, sometimes it doesn't work on the Power BI. More feature testing from their side would certainly help users.""A lot of people work on Excel, so being able to export an Excel file as part of a subscription would be an improvement.""Adding paginated reports to this tool could be of great help for users who want to move away from SSRS.""I think because I'm moving more into RPA, I'd definitely like to see integration across the RPA, Power BI, or Tableau platforms, because that integration could then make automation and mundane reporting much faster.""There are some problems with the functionality of this solution. The dashboard is not very user friendly and is quite complicated.""It should be more scalable for an enterprise-level implementation. When you deploy large data sets, the response has to be faster in Power BI. This is one thing that needs to be improved in it.""Integration with products that are not Microsoft could be more improved.""There could be an integrated AI that can automatically analyze some of your data and highlight or provide suggestions. For example, when you are looking at a data set, it can suggest putting it into a certain type of chart so that you gain different insights or a trend line. You would almost have templates that it would recommend for you."

More Microsoft Power BI Cons →

"Even though the solution has a functionality for every step, it's not so well- defined. That needs to be improved.""It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields.""There is room for improvement in terms of the user interface, particularly when it comes to modifying connections between filters and visual components in a dashboard.""I find that this is quite a heavy, time-consuming tool for developers.""Pyramid Analytics could improve by speeding up data refresh, especially for large datasets.""I think the graphic number of charts and components could be higher, at least comparable to Brain Power BI.""The general amount of negative comments that I am hearing from my team makes me very wary.""There is room for improvement in terms of documentation and examples, especially for newcomers like me who are learning both business intelligence and Pyramid."

More Pyramid Analytics Cons →

"The development part should be better. We are putting a lot of effort in during development, so if we face any struggles, we have to find workaround solutions on the internet.""There are not enough language options. It needs to be offered in more than just English.""When there are millions of records, scaling up is quite difficult.""When compared to Power BI, it is less user-friendly.""The extraction, transformation and loading of data in Tableau takes a lot of time and we do not have confidence that Tableau is showing all the data we need.""There should be stronger data modules for the platform.""The pricing is a bit expensive.""Small multiples (a.k.a. Trellis charts) are possible only through very hacky means. Update: Still remains a challenge."

More Tableau 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 →

  • "The licensing cost is not excessively expensive, but it does increase with the addition of new features and modules."
  • More Pyramid Analytics Pricing and Cost Advice →

  • "For big business, Tableau could be expensive as having a lot of Tableau server users (entering with a browser to reports) could be a bit expensive."
  • "Best advice on pricing is to anticipate the desire for more licenses once the results of this product are acknowledged in other parts of your company."
  • "Paying for users you never setup or buying expensive desktop licenses for users who can solve their users with web editing on the server are the two biggest expenses."
  • "Buy 50 at a time. Project your use base every three months, and project your requirements forward."
  • "Tableau can be costly (but this can be indefinable, such as user experience vs. cheaper etc.)"
  • "I wish there was more of a subscription model with the pricing when it comes to Tableau, so you can get all the latest version upgrades/features if you pay monthly/annually."
  • "The cost is high."
  • "Deployment of dashboards to viewers and unit supervisors can be prohibitively expensive."
  • More Tableau Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
    768,578 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 most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support… more »
    Top Answer:I find the price of Pyramid Analytics to be quite reasonable, especially when compared to other tools in the industry… more »
    Top Answer:Pyramid Analytics could improve by speeding up data refresh, especially for large datasets. While it is currently an… more »
    Top Answer:It depends on the Data architecture and the complexity of your requirement Some great tools in the market are Qlik… more »
    Top Answer:Both tools have their positives and negatives. First, I should mention that I am relatively new to Tableau. I have been… more »
    Top Answer:Tableau is easy to set up and maintain. In about a day it is possible for the entire platform to be deployed for use… more »
    Ranking
    Views
    34,187
    Comparisons
    29,049
    Reviews
    23
    Average Words per Review
    553
    Rating
    7.9
    Views
    1,325
    Comparisons
    919
    Reviews
    6
    Average Words per Review
    554
    Rating
    7.8
    Views
    26,326
    Comparisons
    22,778
    Reviews
    14
    Average Words per Review
    534
    Rating
    8.5
    Comparisons
    Also Known As
    SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
    Tableau Desktop, Tableau Server, Tableau Online
    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.

    The BI Office from Pyramid Analytics is a web-based governed data discovery and analytics platform. It integrates the four principal functions of any comprehensive BI strategy into a single, seamless application. Users can now analyze, present, report and predict on their data in a single application. Pyramid Analytics has native apps to cover the entire mobile spectrum, iOS, Android and Windows. With BI Office users can integrate SAP data with data from other sources giving them the right tools and better data to make data-driven decisions.

    Tableau is a tool for data visualization and business intelligence that allows businesses to report insights through easy-to-use, customizable visualizations and dashboards. Tableau makes it exceedingly simple for its customers to organize, manage, visualize, and comprehend data. It enables users to dig deep into the data so that they can see patterns and gain meaningful insights. 

    Make data-driven decisions with confidence thanks to Tableau’s assistance in providing faster answers to queries, solving harder problems more easily, and offering new insights more frequently. Tableau integrates directly to hundreds of data sources, both in the cloud and on premises, making it simpler to begin research. People of various skill levels can quickly find actionable information using Tableau’s natural language queries, interactive dashboards, and drag-and-drop capabilities. By quickly creating strong calculations, adding trend lines to examine statistical summaries, or clustering data to identify relationships, users can ask more in-depth inquiries.

    Tableau has many valuable key features:

    • Tableau dashboards provide a complete view of your data through visualizations, visual objects, text, and more.
    • Tableau provides convenient, real-time options to collaborate with other users and instantly share data in the form of visualizations, sheets, and dashboards. 
    • Tableau ensures connectivity to both live data sources and data extraction from external data sources as in-memory data. This gives users the flexibility to use data from more than one source without any restrictions. 
    • Tableau gives many data source option, ranging from spreadsheets, big data, on-premise files, relational databases, non-relational databases, data warehouses, and big data, to on-cloud data. 
    • Tableau has a lot of pre-installed information on maps, such as cities, postal codes, and administrative boundaries. 
    • Tableau has a foolproof security system based on authentication and permission systems for data connections and user access. Tableau also gives you the freedom to integrate with other security protocols.

    Tableau stands out among its competitors for a number of reasons. Some of these include its fast data access, easy creation of visualizations, and its stability. PeerSpot users take note of the advantages of these features in their reviews:

    Romil S., Deputy General Manager of IT at Nayara Energy, notes, "Its visualizations are good, and its features make the development process a little less time-consuming. It has an in-memory extract feature that allows us to extract data and keep it on the server, and then our users can use it quickly.

    Ariful M., Consulting Practice Partner of Data, Analytics & AI at FH, writes, “Tableau is very flexible and easy to learn. It has drag-and-drop function analytics, and its design is very good.

    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
    US Department of Veterans Affair, Volkswagen, Siemens, Blackboard, Hallmark, Orange, CDW, LA Fitness, Atelier GS, Memorial Healthcare, Acadia Insurance, BancoBic, Advanced Learning, Microsoft, Drake University
    Accenture, Adobe, Amazon.com, Bank of America, Charles Schwab Corp, Citigroup, Coca-Cola Company, Cornell University, Dell, Deloitte, Duke University, eBay, Exxon Mobil, Fannie Mae, Ferrari, French Red Cross, Goldman Sachs, Google, Government of Canada, HP, Intel, Johns Hopkins Hospital, Macy's, Merck, The New York Times, PayPal, Pfizer, US Army, US Air Force, Skype, and Walmart.
    Top Industries
    REVIEWERS
    Financial Services Firm15%
    Manufacturing Company13%
    Computer Software Company11%
    Government9%
    VISITORS READING REVIEWS
    Educational Organization35%
    Financial Services Firm8%
    Computer Software Company8%
    Government5%
    VISITORS READING REVIEWS
    Financial Services Firm12%
    Government11%
    Computer Software Company10%
    Manufacturing Company10%
    REVIEWERS
    Financial Services Firm12%
    Computer Software Company12%
    Healthcare Company7%
    University7%
    VISITORS READING REVIEWS
    Educational Organization35%
    Financial Services Firm11%
    Computer Software Company8%
    Manufacturing Company6%
    Company Size
    REVIEWERS
    Small Business39%
    Midsize Enterprise16%
    Large Enterprise45%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise41%
    Large Enterprise45%
    REVIEWERS
    Small Business75%
    Midsize Enterprise13%
    Large Enterprise13%
    VISITORS READING REVIEWS
    Small Business21%
    Midsize Enterprise12%
    Large Enterprise67%
    REVIEWERS
    Small Business32%
    Midsize Enterprise18%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise39%
    Large Enterprise47%
    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.
    768,578 professionals have used our research since 2012.