Amazon Athena vs. Amazon QuickSight vs. Looker

Best suited for analyzing huge amounts of data by just querying on Amazon Athena. Amazon Athena is also best to integrate with Amazon Quickight for visualization and reporting of data. Easy to work with CSV, JSON, and columnar data formats like Parquet, and ORC. Less appropriate to work with AVRO data format and also stored procedures are not supported in Amazon Athena. The size of a single row is also limited to 32 MB.

Incentivized

I'm likely to recommend it because it would become so native if other cloud services are based on AWS infrastructure, like our current setup. It is very seamlessly integrated with other services to feed in data for the visualization. In addition, supporting a reasonably large number of users concurrently is not an issue and should be able to scale horizontally as needed.

Incentivized

When data drives potential for new orders, Looker earns its place in our tech stack. If, on the other hand, we are hoping for pipeline generation, Looker is useful if you are willing to repeatedly go check customer utilizations .... it is not appropriate if you are hoping to automate data analysis for this purpose.

Incentivized

• Load Balance traffic analysis
• Big data report generation
• Micro services pattern query analysis

Incentivized

• Lightweight and serverless BI tool that can be used for niche dashboards.
• Its integration into other AWS Services is one of its most appealing features.
• The low monthly cost is another benefit.

Incentivized

• It is very easy to start a new dashboard and configure what you want to display by just selecting/dragging from the list of available columns.
• It is intuitive, mainly if you use other Google services like Google Sheets.
• The look and feel is modern and nice.
• It it very useful to have an immediate visual overview of the data in a spreadsheet.

Incentivized

• Every dialect of SQL has some missing functions. I wish there was automated GROUP BY options here.
• There are connection problems back to Power BI occasionally.
• If you don't watch certain queries, it's possible that it takes a long time to run and charges you a lot of money.

Incentivized

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

Incentivized

• I wish I could get more granular in the Google ad data, such as down to the campaign type, instead of having to see only all campaigns.
• The setup can be time-consuming if you're not using the product regularly.
• Editing the dashboard requires a few logins; I wish it was more seamless.

Incentivized

We are very haooy with Looker, it provides us with all the funciomalities we need for both the day to day oerformance tracking and longer periods reporting. It is easy to use for account managers, configurable and customizable for soecialists and what is most imoortant, our clinets generally really love it

Incentivized

Easy to use. Scalable. Gets the job of data warehousing setup done. Using the datalake on S3 has become super convenient.

Incentivized

It is easy to use and set up no need to put in so much effort. Once build, the dashboard can be used with multiple clients with the same domain. It provides multiple connectivity options which makes it a versatile option for reporting.

Incentivized

Looker is relatively easy to use, even as it is set up. The customers for the front-end only have issues with the initial setup for looker ml creations. Other "looks" are relatively easy to set up, depending on the ETL and the data which is coming into Looker on a regular basis.

Incentivized

No objections

Incentivized

Somehow resources heavy, both on server and client. I recommned at least 50Mbs data rate and high performance desktop comouter to be abke to run comolex tasks and configure larger amount of data. On the other hand, the client does not need to worry when viewing, the performance is usually ok

Incentivized

They provide proper support when needed. They are always ready to provide the box solution and make things easier for users.

Incentivized

Never had to work with support for issues. Any questions we had, they would respond promptly and clearly. The one-time setup was easy, by reading documentation. If the feature is not supported, they will add a feature request. In this case, LDAP support was requested over OKTA. They are looking into it.

Incentivized

Very satisfied, easy to implement

Incentivized

Amazon Athena, a product from Amazon, competes with offerings from Google and Microsoft. Overall, I think your database choice depends on some of the other applications you are running at your company. For example, if you are using Microsoft Power BI for reporting needs, you might want to consider going the Azure route.

Incentivized

As per our requirement, the Amazon Eco System leads us to use the Amazon Quick Sight platform. It works well with Redshift datasources.

Incentivized

In my opinion, Looker is no Power BI. It is good, but I think Power BI is amazing. That said, in my experience, Power BI is nowhere near as easy to setup and report on Google services as Looker is. We plan to continue using Power BI for c-suite and corporate reporting, especially for internal databases, but will gladly use Looker for our marketing information for AdWords, Analytics, Search Console, and YouTube.

Incentivized

• It's easy to store and query data on S3. Multiple teams can query the same data to generate their reports. It removes the need for a full-fledged data warehouse for a startup. Saves costs.
• Improved team efficiency on monitoring user activities by easy logging and reporting.
• As the dataset gets heavier on S3, one needs to understand partitioning and that leads to the requirement of expertise.

Incentivized

• Cost Effective
• Easy setup and maintenance

Incentivized

• Other than some people not liking the numbers, I don't see any negative impacts; we haven't experienced that.
• The reports help us unravel the story of our users and how they are sifting through our pages.
• Our clients enjoy seeing the numbers to understand better what stands out on their sites.
• The reports have helped us see what campaigns are working and where we need to tweak things.
• The reports have enabled us to have better conversations with stakeholders about how their web pages should be modified, edited, etc., to reflect the data.

Incentivized