Update Quicksight Dashboards

[ThibaultBC]

Describe the Issue Update AWS Quicksight billing dashboards as needed, following information gathered on PO feedback. Additional Context Add any other context, attachments or screenshots

Acceptance Criteria

• [ ] Pre-requisite: Complete #2779
• [ ] From the feedback list below, assess what can be edited without extra backend requirements
• [ ] List items that are already done.
• [ ] List items that would require further data and backend work, with context (ie. what data needed).
• [ ] List items that can't be delivered as described, with context to why (ie. Not possible in quicksight, data doesn't exist, etc.)
• [ ] Review with Thibault

AWS QuickSight billing – User interview insights

Timeframe: Historic spend (previous 12 months) Current vs previous 3 months spend. Custom period lookup Add drop down to view any period for “invoice spend” & “amortized spend”. Projections/forecast for next 6 months spend.

Types of information to display: Budget Overview of total bill Spend breakdown (add checkbox to view spend per account) All environments Costs and usage By project Types of costs By service Billing details for project/platform services Historic spend by project. Chart format for previous invoices Beginning of fiscal year

Wants: Notes/summery field Ability to export to excel (historic tend) Create comparison report across multiple projects. Ability to export summary. Include OCIO costs and PST/GST A way to filter by environment for all data visualizations at once. Users would like to be able to see currency in CAD instead of USD. Swap term “previous month” with the name of the current month

[abibat-adesina]

Custom dashboard was created from CUDOS dashboard.

[abibat-adesina]

All dashboards created manually have been terminated. Prabhu created new AWS QuickSight dashboard based on AWS documentation using IaC(Terraform) https://github.com/bcgov/terraform-aws-quicksight-billing-dashboard-configuration

[ThibaultBC]

Ticket on hold, won't prioritize until further notice