Building Dashboards using Amazon Q in QuickSight and Gen BI


Use Case and Problem
How to build dashboards using Amazon Q in QuickSight and Gen BI.

Introduction
What is Amazon QuickSight?
Amazon QuickSight is a cloud-powered business intelligence (BI) service provided by Amazon Web Services (AWS). It allows users to create and share interactive dashboards, visualizations, and reports from a variety of data sources, including AWS data, on-premises databases, Excel files, and more.

What is Q in QuickSight?
Amazon Q in QuickSight enhances business productivity using Generative BI (Gen BI) capabilities to accelerate decision-making. With new dashboard authoring capabilities in Amazon Q, business analysts can use natural language prompts to build, discover, and share meaningful insights in seconds.

How to Solve the Problem

Prerequisites

  • AWS Account with necessary permissions to create and access the required services.
  • Ex: Amazon QuickSight.
  • Download the Netflix dataset from huggingface.co.

Step by step solution

Step 1: Upload the dataset to Amazon QuickSight.
Go to Amazon QuickSight, click the datasets tab, click New Dataset, and upload the Netflix dataset.

Step 2: Create an analysis.

  • Go to the Analysis page in the Amazon QuickSight interface.
  • Drag fields from your dataset to the appropriate field wells for the visual type (e.g., X-axis, Y-axis, color, etc.).

Step 3: Assign Permissions

  • After enabling Amazon Q, you’ll need to assign permissions to users who will be using this feature. Go to the Users section under the Admin panel.
  • Select the users you want to grant access to Q and assign them to Author Pro role.

Step 4: Create and Manage Topics

  • Amazon Q uses “topics” to understand your data and provide relevant insights. You’ll need to create and configure these topics.
  • Go to the Topics section and click on Create Topic.
    Example: Select the datasets you want to include in the topic. You can also configure metadata and synonyms to help Amazon Q understand the data better.

Step 5: Train and Customize

  • Amazon Q will analyze your data and quickly generate the relevant visualizations and insights. You can then drag and drop these elements onto your dashboard canvas to build out the final layout.
  • You can also customize the responses and appearance of Q to align with your organization’s needs.
  • Continue exploring different natural language prompts to uncover more insights and add them to your dashboard. You can also customize the visualizations further by adjusting the fields, filters, and formatting.

Step 6: Publish and Share

  • Once setup is complete, you can publish the dashboard for use. Users can now start asking questions using natural language in the QuickSight interface.
  • Share the necessary documentation and guidelines with users to help them understand how to use Amazon Q effectively.

Code sample: Git Repository - GitHub - sanju2/gen-bi-quicksight: Building Dashboards using Q in QuickSight and Gen BI

Conclusion
That’s it! You now have a step-by-step guide on how to build Dashboards using Amazon Q in QuickSight and Gen BI.

Author Bio

lasantha-silva-low-qu
Lasantha Sanjeewa Silva is an DevOps Engineer & AWS Community Builder.