Amazon QuickSight vs Amazon Redshift

Likelihood to Recommend

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

Very well suited for aggregating/denormalizing data when you need a reporting environment. Can provide extremely fast querying for analytical purposes. Very nice to not have to have in house responsibility for sensitive data.Not appropriate for a transactional system (though this is not what it is built for obviously). Must keep in mind the data you are syncing up to the cloud and scrub if necessary before. Something to always be mindful of of course.

Read full review

Brendan McKenna

Senior Developer

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

View all 20 answers on this topic

Feature Rating Comparison

Amazon QuickSight

8.2

Amazon Redshift

—

Pixel Perfect reports

10.0

—

Customizable dashboards

7.5

—

Report Formatting Templates

7.2

—

Amazon QuickSight

7.5

Amazon Redshift

—

Drill-down analysis

8.0

—

Formatting capabilities

7.0

—

Report sharing and collaboration

7.5

—

Amazon QuickSight

5.5

Amazon Redshift

—

Report Versioning

8.0

—

Report Delivery Scheduling

3.0

—

Amazon QuickSight

8.6

Amazon Redshift

—

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

7.2

—

Location Analytics / Geographic Visualization

10.0

—

Amazon QuickSight

7.0

Amazon Redshift

—

Multi-User Support (named login)

8.5

—

Role-Based Security Model

7.7

—

Multiple Access Permission Levels (Create, Read, Delete)

7.7

—

Single Sign-On (SSO)

4.0

—

Amazon QuickSight

9.6

Amazon Redshift

—

Responsive Design for Web Access

10.0

—

Dashboard / Report / Visualization Interactivity on Mobile

9.3

—

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 20 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 20 answers on this topic

Usability

No score

No answers yet

No answers on this topic

Ask the community to sound off

Amazon Redshift 8.6

Based on 8 answers

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 8 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

Some organizations use PostgreSQL as an OLAP store. PostgreSQL offers a modern SQL dialect, data types, and features that Redshift lacks. RDS is a great managed PostgreSQL product. However, PostgreSQL is a poor choice for a data warehouse. It's row-oriented storage requires careful schema and index design to ensure analytical queries perform adequately.

Read full review

Gavin Hackeling

Data Scientist

Wonder (AskWonder.com)Research, 11-50 employees

View all 20 answers on this topic

Return on Investment

No answers on this topic

Ask the community to sound off

Realtime and high availability, add quick access of the data.
Improve decision support based on quick data analytics.
Costlier compared to others, but we can generate ROI within a year, based on large scale applications.

Read full review

Verified User

Employee in Research & Development

Computer Software Company, 501-1000 employees

View all 20 answers on this topic

Likelihood to Recommend