Book Image

Effective Business Intelligence with QuickSight

By : Rajesh Nadipalli
Book Image

Effective Business Intelligence with QuickSight

By: Rajesh Nadipalli

Overview of this book

Amazon QuickSight is the next-generation Business Intelligence (BI) cloud service that can help you build interactive visualizations on top of various data sources hosted on Amazon Cloud Infrastructure. QuickSight delivers responsive insights into big data and enables organizations to quickly democratize data visualizations and scale to hundreds of users at a fraction of the cost when compared to traditional BI tools. This book begins with an introduction to Amazon QuickSight, feature differentiators from traditional BI tools, and how it fits in the overall AWS big data ecosystem. With practical examples, you will find tips and techniques to load your data to AWS, prepare it, and finally visualize it using QuickSight. You will learn how to build interactive charts, reports, dashboards, and stories using QuickSight and share with others using just your browser and mobile app. The book also provides a blueprint to build a real-life big data project on top of AWS Data Lake Solution and demonstrates how to build a modern data lake on the cloud with governance, data catalog, and analysis. It reviews the current product shortcomings, features in the roadmap, and how to provide feedback to AWS. Grow your profits, improve your products, and beat your competitors.
Table of Contents (15 chapters)
Effective Business Intelligence with QuickSight
Credits
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

How is QuickSight different to other BI tools?


Amazon QuickSight was built to address pain points of the traditional BI tools and provides IT and business teams with a fast, cloud-powered BI service at one-tenth the cost of traditional BI software.

Here are the key features that make QuickSight the next generation cloud-powered BI tool:

  • QuickSight empowers data analysts to build their reports quickly by pointing them to any data source without the need of a large IT team that traditionally has to build metadata in a BI tool before data analysts can use them.

  • QuickSight pricing starts at $9 per user per month and is a complete managed service, which eliminates the need for software install and maintenance.

  • QuickSight has deep integration within AWS data sources including RDS, DynamoDB, Kinesis, S3, Athena, and Redshift. It also supports user file uploads in Excel, CSV, TSV, and can also connect to Salesforce Cloud and on-premise databases. This list will continue to grow.

  • QuickSight has smart visualizations that infer data type and provide suggestions for best possible visualizations. Additionally, QuickSight also suggests relationships between datasets.

  • QuickSight has easy to use browser-based interface and does not require any desktop software to build metadata and/or reports.

  • QuickSight has a special distributed and intelligent caching layer that provides blazing fast performance and response times.

  • QuickSight allows users to share analysis, read only dashboards, and story board with peers.

  • QuickSight has planned integration with a number of partner BI tools like Tibco, Domo, and Qlikview so that enterprises can leverage current investment, but still benefit from the caching and deep connectivity that QuickSight provides.

The following diagram shows the simplified flow from data to visuals using QuickSight:

Figure 1.3: QuickSight simplified process

It has the following four steps, most of which can be done by a power user without the need for personal IT:

  1. Source data from various sources including files, RDBMS on the AWS data platform.

  2. Import data to QuickSight caching layer (SPICE).

  3. Prepare/edit data if required for analysis.

  4. Visualize and publish to dashboards.