ministryofjustice / analytical-platform

Analytical Platform • This repository is defined and managed in Terraform
https://docs.analytical-platform.service.justice.gov.uk
MIT License
9 stars 4 forks source link

📊 QuickSight Trial Information: People Analytics Team #4997

Open emmwatson opened 1 month ago

emmwatson commented 1 month ago

Use Case Description

People Analytics are interested in exploring QuickSight as alternative to R Shiny apps and Power BI dashboards. We hope to achieve a greater understanding of the pros and cons of Quick Sight and when Quick Sight would be an option over R shiny (which main challenge is the learning curve) and Power BI (which main drawbacks being the need to download data from AP and the limits with functionality) so we are hopeful that Quick Sight might fill that gap

Dataset(s) to Visualise

These are the datasets where someone in the team has admin rights people_survey_prod, corporate_my_learning, oleeo_legacy_staging

but really interested in linking to and visualising data from the sop database tables

Are you an Analytical Platform Admin of the S3 Data Warehouse for the Datasource(s)?

Yes

Audience Details

Other AP users and wider MoJ audience (predominately HR and COO group)

Additional Information

No response

emmwatson commented 1 month ago

Laurence Droy has admin rights to the named databases but we can extend that to other people in our team