Microsoft Power BI vs Pyramid Analytics vs Tableau comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
33,848 views|28,652 comparisons
92% willing to recommend
Pyramid Analytics Logo
1,308 views|915 comparisons
87% willing to recommend
Tableau Logo
26,131 views|22,454 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).
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
"It ingegrates nicely with Office 365.""The most valuable feature is definitely the visual aspect and the DAX capabilities to virtually do anything.""It is a powerful tool that helps our data analysis processes.""It seems stable. I haven't heard of any difficulties from my clients that utilize Power BI.""Provides data feeds for enterprise KPI reporting.""The most valuable features in Microsoft BI are the analysis using the feature drag and drop function. It's very easy to load and use different data sources.""Microsoft B's beneficial features are that it is a Microsoft product and it is well known by the staff here in the company. It suited the available skills.""The dashboards of Microsoft BI are easy to use."

More Microsoft Power BI Pros →

"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 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 most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support for DAX queries.""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 seems quite performant in analyzing multi-dimensional information sets and presenting them.""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.""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.""The on-premise version has quite good scalability."

More Pyramid Analytics Pros →

"The most valuable features are data discovery and fine visualizations.""The best part about Tableau is the visualization.""I work for clients. That is my business model. Business people really like to see Tableau. They love Tableau because it is very user-friendly. The platform provides an easy to use interface, which is what most people like about it.""It gives us a new dimension to the way that we analyse our data.""The action feature which Tableau has is very useful for us. If we click on one visualization, it will pass the value to another visualization. That interactivity within different visualizations is the most valuable feature of Tableau.""Since Tableau is on the cloud, we haven't faced any challenges around scalability.""You can create attractive dashboards that inform users using Tableau.""The most valuable feature is the ease of use."

More Tableau Pros →

Cons
"One of the more difficult things to do is to export some of the data from Power BI to Excel.""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.""I'm not overly technical, and so I can't really speak to any shortcomings from a technical standpoint.""Needs single sign-on.""It should have more report outputs. They should expand the report outputs. Its documentation should also be better.""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.""I feel the modeling page should be simplified.""It should have more integrations."

More Microsoft Power BI Cons →

"I find that this is quite a heavy, time-consuming tool for developers.""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.""Even though the solution has a functionality for every step, it's not so well- defined. That needs to be improved.""Pyramid Analytics could improve by speeding up data refresh, especially for large datasets.""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.""I think the graphic number of charts and components could be higher, at least comparable to Brain Power BI."

More Pyramid Analytics Cons →

"Some of our clients are looking for better UI when using Tableau as they often work with this solution directly.""The Hyper Extract functionality is not as strong as that provided by Microsoft SQL.""The forecasting feature in Tableau in my view is too limited because it must have dates but I should be able to predict the outcome of an event without having a date as part of the input.""With performance tuning, it generates a pretty complex query when it is not required.""Its price is a concern. It is more expensive than Power BI. The other thing that I never liked about Tableau is its ability to handle large sets of data. To present the data in the dashboards, we have to stage it up exactly like it is going to come into the dashboard. We use another tool called Alteryx that does that for us. So, we manipulate the data, get it staged, and then push it into Tableau. Tableau is terrible at handling large data sets, and we knew right away that we couldn't use Tableau to do data manipulation.""It's already using 32 gigabytes of memory, but the performance is not so good. It's very heavy.""Its documentation can be improved so that a user can get a good hands-on experience. Tableau is well documented, and on their website, there are a lot of tutorials that are available for free. I started my learning process through those tutorials, but there are certain loopholes in those tutorials, which only got filled through a couple of good YouTube channels that talk about Tableau. YouTube helped me a lot. So, the documentation could be better, I understand that it is evolving day by day, and with more usage, there would be more such documentation.""A strict security measure is needed. I believe it is weak in terms of security."

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.
    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 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
    33,848
    Comparisons
    28,652
    Reviews
    27
    Average Words per Review
    619
    Rating
    7.9
    Views
    1,308
    Comparisons
    915
    Reviews
    6
    Average Words per Review
    554
    Rating
    7.8
    Views
    26,131
    Comparisons
    22,454
    Reviews
    13
    Average Words per Review
    537
    Rating
    8.7
    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%
    Government12%
    Manufacturing Company10%
    Computer Software Company10%
    REVIEWERS
    Financial Services Firm13%
    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 Enterprise42%
    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 Enterprise40%
    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.
    769,630 professionals have used our research since 2012.