AWS Business Intelligence Blog

Category: Advanced (300)

Best practices for Amazon QuickSight SPICE and direct query mode

In QuickSight, data is queried from datasets when visuals load within analyses, dashboards, reports, exports, in responses to questions asked in natural language to Amazon Q, or when threshold alerts are being evaluated. Direct queries are sent to the underlying data source every time a request is made. Using SPICE, a refreshable snapshot of the data is cached in QuickSight, and all queries are fulfilled using the latest snapshot in SPICE, no longer connecting to the underlying data source. In this post, we will explore the benefits and factors to consider when using SPICE and direct query mode. Afterwards, we will also discuss when and how to use which query mode most efficiently in different scenarios.

Streamline your reporting process with Amazon QuickSight automation

Amazon QuickSight stands at the forefront of AWS business intelligence (BI) and data visualization offerings, enabling organizations to create and share interactive dashboards, perform one-time analyses, and glean actionable insights from their data. In today’s data-centric business environment, the ability to efficiently generate and distribute insightful reports across different segments or regions remains a critical challenge for many business. Addressing this challenge, we delve into the automation of report processing workflows. For our use case, a real estate customer wants to send state-specific weekly real estate reports for each state to their regional agents. In this post, we show you how to use QuickSight, combined with its Snapshot APIs and other AWS services, to automate this process.

Use Amazon QuickSight level-aware calculations to analyze COVID-19 datasets

You can use the advanced functionalities in Amazon QuickSight to analyze data at different dimensions and get granular, actionable insights from your data. QuickSight also enables you to achieve this without having to worry about the complexity with data preparation. With QuickSight level-aware calculations (LAC), users including business analysts, data scientists, and decision-makers can dynamically […]

Support multi-tenant applications for SaaS environments using Amazon QuickSight

This post provides guidance on deploying QuickSight in a multi-tenant environment, and the considerations around data isolation and deploying resources to tenants in a QuickSight application. Multi-tenancy within applications provides a mechanism to segment groups of users from one another. These groups could be users from different companies, different geographic regions, or different lines of business within an enterprise. Users within different tenants can’t see other users, data, and assets, while reducing the complexity of having a different infrastructure for each set of users.

Automate failed dataset ingestions using Amazon QuickSight

In this post, we show how to use AWS CloudFormation to deploy all the necessary resources to automate the retry of the ingestion of a failed dataset refresh. This can help speed up the time to have the data available to the users by either completing the refresh successfully or providing more information on the cause of the failure to the dataset owner. Additionally, QuickSight assets can be monitored using Amazon CloudWatch metrics. QuickSight developers and administrators can use these metrics to observe and respond to the availability and performance of their QuickSight ecosystem in near-real time.

Choosing between the two export options of the Amazon QuickSight asset deployment APIs

Are you looking to deploy and manage your Amazon QuickSight assets using the QuickSight asset deployment APIs (also known as asset bundle APIs)? If so, you have two options for exporting your assets: QUICKSIGHT_JSON or CLOUDFORMATION_JSON format. In this post, we explore the pros and cons of each option to help you make the right choice for your organization’s asset needs. We also provide an overview of the API deployment options and some practical guidance on how to use the AWS CloudFormation format. So if you’re ready to learn more about the QuickSight deployment APIs and discover which export option is best for your needs, then let’s get started!

Build custom and interactive dashboards using new runtime capabilities in QuickSight Embedding SDK

Amazon QuickSight is a fully managed, cloud-native business intelligence (BI) service that you can use to connect to your data and create interactive dashboards that can be shared with tens of thousands of users. The dashboards can be used within QuickSight or embedded in software as a service (SaaS) apps. Today, we’re launching a feature you can use to dynamically update the theme and filters of embedded dashboards and visuals at runtime through the QuickSight Embedding SDK. Runtime filtering and theming of embedded dashboards and visuals can help you seamlessly integrate your SaaS application with QuickSight embedded dashboards and visuals. You can now use the new methods available in the Embedding SDK

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.

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.

Build a seamless interaction between your application and embedded Amazon QuickSight dashboards and visuals using embedded callback actions

Amazon QuickSight is a fully managed, cloud-native business intelligence (BI) service that makes it straightforward to connect to your data, create interactive dashboards, and share these with tens of thousands of users, either within the QuickSight interface or embedded in software as a service (SaaS) applications or web portals. With QuickSight providing insights to power daily decisions across the organization, end-users expect actionable insights that can flow seamlessly into their daily workflow in their application of choice. This allows you to make data-driven decisions and take action on these decisions without context switching between multiple platforms. With this release, customers embedding QuickSight dashboards or visuals can now use new capabilities in the Embedding SDK to unlock use cases for end readers.