Amazon QuickSight is an Amazon Web Services utility that allows a company to create and analyze visualizations of its customers' data. The business intelligence service uses AWS' Super-fast, Parallel, In-memory Calculation Engine (SPICE) to quickly perform data calculations and create graphs.
Amazon QuickSight reads data from AWS storage services to provide ad-hoc exploration and analysis in minutes. Amazon QuickSight collects and formats data, moves it to SPICE and visualizes it. By quickly visualizing data, QuickSight removes the need for AWS customers to perform manual Extract, Transform, and Load operations.
Amazon QuickSight pulls and reads data from Amazon Aurora, Amazon Redshift, Amazon Relational Database Service, Amazon Simple Storage Service (S3), Amazon DynamoDB, Amazon Elastic MapReduce and Amazon Kinesis. The service also integrates with on-premises databases, file uploads and API-based data sources, such as Salesforce. QuickSight allows an end user to upload incremental data in a file or an S3 bucket. The service can also transform unstructured data using a Prepare Data option.
An AWS user can select the data fields to be analyzed and then either drag it onto the visual canvas or allow QuickSight to determine the appropriate visualization based on the selection using its AutoGraph feature. A user can create a dashboard, which includes visualizations, tables and other data displays.
QuickSight's StoryBoard feature allows a data analyst to share specific views of data so as to express opinions or evaluations of it. A data analyst can capture and annotate points in the data for other team members to view or print.
SPICE uses columnar storage, in-memory technology, machine code and data compression to run queries on data sets. The engine also replicates data for high availability and allows QuickSight to scale to thousands of active users. An admin can manage user and group access from the QuickSight console. The service also integrates with Active Directory. QuickSight also offers an app for iOS and Android devices.