Question

A retail analytics team needs to give non-technical business users self-service dashboards that visualize weekly sales trends stored in a Parquet dataset in Amazon S3. The users must be able to filter and drill down into charts without writing SQL, and dashboards should refresh nightly. The data engineering team wants the lowest operational overhead. Which approach best meets these requirements?

Accepted Answer

Use Amazon QuickSight with a SPICE dataset backed by an Athena query over the S3 Parquet data, and schedule a nightly SPICE refresh.

Answer

Provision a Redshift cluster, load the Parquet data with COPY, and give business users SQL query editor access.

Answer

Grant business users access to the Athena console so they can run queries and view results directly in the query results pane.

Answer

Build a custom web application on EC2 that runs Athena queries and renders charts using an open-source visualization library.