MicroStrategy vs Microsoft Power BI 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
MicroStrategy Logo
7,142 views|4,700 comparisons
93% 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, MicroStrategy, 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,599 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
"The best feature for me is Power Query. I know that probably sounds strange, but you can't do too much with visuals and reports if the backend stuff is horribly dirty and just bad. But for me, that is absolutely fantastic. I can load the data and do the transformation and be able to load it in a useful way. There are tons of connections, which is absolutely fantastic as well. It's been fairly easy, and it's intuitive.""Microsoft BI was very helpful for me because I had a huge variety of connections. It is very convenient to build reports, even if somebody has no experience using BI tools or data visualizations. Additionally, the performance is very good when generating reports.""In the process of using data there is the Extract, Transform and Load (ETL). For extracting we are using another software, for transforming we are using our own coding in C#, and then we use Microsoft BI for loading the information. Microsoft BI displays information very well.""The initial setup is pretty straightforward.""The user experience is easy. Users get familiar with it quickly.""The most valuable features are the flexibility, how many ways you can interrogate the data, and the the graphical visualization.""As it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools.""Ability to extract data from a variety of sources and systems."

More Microsoft Power BI Pros →

"Speed for high level aggregation by using Intelligent Cubes.""I really like the visualizations. I like how you can put large data sets in there, then the user can quickly go through the data and drill down at various levels to understand things.""The mobile for MicroStrategy is the best of all the BI platforms. As a separate product for the mobile device, MicroStrategy is the entire BI platform. It is an enterprise solution, a separate unit, etc.""The ability to integrate with PPT is another plus. The platform's ability to write back data directly to the database is also good.""We prefer having our analytics capabilities in a single platform, which MicroStrategy's offers.""Comprehensive security control and more.""In the past, when we had so many legacy systems, with Cognos and others, it was took multiple steps to get what we wanted. Now, it's a seamless integration. We can connect directly, in the form of In-Memory Cubes or live-publish cubes, to the data warehouse, and blend in the data with big data. Not only relational databases, but we can also integrate other third-party files, and create a single-source software.""The implementation was fairly straightforward."

More MicroStrategy Pros →

"Data handling, visualizations, and aesthetics of it are the most valuable features.""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.""Tableau's initial setup was straightforward.""The data visualization piece is most valuable. We do ad-hoc analysis or one-time shot things, but there are things that we have to track every single day. When our management and our customers want to see how things are changing, the dashboarding provides that information. Tableau is key in providing that data on a refresh basis. We use a data blending tool that pumps the data into Tableau, and we just schedule it to run every single day. So, the automation of the data and being able to present it to people who are interested are the most valuable features.""The initial setup is simple.""It is easy to adapt visualizers to have interactive conversations among decision-makers.""Tableau is good for routine dashboards, and it has integration with Slack, through which it can send you daily updates.""While using this solution I have found the valuable features to be ease of use and the visualization. It is a complete solution."

More Tableau Pros →

Cons
"The solution's documentation needs improvement.""The performance of Microsoft BI could improve for large datasets and it would be beneficial to have more visualization features.""Power BI shows reports on actual data, not metadata.""The mobile app is very poor.""I would like to be able to use more predicting data science features without having to use R.""I am taking a course to be able to use the solution better. Some aspects of the solution are not straightforward.""It has limited performance capabilities in terms of connecting to large transactional databases, but it is fine for simple and quick queries from Excel spreadsheets or one table. The premium level is going to be more applicable for the higher transaction-level databases.""The cost of the solution can get high."

More Microsoft Power BI Cons →

"It needs row-level security, column-level security, on attributes. I want to be able to handle full-scale security model from the semantic layer, flat out.""The In-Memory Capability (cubes) needs a lot of improvement.""When we come to them with a problem, they might know more of a generalized solution, but not one targeted to our industry.""MicroStrategy is not cloud native today and some of their APIs are a little limiting.​""We're starting to open it up to more and more people to give them the ability and start looking at these things themselves, but it's not the most intuitive system, Enterprise Manager that is, so it's tough. We're trying to bridge the gap between usability and who we let in the system, because you're not going to come in and just pick it up.""The areas that have room for improvement in MicroStrategy are mainly related to building additional tools. Specifically, the embedding process has been a bit of a struggle.""The solution's licensing could be improved because its cost is heavy on the pockets.""I would try to make it a little more basic, user-friendly. In terms of the UX, it's a bit sluggish there."

More MicroStrategy Cons →

