Microsoft Power BI vs Tableau comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
20,317 views|17,415 comparisons
Tableau Logo
17,947 views|15,259 comparisons
Comparison Buyer's Guide
Executive Summary
Updated on Jul 30, 2023

We compared Microsoft BI and Tableau based on our users reviews in six parameters. After reading the collected data, you can find our conclusion below:

  • Ease of Deployment

    Users generally find the initial setup for Microsoft BI to be simple and effortless, requiring minimal time and effort. In comparison, Tableau's setup process can range from uncomplicated to more intricate, depending on specific circumstances and requirements.

  • Features

    Microsoft BI is highly regarded for its impressive capabilities and adaptability, as well as its capacity to retrieve data from diverse origins and create personalized visuals. On the other hand, Tableau is commended for its ease of use, intuitive design, and proficiency in managing substantial volumes of data.

  • Room for Improvement

    Both Microsoft BI and Tableau have areas where they can improve. Microsoft BI could enhance its user-friendliness, support, graphical and analytical features, cost, performance, integration, metadata management, visualization capabilities, stability, security, compatibility, data management process, support for product management and customer services, and documentation. On the other hand, Tableau could focus on improving its compatibility, performance, memory data concept, architecture, charting and calculations, modeling techniques, visualization options, integration, customization process, report creation, forecast instrument, GIS features, support for business insights and trend analysis, interface, licensing options, automation, write-back capabilities, drill-down functionality, security measures, workflow, and data modules.

  • Pricing

    Microsoft BI has a potentially high setup cost, particularly for enterprise-level usage. While some users find the pricing reasonable for desktop use, it becomes costly for larger-scale implementations. In contrast, Tableau's pricing is diverse, with opinions ranging from expensive to cheap. Some users perceive Tableau as expensive, especially for smaller firms, while other tools like Power BI are seen as more affordable. Generally, there is a consensus that Tableau's pricing could be enhanced to maintain competitiveness.

  • ROI

    Microsoft BI has been highly praised for its return on investment, with users giving it a perfect rating. It is projected to generate substantial revenue growth and achieve breakeven in a relatively short period of 2-3 years. In contrast, Tableau's specific ROI is uncertain, but it is presumed to be impressive based on existing data. Customers have observed a return on investment within a quicker timeframe of 5-6 months.

  • Service and Support

    The opinions on customer service for Microsoft BI are divided, with some users finding it satisfactory while others believe it needs improvement. On the other hand, Tableau's customer service has had a range of experiences, with some customers having positive ratings and others encountering limitations and difficulties in contacting the right people.

Comparison Results

Microsoft BI is praised for its ease of setup and powerful features, but users find it difficult to learn and use, with weaker graphical and analytical features compared to Tableau. The cost is considered high, and users desire better support, a more user-friendly interface, and improved performance. On the other hand, Tableau's setup can range from simple to complex, but it is highly valued for its user-friendliness and customization options. However, Tableau lacks compatibility with certain tools, has performance issues with large data, and needs improvement in visualization options and integration capabilities. Pricing is also a mixed opinion, with some finding it expensive. Customer support for both products has mixed reviews.

To learn more, read our detailed Microsoft Power BI vs. Tableau Report (Updated: March 2024).
763,955 professionals have used our research since 2012.
Q&A Highlights
Question: Business users moving from Tableau to MS Report builder
Answer: Rich- What is it that current leadership perceives as lacking in the current reporting tool set? Why change if the only benefit is features or a products capabilities? Can the products features and capabilities be exploited? By who and when? How does that make money for the company? Increased profit? Cost reduction? Increased resource utilization? Fewer days for order to cash? Reduced collections? Better on time shipping? Faster production? Increased gross margin? Reduced inventory? You get the picture. It's the people that make the difference. Not the tool! What is it that we need to know to grow our business constantly and continuously? Every tool mentioned can do really great "stuff". But what "stuff" does your company need? I wish you the best.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The solution is not that difficult to install, although this will vary with the experience of the person responsible for its installation.""Easy to use and the visualization is valuable.""We like the drag and drop interactability visualization. We really like that. It's user-friendly.""It is in the cloud, which makes it easy for mobile access of reports and data.""The use of graphics to show and view the data indicators is the most valuable feature. It is also very stable.""The flexibility of the program is valuable. We are able to add other information to the reporting information and expand upon it.""The most valuable feature would be the abundance of connectors. It is also easy to use.""The best feature of this solution is the way you can plan, communicate, and visualize all the knowledge you extract from the data for the customers. I like the way you can show or visualize the information a client needs to answer a business question."

More Microsoft Power BI Pros →

"Since Tableau is on the cloud, we haven't faced any challenges around scalability.""You are able to see and follow trends.""Partner support is very good.""While using this solution I have found the valuable features to be ease of use and the visualization. It is a complete solution.""The most important feature in Tableau is visual analytics.""Tableau has data relationships that can be applied to a data source which helps build out a directory which is helpful. Data blending has also been valuable to us.""It's very easy to visualize data with this product. The visualization maps of and frames that we have been able to cross-reference has been excellent.""I have found Tableau easy to use and the features are superb."

