To assist with the user experience, we recommended that Filter Null Values are created for the Service and Product Family Services within each Topics Data Configuration
Agent Bill for Amazon Q in Quicksight was built considering the challenge for Row Level Security. Each Role has their Athena Queries, QuickSight Datasets, and QuickSight Topics.
The Dataset are configured with User-based rules leveraging FinOps Center User table for Financial Scope. Users Scope is updated when the Dataset's SPICE is Refreshed.
Users see their Data in Scope of their Users Allocation of Accounts and Financial Budgets configured in FinOps Center.
In image below, FinOps Center users Products on the left are what are reflected in Embedded Amazon Q.
Agent Bill is the embedded Data Assistant to FinOps Center that leverages Amazon Q in QuickSight.
To assist the Quick Sight Topic understand how business weeks are defined, each topics needs to have a Custom Instruction
Customer Instruction
Week are defined by sunday to saturday. the first week of each month starts the 1st of month to saturday 23:59. The last week of the month starts Sunday 00:01 to the last day of that month. Normal weeks are sunday to saturday.
When Forecasting only show the past 2 months and then the forecast for the selected time
Agent Bill leverages Amazon Q in QuickSight's Forecasting Algorithm to provide users expected spending aligned to their Financial Scope.
Agent Bill Embedded Data Assistant is a solution that leverages Amazon Q in QuickSight embedded Q Bar for Registered Users.
Each FinOps Center Users is entered in the FinOps Center Users Pool then added as a QuickSight User with their Role.
User can ask any question around their spending aligned to the Financial Scope.
Users can Pin useful Question and Visuals for Ease of Use
