Advanced Data Visualization in Amazon QuickSight with Highcharts Visual

Introduction

Amazon QuickSight has leaped forward in data visualization by introducing the Highcharts visual, a powerful tool that enables authors to craft custom visualizations with remarkable precision and flexibility. This new feature empowers users to design various chart types, including niche and specialized visualizations, using the Highcharts JSON schema. It is available at no additional cost, making it accessible for users seeking to elevate their data storytelling capabilities. In this blog, we will delve into the Highcharts visual, its features, applications, and how it enhances the Amazon QuickSight experience.

Revolutionizing Data Visuals with Highcharts

The Highcharts visual is an exciting addition to Amazon QuickSight, catering to the growing need for highly customizable and impactful data representations. It offers:

1. Advanced Visualization Options: Create specialized charts like packed bubble charts and lollipop charts.
2. Customization: Achieve granular control over chart elements using the Highcharts JSON schema.
3. Brand Consistency: Design visuals that align with your organization’s branding.
4. Interactivity: Build dynamic dashboards with engaging visual elements.
5. Streamlined Dashboard Development: Create all your visualizations directly within Amazon QuickSight.

Leveraging the Highcharts Core library, this feature combines exceptional flexibility with the intuitive Amazon QuickSight interface. Authors can seamlessly reference Amazon QuickSight fields and formatting through expressions while benefiting from a user-friendly JSON code editor with real-time validation and autocomplete. To ensure security, the editor blocks the injection of external CSS, JavaScript, or HTML code.

Whether transitioning from other BI platforms or building complex dashboards, the Highcharts visual ensures you have the tools to create tailored, data-driven stories that drive better insights and decisions.

Getting Started with Highcharts Visual in Amazon QuickSight

Adding a Highcharts Visual

To begin using Highcharts visual:

1. Open an analysis in Amazon QuickSight.
2. Choose the Add visual icon or select Highcharts visual from the visual type selector.
3. Use the Highcharts JSON schema to configure your visualization.

The following steps demonstrate creating a lipstick column chart to compare measures with a clear visual hierarchy.

Building a Lipstick Column Chart

The lipstick column chart enables precise comparisons between two measures while emphasizing the primary metric. Its compact design is ideal for dashboards with limited space.

Step-by-Step Guide

Step 1: Create a Base Column Chart

1. Add Industry and Current Year Sales fields to your analysis.
2. Configure display settings to set the chart title.
3. Expand the code editor and apply the following JSON code:

This creates a base column chart with industries on the x-axis and sales data on the y-axis.

Step 2: Add Prior Year Sales

To add a second series for comparison:

1. Add Prior Year Sales to the Value field.
2. Modify the series array in the JSON code:

JSON

This step overlaps the columns for a direct comparison.

Step 3: Include Target Sales as a Marker

1. Add Target Sales as a third series.
2. Update the JSON code to include a marker for Target Sales:

JSON

This renders a distinct marker for the target value.

Step 4: Customize the Marker

To change the marker to a triangle:

JSON

Step 5: Apply Conditional Formatting

Use the following JSON code to format the Current Year Sales column conditionally:

JSON

This highlights sales performance against targets and prior year values.

Additional Visualization Examples

Packed Bubble Charts

Packed bubble charts visualize data using the size and color of bubbles. Configure them using the following JSON:

JSON

Bullet Charts

Bullet charts are a space-efficient way to display KPIs alongside targets:

JSON

Advantages and Limitations

The Highcharts visual brings unprecedented customization and flexibility, but it does have limitations:

• Interactivity: Filters and navigation actions are unavailable.
• External Resources: Linking to external GeoJSON or images isn’t supported.
• Ad-Hoc Filters: Not currently supported.

Conclusion

The Highcharts visual transforms Amazon QuickSight into a robust platform for creating tailored, impactful dashboards.

Drop a query if you have any questions regarding Amazon QuickSight and we will get back to you quickly.

About CloudThat