Microsoft Power BI vs Tableau vs ThoughtSpot comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
33,848 views|28,652 comparisons
92% willing to recommend
Tableau Logo
26,131 views|22,454 comparisons
89% willing to recommend
ThoughtSpot Logo
2,005 views|1,509 comparisons
87% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Microsoft Power BI, Tableau, and ThoughtSpot 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).
770,292 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
"We found the initial setup to be straightforward.""I like the downloadable visualizations a lot. I think that they give the user a very nice starting point in creating awesome dashboards, with the right way to tell their data story.""The solution is easy to use and charts can be built quickly with the tools.""It is stable enough. It has a lot of powerful functions. It can also be customized with the DAX language. It is also intuitive enough and incremental. You can start with something simple, and then step-by-step, you can increase the reports and dashboards according to your needs.""The advantages of Microsoft Power BI stem from the fact that it is really easy to use. The drag and drop facilities provided by the product are good.""What Power BI is, is a whole collection of templates of small amounts of data that can be used to do something for a real world project, that can be easily set up and become the business intelligence environment or a data warehouse for a large amount of data, for a real world customer. That's what is remarkable.""What's most valuable in this tool is that it gives its users detailed error messages. It's a very stable data analytics tool, and it offers good scalability.""It is easy to use. It has got a desktop where people can develop their own dashboards. Basically, we have figured out how to connect finance contracts and all programs for the government agency. So, they can see everything in a dashboard. So, it is very easy to use from a technical standpoint of view."

More Microsoft Power BI Pros →

"The most valuable features are the visualizations, the way they show the combination charts.""Very user friendly.""The product offers an intuitive user interface, detailed screens and widgets, and the absence of data limitations""The ease of presenting findings is very helpful.""The UI part is the best. The end-users can easily get started with Tableau Desktop or Tableau Online because of its user-friendliness.""It provides supporting data for critical policy and operational changes""One of the most valuable features of Tableau is that it's a visual analytics solution, not just a dashboarding solution. Compared to Power BI, which is a dashboarding solution, there are no limitations with Tableau. For example, when you add a chart or a map to Power BI, it has a 3,000-point limitation. When you try to track your whole vehicle on the map, you only see the first 3,000 rows on the map, and Power BI doesn't tell you which part of the data is shown on the map. But Tableau doesn't have any limitations, which means that you can see five million data points on a map. It starts the project by creating the visuals that directly converts to SQLs. In that way, all the components have no limitations. When we compared Tableau to Power BI, we also found Tableau to be more fancy. Fancy means you can create more visual graphics and more visual dashboards. With Power BI, this isn't so—it's just some tables and some simple charts together. Tableau is more for business users who want to analyze data. Tableau can directly connect the analytics systems, like R or Titan, and get the results in screen, so it's a good solution for analytics scientists. It has some predefined capabilities to understand the data.""It is a very stable product. It doesn't break."

More Tableau Pros →

"The ability to do ad hoc explorations of data has been most valuable.""I would say the return on investment is good. Whatever we invested, we got results. We have been finding it easy to use and onboard new use cases.""The initial setup was very straightforward.""It is easy to set up the solution.""ThoughtSpot takes the modifying of existing reports out of our hands.""I like ThoughtSpot's search capabilities. You can also create custom analytics even if you aren't an experienced data analyst. We have users with no data analytics experience making some of the dashboards we've created, copying components, and customizing them to their specific use cases.""It's easy to drill down or expand data to get more details right out of the box.""The scalability is good."

More ThoughtSpot Pros →

Cons
"Microsoft has got a very large repository of all change suggestions which have been raised by the BI community. They keep on adding features that are very widely sought after by the community. We don't focus on product features. We focus on business requirements. To use the solution, we find that existing features are good enough and offer us a very effective solution.""One opportunity for improvement would be on the Power Query side. As a consultant, I know Power Query is not the main strength of Power BI. It is not where Power BI shines, but many customers use Power Query to do full ETL workloads for deliverable cookies.""I have to write scripts to query data for analyzing performance.""The integration in Microsoft BI could improve for other solutions, such as Oracle DB and PostgresSQL. Additionally, the reporting from the databases to Microsoft BI should be in real-time and the overall performance could be better.""It's not really complicated, but I didn't find the things I was looking for. The ones I used to work with within Dash are more open, and there are more choices. But with Power BI, there are only limited types of plots that I can use. For example, when I wanted to put the plots in Power BI, there was no extendable space. You have a limited page where you can place a maximum of three plots in that, and you can't do more than that on a single page. You have to create a new page, a different page for that. That made it a bit annoying, and the filtering part is limited, with basic functions. If you want to make custom filtering or custom functions, you can't do that.""I would like for the next release to have better desktop performance, especially for big databases. Additionally, I would like to have more integrations with programs like Salesforce in order to get more live data coming in.""The integration with third-party products could be more stable.""The Microsoft BI interface should be simpler and more user-friendly. I find it very difficult to move between their data sources and their analytics section."

