TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Amazon Quick Sight

    Score8.4 out of 10
    N/AAmazon Quick Sight is a cloud-based Business Intelligence (BI) service within Amazon Quick. It connects enterprise data sources to interactive dashboards, visualizations, natural-language analysis, and analytics workflows.

    $24

    per month per user

    ClickHouse

    Score7.3 out of 10
    N/AClickHouse is an open-source, column-oriented OLAP database system enabling real-time analytical reports using SQL queries. With linear scalability, it handles trillions of rows and petabytes of data. ClickHouse Cloud offers a scalable serverless solution for real-time analytics.N/A
    Pricing
    Amazon Quick SightClickHouse
    Editions & Modules
    Reader
    $3
    per month per user
    Author
    $24
    per month per user
    Reader Pro
    $24
    per month per user
    Author Pro
    $50
    per month per user
    No answers on this topic
    Offerings
    Pricing Offerings
    Amazon Quick SightClickHouse
    Free Trial
    YesYes
    Free/Freemium Version
    NoYes
    Premium Consulting/Integration Services
    NoYes
    Entry-level Setup FeeNo setup feeOptional
    Additional DetailsProspective buyers can also purchase a set number of sessions or questions in lieu of a monthly subscription.Pay for what is used: It automatically scales up and down compute resources based on the user's workload It scales storage and compute separately It automatically scales unused resources down to zero so that users don’t pay for idle services
    More Pricing Information
    Features
    Amazon Quick SightClickHouse
    BI Standard Reporting
    Comparison of BI Standard Reporting features of Amazon Quick Sight and ClickHouse
    Feature
    Amazon Quick Sight
    10.0
    6 Ratings
    20% above category average
    ClickHouse
    -
    Ratings
    Pixel Perfect reports10.05 Ratings00 Ratings
    Customizable dashboards10.06 Ratings00 Ratings
    Report Formatting Templates10.06 Ratings00 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of Amazon Quick Sight and ClickHouse
    Feature
    Amazon Quick Sight
    10.0
    6 Ratings
    22% above category average
    ClickHouse
    -
    Ratings
    Drill-down analysis10.06 Ratings00 Ratings
    Formatting capabilities10.06 Ratings00 Ratings
    Integration with R or other statistical packages10.04 Ratings00 Ratings
    Report sharing and collaboration10.06 Ratings00 Ratings
    Report Output and Scheduling
    Comparison of Report Output and Scheduling features of Amazon Quick Sight and ClickHouse
    Feature
    Amazon Quick Sight
    8.4
    6 Ratings
    2% above category average
    ClickHouse
    -
    Ratings
    Publish to Web8.03 Ratings00 Ratings
    Publish to PDF10.03 Ratings00 Ratings
    Report Versioning10.05 Ratings00 Ratings
    Report Delivery Scheduling7.04 Ratings00 Ratings
    Delivery to Remote Servers7.03 Ratings00 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of Amazon Quick Sight and ClickHouse
    Feature
    Amazon Quick Sight
    10.0
    6 Ratings
    22% above category average
    ClickHouse
    -
    Ratings
    Pre-built visualization formats (heatmaps, scatter plots etc.)10.06 Ratings00 Ratings
    Location Analytics / Geographic Visualization10.05 Ratings00 Ratings
    Predictive Analytics10.03 Ratings00 Ratings
    Pattern Recognition and Data Mining10.01 Ratings00 Ratings
    Access Control and Security
    Comparison of Access Control and Security features of Amazon Quick Sight and ClickHouse
    Feature
    Amazon Quick Sight
    10.0
    6 Ratings
    16% above category average
    ClickHouse
    -
    Ratings
    Multi-User Support (named login)10.06 Ratings00 Ratings
    Role-Based Security Model10.06 Ratings00 Ratings
    Multiple Access Permission Levels (Create, Read, Delete)10.06 Ratings00 Ratings
    Report-Level Access Control10.01 Ratings00 Ratings
    Single Sign-On (SSO)10.05 Ratings00 Ratings
    Mobile Capabilities
    Comparison of Mobile Capabilities features of Amazon Quick Sight and ClickHouse
    Feature
    Amazon Quick Sight
    3.9
    4 Ratings
    66% below category average
    ClickHouse
    -
    Ratings
    Responsive Design for Web Access4.03 Ratings00 Ratings
    Mobile Application3.52 Ratings00 Ratings
    Dashboard / Report / Visualization Interactivity on Mobile3.84 Ratings00 Ratings
    Application Program Interfaces (APIs) / Embedding
    Comparison of Application Program Interfaces (APIs) / Embedding features of Amazon Quick Sight and ClickHouse
    Feature
    Amazon Quick Sight
    6.0
    3 Ratings
    25% below category average
    ClickHouse
    -
    Ratings
    REST API6.12 Ratings00 Ratings
    Javascript API6.62 Ratings00 Ratings
    iFrames7.03 Ratings00 Ratings
    Java API6.12 Ratings00 Ratings
    Themeable User Interface (UI)7.03 Ratings00 Ratings
    Customizable Platform (Open Source)3.03 Ratings00 Ratings
    Best Alternatives
    Amazon Quick SightClickHouse
    Small Businesses
    Cyfe
    Score4 out of 10
    No answers on this topic
    Medium-sized Companies
    Zendesk Explore
    Score8.1 out of 10
    Snowflake
    Score8.7 out of 10
    Enterprises
    Sisense
    Score6.7 out of 10
    Snowflake
    Score8.7 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Amazon Quick SightClickHouse
    Likelihood to Recommend
    10.0
    (6 ratings)
    10.0
    (2 ratings)
    Usability
    10.0
    (2 ratings)
    -
    (0 ratings)
    Support Rating
    9.0
    (1 ratings)
    -
    (0 ratings)
    Data Sharing and Collaboration
    7.1
    (4 ratings)
    -
    (0 ratings)
    Data Sources
    7.1
    (4 ratings)
    -
    (0 ratings)
    User Testimonials
    Amazon Quick SightClickHouse
    Likelihood to Recommend
    Amazon AWS
    Amazon Quicksight is a truly cloud-based solution so it works perfectly fine and saves a lot of expense in terms of hardware and maintenance. We can maintain it by ourselves by giving commands on UI. If you have connectivity issues then it can cause headaches because it's a cloud platform and it's a bit costly as compared to other services
    Incentivized
    Read full review
    ClickHouse, Inc.
    The most important thing when using ClickHouse is to be clear that the scenarios in which you want to use it really are the right ones. Many users think that when a database is very fast for a specific use case, it can be extrapolated to other contexts (most of the time different) in which a previous analysis has not been carried out.
    ClickHouse is an analytical database, as such, it should be used for such purposes, where the information is stored correctly, the data volumes are really large and the queries to be performed are not the typical traditional queries on several columns with multiple aggregations. ClickHouse is not the solution for this.
    On the other hand, if your case is not one of the above, it is quite possible that ClickHouse can help you. Where ClickHouse shines is when you are looking for aggregation over a particular column in large volumes of data.
    Incentivized
    Read full review
    Pros
    Amazon AWS
    • Easily to set up for data sources, already supports quite a few of AWS and non-AWS data sources
    • Cost friendly since users are charged only for basis of usage
    Incentivized
    Read full review
    ClickHouse, Inc.
    • Their MergeTree table engine provide impressive performance for data insert in bulk
    • Not only data insert but also the way MergeTree engine uses Primary Keys to sort the data and perform data skipping based on the granules its also their secret for ridiculous fast queries
    • Data compression its also great
    • They provide especial table engines that allow you to read data directly from other sources like S3
    • Since its written with C++ you have very granular data types and especial ones like enum, LowCardinality and etc, they save you a lot of storage since are stored as integer values
    • ClickHouse functions besides the ones that respect ANSI Standards are also awesome and useful
    Incentivized
    Read full review
    Cons
    Amazon AWS
    • It is still immature as a cloud-based BI tool.
    • Its functionality is about 40-50% of its competitor's products.
    • Application is still a little buggy and non-intuitive at times.
    Incentivized
    Read full review
    ClickHouse, Inc.
    • Avro data manipulation
    • Kafka consistency
    • DDL operations errors (by replica configuration)
    Incentivized
    Read full review
    Usability
    Amazon AWS
    It was helping us a lot as per our business needs. Reporting is way easy with QuickSight that helps us to understand the performance of campaigns effectively and so does the performance of sales individual. We can analyze the data and create a new strategies effectively. Setup and maintenance was way easy
    Incentivized
    Read full review
    ClickHouse, Inc.
    No answers on this topic
    Support Rating
    Amazon AWS
    They provide proper support when needed. They are always ready to provide the box solution and make things easier for users.
    Incentivized
    Read full review
    ClickHouse, Inc.
    No answers on this topic
    Alternatives Considered
    Amazon AWS
    All of the other reporting platforms my organization has used previously were within our CRM and not a standalone program. In that we were very limited in being able to slice and dice the data the way that we wanted to
    Incentivized
    Read full review
    ClickHouse, Inc.
    ClickHouse outperforms, especially in costs, since its compression/indexing engines are so smart, and even with very low computing power, you can already perform huge analyses of the data.
    Incentivized
    Read full review
    Return on Investment
    Amazon AWS
    • Cost Effective
    • Easy setup and maintenance
    Incentivized
    Read full review
    ClickHouse, Inc.
    • Queries that used to take more than 2 minutes now take less than 1 second
    • Possibility to analyze use cases in real time (before was impossible)
    • The applications are more complete and the users decisions are better
    Incentivized
    Read full review
    ScreenShots