More Tableau Pros →

Cons
"The handling of the workspaces can be made more granular for user access rights. It can be managed a little bit better in terms of the connection to Active Directory so that we have more granular access rights. I am not sure if this is really possible or if we can solve it differently, but we need a lot of workspaces, and we are not sure how we can deal with it from the access rights perspective.""Not having to login again after a mobile app upgrade. A simple login on mobile would be great.""I think that there should be visuals for financial reporting videos. It should just be a plug and play because there is a lot of coding that goes into it with different clients.""The default parameters of the prompt could be improved by including a dynamic option.""When we have a big report with lots of data, the solution slows down quite a lot.""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.""The orchestration module for refreshing data flows is something that is missing and we have to do it manually.""They asked you to pay if you want to synchronize more than eight times, you would have to go to a Power BI enterprise license, which is much more costly."

More Microsoft Power BI Cons →

"Tableau's data modeling, mining, and AI library features need improvement.""The user story model is the most deceptive part of Tableau. It is a big marketing option, however, the reality is that it is not enough.""The data entered into Tableau must be clean. Otherwise, it won't work properly.""The use of this service in the desktop version is annoying due to the constant updates which lead to reinstalling the application. If they could give support with updates on the same downloaded version, it would be great.""There should be more widgets that would help less trained individuals create charts with less difficulty.""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.""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.""The product needs to allow for better ways to drill down more effectively on the information at hand."

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 →

  • "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 Reporting solutions are best for your needs.
    763,955 professionals have used our research since 2012.
    Comparison Review
    Guillermo (Bill) Cabiro
    I do use both Tableau and QlikView. Although very different, I really like both solutions. They belong to the new BI generation known as Interactive Visual Analytics In my opinion, QlikView has a more intuitive interface for regular users or executives that are not technical experts but the development side is a little more complex. Up to version 12 QlikView did not provide drag & drop features. If a user wanted to see something not included in the application the new object had to be created by a power user or developer because Qlikview's scripting has somewhat of a learning curve. On the positive side, QlikView's scripting is a great asset as it functions as an ETL allowing the integration of hundreds of different data sources into the same visual app. Another feature that’s extremely useful is Qlik’s proprietary Associative Model that allows the users to visualize data relationships that exist as well as those that do not. Tableau on the other hand is a lot easier to use for developers, analysts or power users who need to connect, manipulate and visualize data rather quickly. While this makes Tableau a better fit for the more analytical crowd, it may not be as appealing or intuitive to the regular or casual business users as QlikView is. Tableau has full pivot, drag & drop and drill down capabilities that are great for developers or power users. They can rotate measures and dimensions and graph them instantly using visualization best practices as suggested by the… Read more →
    Answers from the Community
    Anonymous User
    it_user89082 - PeerSpot reviewerit_user89082 (Manager of Data Analytics with 1,001-5,000 employees)
    Vendor

    Sorry to hear you have to move to Report Builder. Tableau is superior by a long shot! Find another gig. Don't go backwards. Move forward with Tableau !

    it_user5394 - PeerSpot reviewerit_user5394 (Consultant with 51-200 employees)
    Vendor

    Tableau is more suitable for somebody that is not developer and it's very easy to use and to create great visual presentation. For developers Report Builder would be more domestic.

    it_user82776 - PeerSpot reviewerit_user82776 (Chief Executive Officer at a tech services company with 1,001-5,000 employees)
    Consultant

    It is really the outcome and target goals that are achieved with the right set of BI solutions,people using it to add more efficiency and productivity at all fronts is the kind of result you want to see. Tools include human and technology bonded together to produce results, After all it is the function of both parties to work together, collaborate and share resources together. In the human perspective we look at the training and how best we can create solutions . With the BI solution it is the way we distinguish between the existing solutions that will to the best of its capability serve our business interests and requirements.

    it_user79746 - PeerSpot reviewerit_user79746 (Consultant at a energy/utilities company)
    Vendor

    Current business leadership include the VP of Finance, so determining a business case was and is a problem for him and those directly under him.  So is a no my problem.
     
    Thanks,
    Rich

    it_user77358 - PeerSpot reviewerit_user77358 (Director of IT at a manufacturing company with 51-200 employees)
    Vendor

    Rich- What is it that current leadership perceives as lacking in the current reporting tool set?
    Why change if the only benefit is features or a products capabilities?
    Can the products features and capabilities be exploited?
    By who and when?
    How does that make money for the company?
    Increased profit?
    Cost reduction?
    Increased resource utilization?
    Fewer days for order to cash?
    Reduced collections?
    Better on time shipping?
    Faster production?
    Increased gross margin?
    Reduced inventory?

    You get the picture. It's the people that make the difference. Not the tool!
    What is it that we need to know to grow our business constantly and continuously?

    Every tool mentioned can do really great "stuff".
    But what "stuff" does your company need?

    To answer the initial question: Every change is difficult without buy-in from the stakeholders.
    People love change. What they don't like is change without benefit. Perceived or real.
    I hope this helps you a little to better meet the challenges you're facing.

    I wish you the best.

    it_user83559 - PeerSpot reviewerit_user83559 (Database Expert at a energy/utilities company with 10,001+ employees)
    Real User

    Reading through the responses from all you knowledgeable persons out there is so very enlightening. It's like sitting in a room and getting your experiences on these tools first hand. Thanks a lot for your inputs, which will help in putting pros and cons for the company to make a trade off and choose over the two.

    it_user77358 - PeerSpot reviewerit_user77358 (Director of IT at a manufacturing company with 51-200 employees)
    Vendor

    Rich- What is it that current leadership perceives as lacking in the current reporting tool set?
    Why change if the only benefit is features or a products capabilities?
    Can the products features and capabilities be exploited?
    By who and when?
    How does that make money for the company?
    Increased profit?
    Cost reduction?
    Increased resource utilization?
    Fewer days for order to cash?
    Reduced collections?
    Better on time shipping?
    Faster production?
    Increased gross margin?
    Reduced inventory?

    You get the picture. It's the people that make the difference. Not the tool!
    What is it that we need to know to grow our business constantly and continuously?

    Every tool mentioned can do really great "stuff".
    But what "stuff" does your company need?

    To answer the initial question: Every change is difficult without buy-in from the stakeholders.
    People love change. What they don't like is change without benefit. Perceived or real.
    I hope this helps you a little to better meet the challenges you're facing.

    I wish you the best.

    it_user79746 - PeerSpot reviewerit_user79746 (Consultant at a energy/utilities company)
    Vendor

    I wouldn't feel too sorry, it is a very good group to work with.  After a lot of years working in IT both in the US and Europe one of the things I find interesting is that Americans in business, especially with regard to software,  feel they must have the latest, greatest and most feature rich everything when very often being a little behind the bleeding edge gets the job done and costs less.  The real issue is to look at the problem being solved and find good enough while keeping an eye on where you are going. 

    Having said that took a brief look at the link you indicated and I like the fact that it runs on Linux.  Thumbs up on that aspect.

     
    Thanks,
    Rich

    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 recommend as follows:  1) If you have legacies of SAP, Oracle  - look for SAP… more »
    Top Answer:Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize information, control users accessing information, the configuration of governance… more »
    Top Answer:Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle… more »
    Top Answer:It depends on the Data architecture and the complexity of your requirement Some great tools in the market are Qlik Sense, Power BI, OBIEE, Tableau, etc. I have recently started using Cognos… more »
    Top Answer:Both tools have their positives and negatives. First, I should mention that I am relatively new to Tableau. I have been working on and off Tableau for about a year, but getting to work on it… 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. This relatively short amount of time can make all the difference for companies… more »
    Ranking
    1st
    out of 50 in Reporting
    Views
    20,317
    Comparisons
    17,415
    Reviews
    19
    Average Words per Review
    555
    Rating
    8.1
    2nd
    out of 50 in Reporting
    Views
    17,947
    Comparisons
    15,259
    Reviews
    19
    Average Words per Review
    620
    Rating
    8.6
    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.

    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
    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%
    Energy/Utilities Company9%
    VISITORS READING REVIEWS
    Educational Organization35%
    Financial Services Firm8%
    Computer Software Company8%
    Government5%
    REVIEWERS
    Financial Services Firm12%
    Computer Software Company12%
    University7%
    Healthcare Company7%
    VISITORS READING REVIEWS
    Educational Organization34%
    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 Business32%
    Midsize Enterprise18%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise39%
    Large Enterprise47%
    Buyer's Guide
    Microsoft Power BI vs. Tableau
    March 2024
    Find out what your peers are saying about Microsoft Power BI vs. Tableau and other solutions. Updated: March 2024.
    763,955 professionals have used our research since 2012.

    Microsoft Power BI is ranked 1st in Reporting with 22 reviews while Tableau is ranked 2nd in Reporting with 18 reviews. Microsoft Power BI is rated 8.0, while Tableau is rated 8.4. The top reviewer of Microsoft Power BI writes "User friendly, easy to set up and great for analyzing data". On the other hand, the top reviewer of Tableau writes "Provides fast data access with in-memory extracts, makes it easy to create visualizations, and saves time". Microsoft Power BI is most compared with Amazon QuickSight, KNIME, Domo, Oracle OBIEE and MicroStrategy, whereas Tableau is most compared with Amazon QuickSight, Domo, SAS Visual Analytics, SAP Analytics Cloud and Databricks. See our Microsoft Power BI vs. Tableau 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.