Actionable Insights with Amazon QuickSight: Develop stunning data visualizations and machine learning-driven insights with Amazon QuickSight

✍ Scribed by Manos Samatas

• Publisher: Packt Publishing
• Year: 2022
• Tongue: English
• Leaves: 242
• Category: Library

✦ Synopsis

Build interactive dashboards and storytelling reports at scale with the cloud-native BI tool - Amazon QuickSight, including embedded analytics and ML-powered insights

Key Features

• Understand how to set up Amazon QuickSight, manage data sources, and build and share dashboards
• Learn the advanced features of Amazon Quicksight to develop interactive and embedded dashboards
• Manage and monitor dashboards using the QuickSight API and other AWS services such as Amazon CloudTrail

Book Description

The adoption of cloud-native BI tools, like Amazon QuickSight, enables organizations to gather insights from data at scale. This book is a practical guide to performing simple-to-advanced tasks with Amazon QuickSight.

You'll begin by learning QuickSight's fundamental concepts and how to configure data sources. Next, you'll be introduced to the main analysis-building functionality of QuickSight to develop visuals and dashboards. The book will also demonstrate how to develop and share interactive dashboards with parameters and on-screen controls. Advanced filtering options with URL actions will then be covered, before learning how to set up alerts and scheduled reports. Later, you'll explore the Insights visual type in QuickSight using both existing insights and by building custom insights. Further chapters will show you how to add machine learning 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.

What you will learn

• Understand the wider AWS analytics ecosystem and how QuickSight fits within it
• Set up and configure data sources with Amazon QuickSight
• Include custom controls and add interactivity to your BI application using parameters
• Add ML insights such as forecasting, anomaly detection, and narratives
• Explore patterns to automate operations using QuickSight APIs
• Create interactive dashboards and storytelling with Amazon QuickSight
• Design an embedded multi-tenant analytics architecture
• Focus on data permissions and how to manage Amazon QuickSight operations

Who this book is for

This book is for business intelligence (BI) developers and data analysts who are looking to create interactive dashboards using data from Lake House on AWS with Amazon QuickSight. This book will also be useful for anyone who wants to learn Amazon QuickSight in depth using practical examples. You will need to be familiar with general data visualization concepts, however, no prior experience with Amazon QuickSight is required.

Table of Contents

1. Introducing the AWS Analytics Ecosystem
2. Introduction to Amazon QuickSight
3. Preparing Data with Amazon QuickSight
4. Developing Visuals and Dashboards
5. Building Interactive Dashboards
6. Working with ML Capabilities and Insights
7. Understanding Embedded Analytics
8. Understanding the QuickSight API
9. Managing QuickSight Permissions and Usage
10. Multitenancy in Amazon QuickSight

✦ Table of Contents

Cover
Copyright
Contributors
Table of Contents
Preface
Section 1: Introduction to Amazon QuickSight and the AWS Analytics Ecosystem
Chapter 1: Introducing the AWS Analytics Ecosystem
Technical requirements
Discovering the AWS analytics ecosystem
Business intelligence
Data warehousing
Data lake storage and governance
Ad hoc analytics
Extract, transform, load
Exploring the modern data architecture on AWS
Data lakes versus data warehouses
modern data architecture on AWS
Creating a basic modern data architecture
Creating the data lake storage
Summary
Questions
Further reading
Chapter 2: Introduction to Amazon QuickSight
Technical requirements
Introducing Amazon QuickSight
Datasets
Analysis
Visuals and insights
Dashboards
Introducing Amazon QuickSight user types
Introducing QuickSight architecture
Introducing QuickSight editions and user authorization options
QuickSight editions
User authorization with QuickSight
Setting up Amazon QuickSight
Summary
Questions
Further reading
Chapter 3: Preparing Data with Amazon QuickSight
Technical requirements
Adding QuickSight data sources
Supported data sources with QuickSight
Configuring our first data source
Editing datasets
Importing into SPICE
Editing column names and data types
Working with advanced operations
Adding calculated fields
Filtering and joining datasets
Configuring security controls
Summary
Q&A
Further reading
Chapter 4: Developing Visuals and Dashboards
Technical requirements
Working with QuickSight visuals
Creating an analysis
Supported visual types
Publishing dashboards
Customizing the look and feel of the application
Applying themes
Formatting visuals
Summary
Q&A
Further reading
Section 2: Advanced Dashboarding and Insights
Chapter 5: Building Interactive Dashboards
Technical requirements
Using filters and parameters
Working with filters
Working with parameters
Working with actions
Working with filter actions
Working with navigation actions
Working with URL actions
Summary
Q&A
Further reading
Chapter 6: Working with ML Capabilities and Insights
Technical requirements
Using forecasting
Adding forecasting
Working with what-if scenarios
Working with insights
Adding suggested insights
Creating and editing an insight
Working with ML insights
Working with forecasting insights
Working with anomaly detection insights
Summary
Questions
Further reading
Chapter 7: Understanding Embedded Analytics
Technical requirements
Introducing QuickSight embedded analytics
Understanding the business drivers for embedding
Understanding embedded analytics types
Understanding read-only dashboard embedding
Exploring the architecture and user authentication
Overview of the web application layer
Overview of the BI layer
Understanding the authentication layer
Putting everything together
Generating an embedded dashboard URL
Summary
Q&A
Further reading
Section 3: Advanced Topics and Management
Chapter 8: Understanding the QuickSight API
Technical requirements
Introducing the QuickSight API
Accessing the QuickSight API
Controlling resources using the QuickSight API
Setting up a dataset using the CLI
Editing account settings using the QuickSight API
Reusing assets using the template API
Building automation using the QuickSight API
Summary
Questions
Further reading
Chapter 9: Managing QuickSight Permissions and Usage
Technical requirements
Managing QuickSight permissions
Using user groups
Setting up custom permissions
Integrating with Amazon Lake Formation
Managing QuickSight usage
Managing folders
Creating reports and alerts
Working with QuickSight threshold-based alerts
Summary
Questions
Further reading
Chapter 10: Multitenancy in Amazon QuickSight
Technical requirements
Introducing multitenancy using namespaces
Understanding multitenancy
Introducing QuickSight namespaces
Setting up multitenancy
Creating a namespace
Using QuickSight namespaces
Summary
Questions
Further reading
Why subscribe?
Other Books You May Enjoy
Index