"The charts in Tableau are quite limited.""The customization in the front end is a bit difficult.""The data preparation could integrate better with Tableau.""The price could be better.""There are not enough language options. It needs to be offered in more than just English.""The solution’s pricing could be improved.""The charting is overly complex in comparison with Power BI's""Its price should be improved. Its price is much higher than Power BI and QlikView. Programming is not easy on Tableau. For programming, you have to have a separate model. They should include programming directly on the web portion of the Tableau desktop so that people can write Python or JavaScript code for customizations instead of using a different model. Currently, Tableau Data Prep is a separate application that you have to purchase. It would be helpful if they can include Tableau Data Prep and programming languages such as R, Python in the next version. Tableau Public, which is a community version, doesn't allow you to save your work on your desktop. They should allow it. Currently, you can only upload it in the community."

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 →

  • "They made a change in the licensing module some time ago and we can now use all the enterprise tools for free."
  • "The pricing for MicroStrategy is always on the higher side. They should seriously start thinking about their pricing and licensing strategy."
  • "While initial cost of MicroStrategy is still on the higher side, the long-term benefits brings down overall cost of ownership significantly as compared to other tools like Tableau/Cognos."
  • "The price was good. We have had great support along the way."
  • "We actually researched some of the other solutions. For options, price, and customer acceptance, this product has worked well for us.​"
  • "​They gave us a good deal.​"
  • "There have been actual direct bottomline impacts in terms of extra revenue created from the reporting solutions."
  • "They need to work on their license structure. They are not competitive against somebody like SAP BusinessObjects. We had a quote that was almost a third the price, coming from SAP BusinessObjects, and it's not a better platform. It's not cheaper. They do concurrent user licensing, while MicroStrategy does named user licensing, and that was literally the only difference. But it made a $500,000 difference. They've got to do something to make themselves more competitive. Maybe it's assessing your business users and what you really expect them to use, and maybe giving a reduced price on that. But they are already giving us a 60% discount and they were still a million or so above, over a three-year time period. That doesn't account for synergies as we get from on-site resources that are already available, but I thought that that was a big, big deficit for them."
  • More MicroStrategy 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,599 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    After a recent presentation, several attendees asked me about the applications of Visual Insights and Tableau. Many companies are investing in both tools and are trying to figure out the right tool for specific applications Tableau has found its sweet-spot as an agile discovery tool that analysts use to create and share insights. It is also the tool of choice for rapid prototyping of dashboards. Tableau is very flexible with its data import. Tableau's data blending capability is very intuitive. This capability is useful when you have data spread across several different sources that has not gone through ETL processes. This is a problem analysts deal with routinely. They are unable to wait for the data warehouse team to develop ETL processes to provide the physical models they need to build an analysis. The Tableau interface is Excel-like and has a low barrier to entry for analysts that are used to working in Excel. Building a dashboard by mashing up visualizations in a Tableau worksheet is extremely simple. Users are able to build good presentation-quality dashboards in a very short amount time. Tableau's annotations capabilities and its time and geographical intelligence are key differentiators. Tableau has overcome limitations in data sharing with the introduction of a Data Server in Tableau 7.0. The Data server allows Data sources and extracts to be shared securely and opens up interesting new possibilities. If your application can take advantage of the above… Read more →
    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 stability of the product is good.
    Top Answer:MicroStrategy's licensing cost is higher than that of other tools in the market. My company uses the enterprise edition… more »
    Top Answer:For everything we do in our company, we consider MicroStrategy to be a workaround solution. For better customization in… 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
    7,142
    Comparisons
    4,700
    Reviews
    12
    Average Words per Review
    568
    Rating
    7.5
    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.

    Company: Founded in 1989, MicroStrategy (Nasdaq: MSTR) is a leading worldwide provider of enterprise software platforms. With direct operations in 26 countries worldwide and approximately 2,000 employees, our mission is to provide enterprise analytics, mobility, and security platforms that are flexible, powerful, scalable and user-friendly. To learn more, visit MicroStrategy online, and follow us on Facebook and Twitter.

    Product portfoilio:

    MicroStrategy 10 Secure Enterprise™ empowers leading organizations to analyze vast amounts of data and distribute actionable business insight throughout an enterprise through two distinct offerings: MicroStrategy Analytics™ and MicroStrategy Desktop™. MicroStrategy Analytics delivers reports and dashboards, and enables users to conduct ad hoc analysis and share insights anywhere, anytime, via mobile devices or the Web. It also combines the agility and productivity of self-service visual data discovery with the security, scalability, and governance features of enterprise-grade business intelligence. MicroStrategy Desktop is a standalone, on-premise visual data discovery tool designed to enable business users to analyze and understand their data. MicroStrategy Mobile™ enables organizations to rapidly build custom business applications that deliver analytics combined with transactions, multimedia, and custom workflows to mobile devices. MicroStrategy Secure Cloud™ combines all of the enterprise analytics, mobile, and security features in MicroStrategy 10 Secure Enterprise with powerful and scalable data integration, validation, and warehousing services — all delivered in an environment where organizations can deploy transformational analytics applications in minutes.

    Usher, MicroStrategy’s breakthrough security solution, is a powerful mobile security platform designed to dematerialize traditional forms of identity verification (such as passwords, tokens, and physical badges) and replace them with a single mobile identity badge that is cryptographically linked to its owner’s smartphone and dynamically linked to an enterprise’s existing identity repositories. Usher works on standard Android and iOS smartphones, and also boasts an Apple Watch™ integration.

    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
    Allstate Insurance, Barneys New York, Boston Children's Hospital, Buenos Aires Department of the Treasury, Campbell Soup Company, DHL, eBay, eHarmony, Facebook, Four Seasons Hotels Inc., Godiva, Hard Rock International, LinkedIn, Netflix, Pfizer, SECO (Swiss Government Unemployment Agency), Starbucks, Texas A&M University, Thomson Reuters Markets, US House of Representatives, and the US Postal Service.
    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 Firm15%
    Healthcare Company13%
    Retailer11%
    Computer Software Company7%
    VISITORS READING REVIEWS
    Financial Services Firm17%
    Computer Software Company11%
    Retailer9%
    Insurance Company6%
    REVIEWERS
    Financial Services Firm13%
    Computer Software Company12%
    University7%
    Healthcare Company7%
    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 Business22%
    Midsize Enterprise17%
    Large Enterprise62%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise12%
    Large Enterprise71%
    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,599 professionals have used our research since 2012.