Book Image

Actionable Insights with Amazon QuickSight

By : Manos Samatas
Book Image

Actionable Insights with Amazon QuickSight

By: Manos Samatas

Overview of this book

Amazon Quicksight is an exciting new visualization that rivals PowerBI and Tableau, bringing several exciting features to the table – but sadly, there aren’t many resources out there that can help you learn the ropes. This book seeks to remedy that with the help of an AWS-certified expert who will help you leverage its full capabilities. After learning QuickSight’s fundamental concepts and how to configure data sources, you’ll be introduced to the main analysis-building functionality of QuickSight to develop visuals and dashboards, and explore how to develop and share interactive dashboards with parameters and on-screen controls. You’ll dive into advanced filtering options with URL actions before learning how to set up alerts and scheduled reports. Next, you’ll familiarize yourself with the types of insights before getting to grips with adding ML insights such as forecasting capabilities, analyzing time series data, adding narratives, and outlier detection to your dashboards. You’ll also explore patterns to automate operations and look closer into the API actions that allow us to control settings. Finally, you’ll learn advanced topics such as embedded dashboards and multitenancy. By the end of this book, you’ll be well-versed with QuickSight’s BI and analytics functionalities that will help you create BI apps with ML capabilities.
Table of Contents (15 chapters)
Section 1: Introduction to Amazon QuickSight and the AWS Analytics Ecosystem
Section 2: Advanced Dashboarding and Insights
Section 3: Advanced Topics and Management

Adding QuickSight data sources

In this section, we will learn how to add and configure data sources with Amazon QuickSight. QuickSight supports a number of data sources. We will begin by listing the supported data sources.

Supported data sources with QuickSight

Let's look at the different types of data sources that can be configured in Amazon QuickSight. A very common scenario for BI tools is to drive the visualizations from an analytical database or a data warehouse. Specifically, QuickSight supports the following data warehouses:

  • Redshift with autodiscover
  • Redshift manual connect
  • Snowflake
  • Teradata


    A use case for Redshift manual connect is when QuickSight and the Redshift cluster are in different AWS Regions.

Other relational database systems that are supported include the following:

  • RDS
  • MySQL
  • PostgreSQL
  • Oracle
  • Amazon Aurora
  • MariaDB

QuickSight also supports the following:

  • Amazon Timestream
  • Amazon...