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

Supported data sizes


Amazon QuickSight uses SPICE in-memory caching and hence there are some limits to data from files and tables. You can see the amount of SPICE you are using by clicking on Manage data in the top-right corner. Now let's look at the file and table limits in detail.

File limits

Any single file uploaded to QuickSight directly or from S3 must be 1 GB or less. If multiple files are imported from S3, the total size of files specified in the manifest file must be less than 5 GB and the total number of files should not exceed 100. The number of columns in a file should not exceed 200 and the number of characters per row should be less than 25,400.

Table limits

Any table or query result set imported into SPICE must be less than 10 GB. If you are dealing with tables with larger datasets, use filters to reduce the number of records to analyze. Data in any string column must be 511 characters or less.