Dremio vs MicroStrategy comparison

Cancel
You must select at least 2 products to compare!
Dremio Logo
2,610 views|1,995 comparisons
100% willing to recommend
MicroStrategy Logo
7,327 views|4,856 comparisons
93% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Dremio and MicroStrategy based on real PeerSpot user reviews.

Find out what your peers are saying about Databricks, Microsoft, Alteryx and others in Data Science Platforms.
To learn more, read our detailed Data Science Platforms Report (Updated: April 2024).
767,995 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
"Everyone uses Dremio in my company; some use it only for the analytics function.""Dremio enables you to manage changes more effectively than any other data warehouse platform. There are two things that come into play. One is data lineage. If you are looking at data in Dremio, you may want to know the source and what happened to it along the way or how it may have been transformed in the data pipeline to get to the point where you're consuming it.""The most valuable feature of Dremio is it can sit on top of any other data storage, such as Amazon S3, Azure Data Factory, SGFS, or Hive. The memory competition is good. If you are running any kind of materialized view, you'd be running in memory.""Dremio allows querying the files I have on my block storage or object storage.""We primarily use Dremio to create a data framework and a data queue.""Dremio gives you the ability to create services which do not require additional resources and sterilization."

More Dremio Pros →

"This solution is the most scalable BI platform in the world.""The solution is a very good enterprise tool with excellent enterprise functionality for security and user access. It also works perfectly in distribution, with everyone getting their own reports. It is very complex, so you can do whatever you want. If you want to make some data limitations, you can do it. I also like the internal in-memory engine with the Symantec layer. This makes the solution pretty powerful.""The solution has excellent features available on mobile.""We use MicroStrategy as an integrated solution with some of their other CRM type applications.""The whole repository side of things is beneficial because you develop it once, and you can use it anywhere, in the Enterprise grade.""The single stack solution will always be more profitable, scalable, and elastic for organizational needs.""Dossiers are going to change the name of the game for us. We want to be able to have the executive committee go into a meeting and tell a story. We want them to tell us a story, not us.""We pretty much use the knowledge base.​ We feel that Microstrategy's community is a good forum to use."

More MicroStrategy Pros →

Cons
"We've faced a challenge with integrating Dremio and Databricks, specifically regarding authentication. It is not shaking hands very easily.""Dremio takes a long time to execute large queries or the executing of correlated queries or nested queries. Additionally, the solution could improve if we could read data from the streaming pipelines or if it allowed us to create the ETL pipeline directly on top of it, similar to Snowflake.""They have an automated tool for building SQL queries, so you don't need to know SQL. That interface works, but it could be more efficient in terms of the SQL generated from those things. It's going through some growing pains. There is so much value in tools like these for people with no SQL experience. Over time, Dermio will make these capabilities more accessible to users who aren't database people.""Dremio doesn't support the Delta connector. Dremio writes the IT support for Delta, but the support isn't great. There is definitely room for improvement.""I cannot use the recursive common table expression (CTE) in Dremio because the support page says it's currently unsupported.""It shows errors sometimes."

More Dremio Cons →

"It is actually pretty complicated to use.​ It is complicated enough that user adaptation is sometimes difficult. We developed more experts rather than people using it.​""Data preparation-wise, it was not so straightforward with respect to getting different sources. Preparing or transforming the data inside and then bringing it onto the dashboard was a bit difficult, and the experience could have been better.""The solution has a very non-logical user usage part. It has a library mode where users can access all the data, reports, and dashboards, but they also can be accessed from a platform. They have to log into the platform. The user experience is confusing for the users. MicroStrategy needs to define which one they will use. Some functionality isn’t available in library mode but is available in the portal. There should be Office integration. For example, if I do a presentation, then I should be able to add a chart to my presentation.""This solution is missing enhanced features in the dashboards.""I think they're still lacking on customer service. I think historically, MicroStrategy's customer service was a lot better than it is today.""We have not invested nor are we planning to invest in MicroStrategy's mobile platform.​​""Getting our data to work with the tool is where we are having issues.​""Training would be an area that they could improve upon."

More MicroStrategy Cons →

Pricing and Cost Advice
  • "Right now the cluster costs approximately $200,000 per month and is based on the volume of data we have."
  • "Dremio is less costly competitively to Snowflake or any other tool."
  • More Dremio 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 →

    report
    Use our free recommendation engine to learn which Data Science Platforms solutions are best for your needs.
    767,995 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:Dremio allows querying the files I have on my block storage or object storage.
    Top Answer:Every tool has a value based on its visualization, and the pricing is worth its value.
    Top Answer:Dremio's interface is good, but it has a few limitations. I cannot do a lot of things with ANSI SQL or basic SQL. I cannot use the recursive common table expression (CTE) in Dremio because the support… 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 of the product. For beginners, there are trial accounts that are provided by the… more »
    Top Answer:For everything we do in our company, we consider MicroStrategy to be a workaround solution. For better customization in documents or dashboards, MicroStrategy can improve the features or settings… more »
    Ranking
    10th
    Views
    2,610
    Comparisons
    1,995
    Reviews
    6
    Average Words per Review
    530
    Rating
    8.7
    Views
    7,327
    Comparisons
    4,856
    Reviews
    12
    Average Words per Review
    568
    Rating
    7.5
    Comparisons
    Learn More
    Dremio
    Video Not Available
    Overview

    Dremio is a data lake query engine tool that creates PDSs and VDSs on top of S3 buckets. It is used for managing simple ad-hoc queries and as a greater layer for ad-hoc queries. The most valuable features of Dremio include its ability to sit on top of any data storage, generate refresh reflections and create visuals, manage changes effectively through data lineage and data providence capabilities, use open-source, and address the problem of data transfer when working with large datasets. The use cases are broad, allowing for high-performance queries from a data lake.

    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.

    Sample Customers
    UBS, TransUnion, Quantium, Daimler, OVH
    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.
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm31%
    Computer Software Company11%
    Manufacturing Company8%
    Retailer4%
    REVIEWERS
    Financial Services Firm15%
    Healthcare Company13%
    Retailer11%
    Computer Software Company7%
    VISITORS READING REVIEWS
    Financial Services Firm17%
    Computer Software Company11%
    Retailer9%
    Insurance Company6%
    Company Size
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise10%
    Large Enterprise74%
    REVIEWERS
    Small Business22%
    Midsize Enterprise17%
    Large Enterprise62%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise12%
    Large Enterprise71%
    Buyer's Guide
    Data Science Platforms
    April 2024
    Find out what your peers are saying about Databricks, Microsoft, Alteryx and others in Data Science Platforms. Updated: April 2024.
    767,995 professionals have used our research since 2012.

    Dremio is ranked 10th in Data Science Platforms with 6 reviews while MicroStrategy is ranked 9th in BI (Business Intelligence) Tools with 155 reviews. Dremio is rated 8.6, while MicroStrategy is rated 8.2. The top reviewer of Dremio writes "Quick database capabilities but sometimes shows minor errors". On the other hand, the top reviewer of MicroStrategy writes "A robust solution for powerful data analytics". Dremio is most compared with Databricks, Snowflake, Starburst Enterprise, Amazon Redshift and Microsoft Azure Synapse Analytics, whereas MicroStrategy is most compared with Microsoft Power BI, Tableau, SAP BusinessObjects Business Intelligence Platform, IBM Cognos and Qlik Sense.

    We monitor all Data Science Platforms 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.