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."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."
"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."
"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."
"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."
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.