Amazon QuickSight vs Dremio comparison

Cancel
You must select at least 2 products to compare!
Amazon Web Services (AWS) Logo
15,869 views|14,269 comparisons
56% willing to recommend
Dremio Logo
2,683 views|2,043 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Amazon QuickSight and Dremio 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: May 2024).
771,157 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
"One of the most valuable features of Amazon QuickSight has been the speed at which visualizations can be created.""The most valuable feature of Amazon QuickSight is its connectivity with other Amazon services.""The query and dashboard capabilities are entirely good.""The most valuable feature I have found is the low-level securities are very easy to use.""The most valuable feature of this solution is the user interface.""Compared to other reporting tools, it is very effective but does require an understanding of certain concepts in QuickSight. This understanding is crucial for creating dimensions, changing metrics, and visualizing reports.""It helped the managers to visualize the data activities.""The solution's most valuable feature is its flexibility to visualize certain logs."

More Amazon QuickSight 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.""Dremio gives you the ability to create services which do not require additional resources and sterilization.""We primarily use Dremio to create a data framework and a data queue."

More Dremio Pros →

Cons
"They could provide more options for graphics and other features.""It should support integration with Python or R.""There is room for improvement in terms of the number of visualizations and dashboards that are available.""The product has some storage and SPICE data issues.""The solution must be more user-friendly.""Right now, you can't use Amazon QuickSight on other cloud providers, so I'd like it to have availability on other cloud providers. This is an area for improvement in the product. What I'd like to see in Amazon QuickSight in the future is a distributed centralized system where I can manage all reports in one place, and for Amazon QuickSight to become reporting as a service.""The number of features in the product is limited in comparison with the other tools in the market, like Power BI.""It can be made more user-friendly as some users might find this solution hard to implement. Qlik Sense, for example, is very user-friendly."

More Amazon QuickSight Cons →

"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.""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.""It shows errors sometimes.""I cannot use the recursive common table expression (CTE) in Dremio because the support page says it's currently unsupported.""We've faced a challenge with integrating Dremio and Databricks, specifically regarding authentication. It is not shaking hands very easily."

More Dremio Cons →

