AWS, Cloud Computing

5 Mins Read

Get Started with QuickSight: AWS Business Intelligence Service

What is QuickSight

AWS is providing its customers a very fast cloud-powered business intelligence service – QuickSight. It enables business users to peer inside the data residing in various AWS repositories, including RedShift Data Warehouse, Elastic MapReduce and Amazon Relational Database Services.

QuickSight makes it easy for customers to build visualizations, perform ad-hoc analysis, and quickly get business insights from data by uploading CSV and Excel files, connect to databases like SQLServer, MySQL or PostgreSQL, in the cloud or on-premises.

Why QuickSight

QuickSight Supported Data sources

QuickSight Features

  1. Choose your Data Source

    We can upload CSV or Excel files data from AWS data sources such as Amazon Redshift, Amazon RDS and Amazon S3 etc. We can also connect to databases like SQL Server, MySQL, and PostgreSQL, in the cloud or on-premises; or connect to SaaS applications like Salesforce.

  2. SPICE – The Super-fast, Parallel, In-memory, Calculation Engine

    Amazon QuickSight’s Super-fast, Parallel, In-memory, Calculation Engine (SPICE) uses a combination of columnar storage, in-memory technologies enabled through the latest hardware innovations, machine code generation, and data compression to allow users to run interactive queries on large datasets and get rapid responses. SPICE supports rich calculations that help customers derive valuable insights from their analysis without ever having to worry about provisioning or managing infrastructure.

  3. Smart Visualizations

    Amazon QuickSight comes with a built-in suggestion engine that provides us with recommended visualizations based on the properties of the underlying datasets. As we drill in to the data, Amazon QuickSight provides the most appropriate graph types to visualize the data using Autograph, a collection of algorithms that learn over time the best visualizations that matches your analytical patterns.

  4. Use Anytime, Anywhere

    The dashboards created from QuickSight can be made easy to access through web browser or the QuickSight iPhone app. Amazon says it will come up with Android app and tablet support, including viewing in offline mode in future releases.

  5. Share and Collaborate

    QuickSight allows us to easily share business insights by packaging them up as interactive stories that we can share with others. Using the Storyboard features in QuickSight, we can combine visualizations into business dashboards and share in a secured manner with individuals or groups in the organization.

Pricing

STANDARD EDITION ENTERPRISE EDITION
First User (USD/user/month) Free (1GB SPICE included) Free (1GB SPICE included)
Additional Users (USD/user/month) $9 (10GB SPICE included)* $18 (10GB SPICE included)*
Additional SPICE(/GB/month) $0.25 $0.38

Team trial:
Free, 60 days, 4 users, Standard or Enterprise Edition.

Connecting MySQL Database with QuickSight

 

 

Summary of my first impression of QuickSight

It seems a pretty good Service. The SPICE data engine is fast, as the response was always instant. The number of data source options available, number of visualizations and storyboard suggestion is good and interactive.

I encountered a few problems while I was playing around. Sometimes charts errored and at times got some errors while connecting MySQL with QuickSight, but at the end of the day it worked. I could easily start using QuickSight, get some great reports with AWS Accounts Billing and dashboards knocked up in very little time.

Give it a try and enjoy 🙂

If you have any query or need more Information about QuickSight, please feel free to write to us at https://forum.cloudthat.com or share your experience, views, etc. in the comments section below.

WRITTEN BY CloudThat

SHARE

Comments

    Click to Comment

Get The Most Out Of Us

Our support doesn't end here. We have monthly newsletters, study guides, practice questions, and more to assist you in upgrading your cloud career. Subscribe to get them all!