AWS Business Intelligence Blog

Category: Technical How-to

Unlock the power of unified business intelligence with Google Cloud BigQuery and Amazon QuickSight

Amazon QuickSight is a cloud-native, serverless business intelligence (BI) service that lets you build visualizations, perform ad hoc analysis, and gain insights through machine learning (ML) capabilities such as anomaly detection, forecasting, and natural language querying. QuickSight utilizes its robust in-memory engine SPICE (Super-fast, Parallel, In-memory Calculation Engine) to rapidly perform advanced calculations and deliver visuals.BigQuery is Google Cloud’s fully managed, petabyte-scale, cost-effective analytics data warehouse that lets you run analytics over vast amounts of data in near-real time. In this post, we walk you through the permissions and connection details needed in BigQuery to bring BigQuery data into QuickSight through OAuth and create a simple dashboard.

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

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.

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.

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.

Automate financial statements using Amazon QuickSight Snapshot Export APIs

Financial statements are a set of documents that contain formal records of financial activities of a business at a specific point in time. For example, a profit and loss (P&L) statement summarizes the revenues, expenses, and resulting net profit or loss of a business. It is a snapshot of the organization’s financial performance, starting from […]

Level up your React app with Amazon QuickSight: How to embed your dashboard for anonymous access

Using embedded analytics from Amazon QuickSight can simplify the process of equipping your application with functional visualizations without any complex development. There are multiple ways to embed QuickSight dashboards into application. In this post, we look at how it can be done using React and the Amazon QuickSight Embedding SDK. Dashboard consumers often don’t have […]

Enable complex row-level security in embedded dashboards for non-provisioned users in Amazon QuickSight with OR-based tags

Amazon QuickSight is a fully managed, cloud-native business intelligence (BI) service that makes it easy to connect to your data, create interactive dashboards, and share these with tens of thousands of users, both within QuickSight and embedded in your software as a service (SaaS) applications. QuickSight Enterprise edition started supporting nested conditions within row-level security […]