[Task]: Delivery Dashboard discovery - deploy AWS Quicksight

[coilysiren]

Summary

We want to evaluate using AWS QuickSight as a BI tool for both internal and external facing dashboards.

Data to test with: issue-pr-data.zip

Steps

1. Create an instance of QuickSight in our dev environment
2. Notify the #topic-security channel that this may be flagged in our scanning
3. Upload the attached CSV files
4. Create a sprint burndown chart (see analytitcs folder for query details)
5. Create a chart for 30k planning (see analytitcs folder for query details)
6. Add charts to dashboard and share publicly (or whatever combo of features this entails in QuickSight)
7. Share dashboard and demo tool if requested
8. Destroy instance

Acceptance criteria

• Instance created
• Dashboard (or equivalent created and shared)
• Instance destroyed (if we don't use it permanently)

[acouch]

I created a Quicksight account and uploaded the attached datasets

[acouch]

Quicksight doesn't let you create custom SQL queries unless you are using a database, so I didn't follow through on creating the same dashboards as metabase. It is a pretty frustrating UI to handle and harder to create bespoke dashboards compared to metabase, but would allow us to create and share bespoke dashboards, create public and private dashboards, and easily connect to data hosted in AWS.