Use Case and Problem
How to build dashboards using Amazon Q in Quick Sight and Gen BI.
Introduction
What is Amazon Quick Sight?
Amazon Quick Sight 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 Quick Sight?
Amazon Q in Quick Sight 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 Quick Sight.
- Download the Netflix dataset from huggingface.co.
Step by step solution
Step 1: Upload the dataset to Amazon Quick Sight.
Go to Amazon Quick Sight, 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 Quick Sight 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 Quick Sight 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 Quick Sight and Gen BI.
Author Bio
Lasantha Sanjeewa Silva is an DevOps Engineer & AWS Community Builder.