Amazon QuickSight vs Amazon Redshift

Amazon QuickSight

Amazon QuickSight is well suited in any organization that is making business decisions based on performance data whether it be Marketing, Sales, Call Center, etc. It is a great tool especially for mature organizations that have a lot of data to work with. Amazon QuickSight may be not as well suited for newer organizations that are just beginning to drive data/performance metrics. The data available becomes more and more valuable to more that you have.

Read full review

Megan Sullivan

Marketing Director

LightRx Face & BodyConsumer Services, 201-500 employees

View all 2 answers on this topic

Amazon Redshift

It is well suited for:

Petabytes of data requiring near real-time analysis
Massive Data Insertions
Massive Data Reads

It isn't well suited for:

Web apps
Smaller transactional inserts
Smaller reads

You wouldn't drive an 18-wheeler to the corner store to pick up a bag of chips. Your specific need will determine whether or not Redshift is suited for the job.

Read full review

Kyle Reichelt

Senior Project Manager

OnMetricInternet, 11-50 employees

View all 13 answers on this topic

Feature Rating Comparison

Amazon QuickSight

7.5

Amazon Redshift

—

Pixel Perfect reports

10.0

—

Customizable dashboards

6.5

—

Report Formatting Templates

6.1

—

Amazon QuickSight

6.7

Amazon Redshift

—

Drill-down analysis

7.3

—

Formatting capabilities

6.3

—

Report sharing and collaboration

6.5

—

Amazon QuickSight

5.5

Amazon Redshift

—

Report Versioning

8.0

—

Report Delivery Scheduling

3.0

—

Amazon QuickSight

8.0

Amazon Redshift

—

Pre-built visualization formats (heatmaps, scatter plots etc.)

6.1

—

Location Analytics / Geographic Visualization

10.0

—

Amazon QuickSight

6.5

Amazon Redshift

—

Multi-User Support (named login)

8.2

—

Role-Based Security Model

6.9

—

Multiple Access Permission Levels (Create, Read, Delete)

6.9

—

Single Sign-On (SSO)

4.0

—

Amazon QuickSight

9.7

Amazon Redshift

—

Responsive Design for Web Access

10.0

—

Dashboard / Report / Visualization Interactivity on Mobile

9.4

—

Pros

Amazon QuickSight is a really easy program to learn how to use.
Amazon QuickSight allows our team to customize the data using the various data sets, which makes the available reports incredibly powerful to our organization.
Our organization has the ability continually adjust our reports and build new reports as business needs change.
Even though our organization has different reports built for different departments, each department can still access and understand reports from across the company.

Read full review

Megan Sullivan

Marketing Director

LightRx Face & BodyConsumer Services, 201-500 employees

View all 2 answers on this topic

Extremely fast querying allowing for concurrent analysis.
PostgreSQL syntax which allows for developers with a SQL background to easily begin working with the data.
Multiple output formats including JSON.
Safe, easy, and reliable backups.

Read full review

Brendan McKenna

Senior Developer

American Board of Internal MedicineNon-Profit Organization Management, 201-500 employees

View all 13 answers on this topic

Cons

One of the primary challenges I've had with Amazon QuickSight so far is that some of the reports I want to build use data from different data sets. Instead of being able to put all of the information I want to see into one report.
Some of our Amazon QuickSight reports only update every 24 hours. It would be great to see that data in real-time.
I would remove the various time zones from Amazon QuickSight and only use the time zone we are in.

Read full review

Megan Sullivan

Marketing Director

LightRx Face & BodyConsumer Services, 201-500 employees

View all 2 answers on this topic

SQL syntax support is not 100% which can lead to frustrating situations when developing a query.
No support for database keys.
No stored procedure support.

Read full review

Brendan McKenna

Senior Developer

American Board of Internal MedicineNon-Profit Organization Management, 201-500 employees

View all 13 answers on this topic

Usability

No score

No answers yet

No answers on this topic

Ask the community to sound off

Amazon Redshift10.0

Based on 1 answer

Just very happy with the product, it fits our needs perfectly. Amazon pioneered the cloud and we have had a positive experience using RedShift. Really cool to be able to see your data housed and to be able to query and perform administrative tasks with ease.

Read full review

Brendan McKenna

Senior Developer

American Board of Internal MedicineNon-Profit Organization Management, 201-500 employees

View all 1 answers on this topic

Alternatives Considered

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

Read full review

Megan Sullivan

Marketing Director

LightRx Face & BodyConsumer Services, 201-500 employees

View all 2 answers on this topic

Prezi is using AWS so Amazon Redshift was the obvious choice. It is fast, scalable and easy to use. Supplemented with Spark and Hive I'm completely satisfied using Redhsift. Sometimes I miss commands I used earlier on MS and Oracle SQL and the lack of procedural features is also negative

Read full review