Administration and BIOps Solutions of QS

Learning Center Articles
1

Below is a summary of the key topics Administration and BIOps Solutions of QuickSight, including four main areas:

  1. QuickSight asset and user management – Who creates, owns, or has viewer permissions for an asset? (Assets include dashboards, datasets, etc.) If a user changes roles or leaves the company, QuickSight should provide a way for the BI team to update user roles, transfer asset ownership, and manage related changes.
  2. Usage metrics for QuickSight assets – For example, tracking how many times a dashboard has been viewed in the last 30 days.
  3. Data dictionary – Understanding relationships between assets, such as which datasets are being consumed by a specific dashboard. The size of SPICE datasets, and so on.
  4. BIOps – The ability to build a CI/CD pipeline to migrate QuickSight assets from one account to another, such as deploying assets to a production account.

For topics 1 and 2, QuickSight does not provide an out-of-the-box solution in the UI. However, using the API, we can build a solution to achieve these capabilities.
Here are the resources:

For editing access permissions, refer to:

For topic 3 (Data Dictionary), you can use the Admin Console solution to obtain most of the data dictionary insights. If you’re looking for SPICE size analysis, a QuickSight SA built a solution:

For topic 4 (BIOps & CI/CD for QuickSight), you have 3 different options:

  1. QuickSight also provides an API called Assets as Bundles, which allows you to batch export and import assets efficiently. Documentation: Assets as Bundles API This API can help streamline the migration and deployment of QuickSight assets across environments. This blog provided the solution to trigger CICD with EventBridge rules: Automate your Amazon QuickSight assets deployment using the new Amazon EventBridge integration | AWS Business Intelligence Blog
  2. Customized solutions by using describe and create assets APIs: Blog: BIOps: Amazon QuickSight Object Migration and Version Control and the YouTube video: BIOps for QuickSight
  3. You can also refer to this workshop to learn more about the QuickSight API in detail: Amazon QuickSight Admin Workshop – Content Porting This workshop provides hands-on guidance on using the API for migrating QuickSight assets.