Amazon Athena is an interactive query service that makes it easy to analyze data directly in Amazon S3 using standard SQL. With a few clicks in the AWS Management Console, customers can point Athena at their data stored in S3 and begin using standard SQL to run ad-hoc queries and get results in seconds. Athena is serverless, so there is no infrastructure to setup or manage, and customers pay only for the queries they run. You can use Athena to process logs, perform ad-hoc analysis, and run…
Amazon Redshift and EMR require explicit configuration for underlying compute infrastructure. In Amazon Athena, Users don't have to set up any underlying infrastructure. It saves a lot of costs required for infrastructure. Users have to pay only for scanned data. Athena is good …
If you are looking to take a lot of the traditional "database administration" work off someone's plate, going with Amazon Athena certainly has "no code" options to optimize lots of database tasks. I would say this option is less appropriate if you have other Microsoft things at play, such as Power BI.
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
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.
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