More Microsoft Power BI Cons →

"Tableau has so many functions, so sometimes it's hard to find the right solution quickly. I have to search multiple menu bars to find the right command.""The user experience for less savvy or non-technical people (from my experience).""The data entered into Tableau must be clean. Otherwise, it won't work properly.""It needs a little bit more advanced modeling. I would like to see functionality like Cognos has in the Framework Manager.""The only issue with the solution is with its prices at a regional level.""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.""In the next release, there should be more information describing each chart because users have a difficult time telling them apart. They should also include the animations/videos, similar to Power BI.""I would like Tableau to handle geospatial data better in terms of multiple layers and shapefiles."

More Tableau Cons →

"If I want to order columns, this feature is not there.""A customized visualization is lacking in this product.""I would like to see more flexibility in adding the pins. Currently, we have four different sizes in which I can add pins, but I would like to be able to resize my pins.""The most difficult thing I found is that it only deals with the files and does not have direct connectivity to databases.""The dashboards could give you more ability to fine tune the appearance. You get a great deal more control over how something looks in Power BI than you do in ThoughtSpot.""The one area of the solution that I do hear needs improvement is on the visualization front.""In terms of features, I'd like to be able to pivot data - for example, going from rows to columns. It's not easy to do.""ThoughtSpot is a fairly new product, so some usability aspects aren't as mature as we'd like them to be. One example is their organizational methodology, like how objects are organized in their dashboards inside the product. They're all on a flat list, which works if you've got five or 10 dashboards. However, it's insufficient when you're a large enterprise with multiple groups looking at the same dashboards. It isn't organized well."

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

  • "I give the pricing a six out of ten."
  • More ThoughtSpot Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
    770,292 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: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 »
    Top Answer:It's easy to drill down or expand data to get more details right out of the box.
    Top Answer:I like the pricing structure. I get billed by how much data I put in, not how many people are looking at the data. It's… more »
    Top Answer:We'd like more flexibility with the calendar as our fiscal year does not align with the calendar year. We have to load… more »
    Ranking
    Views
    33,848
    Comparisons
    28,652
    Reviews
    27
    Average Words per Review
    619
    Rating
    7.9
    Views
    26,131
    Comparisons
    22,454
    Reviews
    13
    Average Words per Review
    537
    Rating
    8.7
    Views
    2,005
    Comparisons
    1,509
    Reviews
    8
    Average Words per Review
    783
    Rating
    7.5
    Comparisons
    Amazon QuickSight logo
    Compared 10% of the time.
    Domo logo
    Compared 9% of the time.
    SAS Visual Analytics logo
    Compared 5% of the time.
    Databricks logo
    Compared 4% of the time.
    SAP Analytics Cloud logo
    Compared 4% of the time.
    Looker logo
    Compared 13% of the time.
    Amazon QuickSight logo
    Compared 5% of the time.
    Mode Analytics logo
    Compared 5% of the time.
    Apache Superset logo
    Compared 4% of the time.
    Alteryx logo
    Compared 3% of the time.
    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.

    ThoughtSpot is a powerful business intelligence tool that allows easy searching and drilling into data. Its ad hoc exploration and query-based search features are highly valued, and it is easy to set up, stable, and scalable. 

    The solution is used for reporting purposes, self-service BI, and embedding into other applications for customers to do self-service analytics. It helps businesses with metrics, KPIs, and important insights by sourcing data from various sources into one golden source and visualizing it in an easy way for the business to consume. The pricing model is ideal, charging for data rather than the number of users.

    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.
    Primary Capital Mortgage, Sterling Backcheck, RichRelevance, Rambus, Batteries Plus Bulbs
    Top Industries
    REVIEWERS
    Financial Services Firm15%
    Manufacturing Company13%
    Computer Software Company11%
    Government9%
    VISITORS READING REVIEWS
    Educational Organization35%
    Financial Services Firm8%
    Computer Software Company8%
    Government5%
    REVIEWERS
    Financial Services Firm13%
    Computer Software Company12%
    Healthcare Company7%
    University7%
    VISITORS READING REVIEWS
    Educational Organization35%
    Financial Services Firm11%
    Computer Software Company8%
    Manufacturing Company6%
    VISITORS READING REVIEWS
    Financial Services Firm24%
    Computer Software Company11%
    Manufacturing Company10%
    Healthcare Company7%
    Company Size
    REVIEWERS
    Small Business39%
    Midsize Enterprise16%
    Large Enterprise45%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise42%
    Large Enterprise45%
    REVIEWERS
    Small Business32%
    Midsize Enterprise18%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise40%
    Large Enterprise47%
    REVIEWERS
    Small Business13%
    Large Enterprise88%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise9%
    Large Enterprise78%
    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.
    770,292 professionals have used our research since 2012.