Enhancing Data Exploration in Amazon QuickSight with Custom Sheet Tooltips

Introduction to Amazon QuickSight

Amazon QuickSight, the unified business intelligence service from AWS, empowers users with interactive dashboards, machine learning insights, and embedded analytics at scale.

New Feature Announcement: Sheet Tooltips

We are excited to introduce sheet tooltips, allowing dashboard authors to craft customized tooltip layouts that enhance data storytelling and user engagement.

Solution Overview

With sheet tooltips, users can design dynamic, rich tooltip experiences that display contextual information without disrupting the visual they are exploring.

Prerequisites

Ensure you have the necessary setup to start using sheet tooltips effectively in Amazon QuickSight.

Getting Started with Sheet Tooltips

Follow our detailed walkthrough to create and publish engaging sheet tooltips based on your specific data needs.

Step 1: Navigate to the Interactions Tab

Access the tooltip creation settings in your QuickSight analysis.

Step 2: Design and Publish Your Tooltip Sheet

Create a visually appealing tooltip layout using the free-form design tools available.

Use Case: Creating a Sales-Focused Tooltip

Illustrate the capabilities of sheet tooltips through a practical example using sales data.

Supported Visual Types for Sheet Tooltips

Explore the array of visualizations that support sheet tooltips, enhancing data interactivity.

Limitations of Sheet Tooltips

Be aware of the current constraints to ensure optimal use of this powerful feature.

Conclusion

With the new sheet tooltips in Amazon QuickSight, dashboard authors can deliver enhanced data narratives, providing users with deeper insights effortlessly.

About the Authors

Meet the team behind this feature, each bringing extensive expertise in data analytics and software development to Amazon QuickSight.

Enhancing Data Insights with Amazon QuickSight: Introducing Sheet Tooltips

In today’s data-driven world, the ability to extract valuable insights quickly is paramount for businesses. Amazon QuickSight stands at the forefront of this need, offering a comprehensive business intelligence (BI) solution that not only delivers interactive dashboards and pixel-perfect reports but also integrates machine learning insights and embedded analytics. With QuickSight, businesses can work smarter and faster while ensuring robust security and access controls.

Exciting New Feature: Sheet Tooltips

Today, we’re thrilled to announce the launch of sheet tooltips in Amazon QuickSight. This innovative feature allows dashboard authors to create customized tooltip layouts using free-form sheet designs. By combining various visual elements like charts, key performance indicators (KPIs), metrics, and text within a single tooltip, QuickSight enhances the interactive user experience. The best part? Readers can access this rich contextual information simply by hovering over data points, eliminating any need to navigate away from the visuals they’re engaging with.

Solution Overview

With sheet tooltips, the possibilities are vast:

• Custom Designs: Use the free-form sheet editor to craft unique tooltip layouts.
• Multiple Visual Types: Integrate line charts, bar charts, text boxes, and more within a single tooltip.
• Dynamic Data: As users hover over different data points, real-time data displays, updating instantly.
• Contextual Insights: Present supplementary metrics like revenue and units sold in tandem with trend visuals.
• Enhanced Storytelling: Create compelling narratives by surfacing additional insights directly on hover.

This new feature leverages a dedicated tooltip sheet type and supports up to five dynamic visuals, ensuring relevant data is at users’ fingertips.

Prerequisites

Before diving into the development of sheet tooltips, here are a few requirements to ensure a smooth setup:

• An active AWS account with necessary access permissions for Amazon QuickSight.
• QuickSight Enterprise Edition activated in your account.
• Author or Author Pro access to create and manage analyses and dashboards.
• A basic understanding of QuickSight, particularly analyses, dashboards, sheets, and visual types.

Getting Started

To build a sheet tooltip for your QuickSight visuals, follow these straightforward steps:

Step 1: Navigate to the Interactions Tab

1. Log in to the Amazon QuickSight console and select an analysis from the left pane.
2. Click on a visual, such as a bar chart, and choose "Edit visual."
3. In the Properties panel on the right, find the Interactions tab.
4. Select Sheet tooltip under Tooltip configuration, and choose to create a new tooltip.

Step 2: Design and Publish Your Tooltip Sheet

• The new tooltip sheet opens in a free-form layout, providing an empty canvas for your design.
• Drag and design up to five visuals on this canvas, promptly resizing and formatting them as needed.

Once your customization is complete, hover over data points within your visual to see your tooltip in action, updating dynamically based on the point being analyzed. Don’t forget to publish your dashboard to share the insightful tooltips with readers.

Use Case Example: Sales Dashboard

Let’s illustrate the functionality with a quick example. Assume you’re focusing on a sales dashboard:

1. Start by dragging a visual, such as a gauge chart, onto the canvas.
2. Rename your tooltip to "Model Sales."
3. Include visuals like a line chart for monthly sales trends and a table to show model images.
4. Adjust positioning and formatting to efficiently convey sales metrics.

This approach allows for a visually engaging tooltip experience.

Supported Features and Limitations

Sheet tooltips are versatile but come with certain limitations:

Supported Visual Types:

• Gauge, Donut chart, Line chart, Area line chart, Table, Heat map, and more.

Limitations:

• Certain visuals like KPI, Waterfall chart, and custom visuals cannot incorporate sheet tooltips.
• Each tooltip supports up to five visuals and five text boxes.
• Analysis must include at least one interactive sheet type.

Conclusion

The introduction of sheet tooltips in Amazon QuickSight greatly enhances the dashboard authoring experience, empowering authors to create rich, dynamic tooltips that deliver deeper insights effortlessly. By integrating multiple visuals into a single hover interaction, you can transform standard data exploration into a rich narrative experience.

To learn more about sheet tooltips and other exciting features, be sure to visit the Amazon QuickSight What’s New section. We can’t wait to see the innovative tooltip experiences you create!

About the Authors

Meet the talented team behind this feature:

• Meshan Khosla: Software Development Engineer with a knack for tackling technical challenges.
• Neeraj Kumar: Senior Worldwide Solutions Architect guiding businesses in their data-driven journeys.
• Will Tsao: Software Engineer specializing in delivering intuitive user experiences for table and pivot table interactions.
• Ying Wang: Senior Specialist Solutions Architect in Generative AI, focusing on innovative data solutions.
• Roy Yung: Senior Specialist Solutions Architect with over a decade of experience in BI solutions.

With their expertise, Amazon QuickSight continues to evolve, ensuring that businesses can harness the power of data like never before.