Pricing and Cost Advice
  • "I wouldn't say that it is an expensive product, but to stay competitive they would need to bring down the prices."
  • "It is simpler and cheaper than other solutions."
  • "Amazon QuickSight you subscribe and you use the service."
  • "The standard edition is free to use for exploration purposes while the enterprise edition needs to be paid for. The pricing for this solution is very reasonable."
  • "The Amazon QuickSight licensing model my company's on is pay-as-you-go, but I wouldn't be able to give the figures because that's handled by the finance department."
  • "I'm using a paid version of Amazon QuickSight, paying about $22 monthly. As I have yet to learn about the pricing for other tools, such as Power BI, I won't be able to compare."
  • "The pricing is cost-effective with a good plan."
  • "A highly affordable cost structure with fixed membership and timeframe basis options."
  • More Amazon QuickSight 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 →

    report
    Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
    771,157 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The integration is very seamless. We stored our result CSV files in S3 and connected directly from there.
    Top Answer:My company had a corporate discount and other arrangements, so I'm not familiar with the standard pricing.
    Top Answer:Compared to Power BI, I felt QuickSight lacks some features, like delayed drill-downs. Drill-downs were the main area where we found QuickSight lacking. Especially for root cause analysis, the ability… more »
    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 »
    Ranking
    Views
    15,869
    Comparisons
    14,269
    Reviews
    16
    Average Words per Review
    498
    Rating
    7.1
    9th
    Views
    2,683
    Comparisons
    2,043
    Reviews
    6
    Average Words per Review
    530
    Rating
    8.7
    Comparisons
    Also Known As
    QuickSight
    Learn More
    Overview

    Amazon QuickSight is a fast, cloud-powered business analytics service that makes it easy to build visualizations, perform ad-hoc analysis, and quickly get business insights from your data. Using our cloud-based service you can easily connect to your data, perform advanced analysis, and create stunning visualizations and rich dashboards that can be accessed from any browser or mobile device.

    Dremio is a data analytics platform designed to simplify and expedite the data analysis process by enabling direct querying across multiple data sources without the need for data replication. This solution stands out due to its approach to data lake transformation, offering tools that allow users to access and query data stored in various formats and locations as if it were all in a single relational database.

    At its core, Dremio facilitates a more streamlined data management experience. It integrates easily with existing data lakes, allowing organizations to continue using their storage of choice, such as AWS S3, Microsoft ADLS, or Hadoop, without data migration. Dremio supports SQL queries, which means it seamlessly integrates with familiar BI tools and data science frameworks, enhancing user accessibility and reducing the learning curve typically associated with adopting new data technologies.

    What Are Dremio's Key Features?

    • Data Reflections: Reduces query times by creating optimized representations of source data, which can accelerate performance without the complexity of traditional data warehousing solutions.
    • Semantic Layer: Allows users to define business metrics and dimensions centrally, ensuring consistency and governance across all analytics tools.
    • Built-in Security Features: Provides robust security measures, including column- and row-level security, ensuring compliance with data governance and privacy standards.
    • Support for Multiple Data Formats and Sources: Enables querying directly against a variety of data formats (Parquet, JSON, etc.) and sources without the need for conversion or replication.

    What Benefits Should Users Expect?

    When evaluating Dremio, potential users should look for feedback on its query performance, especially in environments with large and complex data sets. Reviews might highlight the efficiency gains from using Dremio’s data reflections and its ability to integrate with existing BI tools without significant changes to underlying data structures. Also, check how other users evaluate its ease of deployment and scalability, particularly in hybrid and cloud environments.

    How is Dremio Implemented Across Different Industries?

    Dremio is widely applicable across various industries, including finance, healthcare, and retail, where organizations benefit from rapid, on-demand access to large volumes of data spread across disparate systems. For instance, in healthcare, Dremio can be used to analyze patient outcomes across different data repositories, improving treatment strategies and operational efficiencies.

    What About Dremio’s Pricing, Licensing, and Support?

    Dremio offers a flexible pricing model that caters to different sizes and types of businesses, including a free community version for smaller teams and proof-of-concept projects. Their enterprise version is subscription-based, with pricing varying based on the deployment scale and support needs. Customer support is comprehensive, featuring dedicated assistance, online resources, and community support.

    Sample Customers
    MLB Advanced Media, Infor, HotelBeds, Gemini, Jivochat, Edmunds.com
    UBS, TransUnion, Quantium, Daimler, OVH
    Top Industries
    REVIEWERS
    Computer Software Company40%
    Financial Services Firm20%
    University7%
    Educational Organization7%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Financial Services Firm14%
    Manufacturing Company7%
    Government6%
    VISITORS READING REVIEWS
    Financial Services Firm31%
    Computer Software Company11%
    Manufacturing Company8%
    Retailer4%
    Company Size
    REVIEWERS
    Small Business13%
    Midsize Enterprise30%
    Large Enterprise57%
    VISITORS READING REVIEWS
    Small Business22%
    Midsize Enterprise14%
    Large Enterprise64%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise11%
    Large Enterprise73%
    Buyer's Guide
    BI (Business Intelligence) Tools
    May 2024
    Find out what your peers are saying about Microsoft, Tableau, Oracle and others in BI (Business Intelligence) Tools. Updated: May 2024.
    771,157 professionals have used our research since 2012.

    Amazon QuickSight is ranked 4th in BI (Business Intelligence) Tools with 24 reviews while Dremio is ranked 9th in Data Science Platforms with 6 reviews. Amazon QuickSight is rated 6.8, while Dremio is rated 8.6. The top reviewer of Amazon QuickSight writes "Useful for developing dashboards for various lines of business". On the other hand, the top reviewer of Dremio writes "It enables you to manage changes more effectively than any other platform". Amazon QuickSight is most compared with Microsoft Power BI, Tableau, Looker, Google Data Studio and Qlik Sense, whereas Dremio is most compared with Databricks, Snowflake, Starburst Enterprise and Amazon Redshift.

    We monitor all BI (Business Intelligence) Tools 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.