AWS Business Intelligence Blog

Category: Business Intelligence

Connect Starburst Galaxy with Amazon QuickSight

Starburst is an AWS Data and Analytics Competency Partner with the Amazon Graviton and EC2 Spot Ready product designations. Starburst Galaxy is a fully-managed data platform, powered by Trino, that combines the scalability of a data lake, the functionality of a data warehouse, and the reach of data virtualization in a single platform. Galaxy offers several business intelligence (BI) and visualization tool integrations, including Amazon QuickSight. This post shows you how to connect QuickSight to Starburst Galaxy for powerful visualizations across all your cloud data sources.

Improve pivot table space utilization using the hide collapsed columns and default column width features in Amazon QuickSight

Recently, we launched a range of new features for Tables and Pivot Tables in QuickSight centered around interactivity and performance, allowing you to alter field visibility, load tables faster, and build consistency across different interactions. Building on this momentum, we are excited to unveil two additional capabilities, this time with a focus on improving readability, presentation, and space optimization.

Introducing advanced formatting options for pivot table totals and subtotals in Amazon QuickSight

Readers want to understand data quickly when viewing reports in Amazon QuickSight. To achieve that, authors need more capability to control the format and design of pivot tables. That is why QuickSight has launched more visual display options for pivot tables, giving you more control over the positioning of totals as well as contextual information for subtotals. These capabilities are part of a continued focus of giving QuickSight users more flexibility when designing dashboards and paginated reports. Additionally, the recent launch of the hierarchy layout for pivot tables includes a layout option for pivot tables that uses indentations to differentiate items from different fields, resulting in a more readable table.

Build embedded analytics architectures using Amazon QuickSight

This post helps cloud architects, cloud engineers, and developers build embedded analytics architectures on the AWS Cloud using AWS purpose-built data analytics services and Amazon QuickSight by providing various architectural patterns for building personalized dashboards based on user role or job function. We also discuss best practices and key considerations that showcase the power of embedded analytics, and share additional resources for getting started with building embedded analytics on AWS.

Generative BI dashboard authoring capabilities now available in preview for Amazon QuickSight Q customers

Amazon QuickSight customers can now try generative business intelligence (BI) capabilities in preview to build visuals, build calculations, and refine visuals by using the natural language interface of Amazon QuickSight Q. These new capabilities are the first wave of generative BI capabilities announced at the 2023 AWS New York Summit, and build on the early AI innovation of the natural language query capability of Q, which has enabled business users to ask questions of their data without having to write SQL queries or learn a BI tool since 2020. Generative BI in QuickSight is powered by Amazon Bedrock large language models (LLMs), which securely retain data within the AWS environment.

New enhancements in Amazon QuickSight: Programmatic export to Excel format

Amazon QuickSight is a scalable, serverless, embeddable, machine learning (ML)-powered business intelligence (BI) service built for the cloud. You can now export content to Excel workbooks by selecting multiple tables and pivot table visuals from any sheet of a dashboard on the QuickSight console via schedules or programmatically via a set of new Snapshot Export APIs. This post outlines these new functionalities and guides you through their implementation.

Enhanced table navigation: Freeze/unfreeze Table Columns in Amazon QuickSight

We are excited to introduce the latest feature in Amazon QuickSight that gives authors and readers the ability to freeze columns within tables. This new functionality brings a whole new level of control and convenience for analyzing data in tables. Now, with just a few clicks, you can lock specific columns in place, ensuring that essential information remains visible while scrolling horizontally across wide tables. No more losing sight of critical data points or headers as you explore your tables. This enhancement to the already robust suite of tools in QuickSight aligns with our commitment to delivering a more intuitive and responsive user experience. In this post, we demonstrate how to freeze columns for enhanced table navigation in QuickSight.

Deliver Amazon QuickSight paginated reports to non-QuickSight users

Amazon QuickSight Paginated Reports enables the creation and sharing of highly formatted, personalized reports containing business-critical data to hundreds of thousands of end-users without any infrastructure setup or maintenance, up-front licensing, or long-term commitments. In this post, we will cover how to use QuickSight, a serverless and cloud-native BI service, and Amazon Simple Storage Service (Amazon S3), an object storage service, to generate reports with specific parameters and have these reports delivered to users in a custom application.

Improve power utility operational efficiency using smart sensor data and Amazon QuickSight Part 2: Paginated Report

In the first post, we showed how Amazon QuickSight can be used to improve power utility operational efficiency. Power utility distribution network engineers or operators can visualize smart sensor status in real time and troubleshoot smart sensor issues. In this post, we share with you how to create, schedule, and share highly formatted multi-page reports based on different dashboards.

Empowering Amazon’s solution architects with intuitive and performant business intelligence

The Solution Architect Empowerment Team (SET) is a division within the AWS Worldwide Specialist Organization (WWSO) that serves 1,600 specialist solution architects. SET develops specialized data intelligence tools in collaboration with various internal partners across different departments. These tools help the broader team enhance the customer experience by giving the solution architect leaders and stakeholders faster, more valuable insights to work with. In this blog post, we describe how the SET moved its insights-delivery environment to Amazon QuickSight to reap better cost savings and scalability.