sample quicksight dashboards

Amazon Quicksight

What is Amazon Quicksight?

If you're looking for a powerful, cloud-based business intelligence service, Amazon QuickSight deserves serious consideration. With this innovative tool, you can easily share insightful data visualizations with your team, no matter where they are. QuickSight connects to your cloud data and seamlessly integrates information from multiple sources - AWS, third-party, big data, spreadsheets, SaaS, B2B, and more. And best of all, it's a fully managed service with enterprise-level security, global availability, and built-in redundancy, so you don't have to worry about any infrastructure.

As a way of visually displaying large amounts of data, QuickSight empowers decision-makers to explore and make sense of data in a user-friendly, interactive environment. Access your dashboards securely from any device, on or off your network. And with user-management tools that scale from 10 to 10,000 users, you can be confident in QuickSight's ability to grow with your business.

The products that compete with Amazon QuickSight include:

  1. Tableau
  2. Microsoft Power BI
  3. SAP Lumira
  4. IBM Cognos Analytics
  5. Oracle BI

Amazon Quicksight advantages

  1. Low TCO with no upfront license costs
  2. Collaborative analytics without software installation
  3. No need to manage granular database permissions with secure data access
  4. Automated and customizable data insights with ML-powered machine learning.
  5. Enterprise security features such as federated users, granular permissions, and secure data encryption.
  6. Additional enterprise features including pay-per-session pricing, embedded console analytics, multitenancy, and larger data import quotas.

How does Amazon Quicksight work?

A diagram of how amazon quicksight works

What kinds of data can be imported into Amazon Quicksight?

Amazon Quicksight can be fed by several different types of datasources:

  1. Relational data sources (databases)
  2. File imports
  3. APIs

Relational data sources

You can use any of the following relational data stores as data sources for Amazon QuickSight:

  • Amazon Athena
  • Amazon Aurora
  • Amazon OpenSearch Service
  • Amazon Redshift
  • Amazon Redshift Spectrum
  • Amazon S3
  • Amazon S3 Analytics
  • Apache Spark 2.0 or later
  • AWS IoT Analytics
  • Databricks (E2 Platform only) on Spark 1.6 or later, up to version 3.0
  • Exasol 7.1.2 or later
  • MariaDB 10.0 or later
  • Microsoft SQL Server 2012 or later
  • MySQL 5.1 or later
  • Oracle 12c or later
  • PostgreSQL 9.3.1 or later
  • Presto 0.167 or later
  • Snowflake
  • Teradata 14.0 or later
  • Timestream

File imports

QuickSight supports files in the following formats which can come from s3 or your local network:

  • CSV and TSV – Comma-delimited and tab-delimited text files
  • ELF and CLF – Extended and common log format files
  • XLSX – Microsoft Excel files
  • JSON – Flat or semistructured data files

More on Amazon Quicksight's support of JSON files

Basic support for JSON flat-file data includes the following:

  • Inferring the schema
  • Determining data types
  • Flattening the data
  • Parsing JSON (JSON embedded objects) from flat files

Support for JSON file structures (.json) includes the following:

  • JSON records with structures
  • JSON records with root elements as arrays

The following JSON features ARE NOT supported:

  • Reading JSON with a structure containing a list of records

  • List attributes and list objects within a JSON record; these are skipped during import

  • Customizing upload or configuration settings

  • parseJSON functions for SQL and analyses

  • Error messaging for invalid JSON

  • Extracting a JSON object from a JSON structure

  • Reading delimited JSON records

APIs

APIs that Amazon Quicksight supports out-of-the-box include the following:

  • Jira
  • ServiceNow
  • Adobe Analytics
  • GitHub
  • Salesforce
  • Twitter

Example Amazon Quicksight Dashboards

 

AWS has created a number of example dashboards to help understand what's possible, organized by industry:

four amazon quicksight dashboards

Each of these dashboards is by no means the limit, but provides a great jumping off point for people curious to know what is possible.

If you'd like to know more about Amazon Quicksight or would like to get a free estimate on your next Amazon Quicksight project, please don't hesitate to reach out.

Date posted: January 29, 2023

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <cpp>, <java>, <php>. The supported tag styles are: <foo>, [foo].
  • Web page addresses and email addresses turn into links automatically.
  • Lines and paragraphs break automatically.

Metal Toad is an Advanced AWS Consulting Partner. Learn more about our AWS Managed Services

About the Author

Joaquin Lippincott, CEO

Joaquin is a 20+ year technology veteran helping to lead businesses in the move to the Cloud. He frequently speaks on panels about the future of tech ranging from IoT and Machine Learning to the latest innovation in the entertainment industry.  He has helped to modernize software for industry leaders like Sony, Daimler, Intel, the Golden Globes, Siemens Wind Power, ABC, NBC, DC Comics, Warner Brothers & the Linux Foundation.

As the CEO and Founder of Metal Toad, an AWS Advanced Consulting Partner, his primary job is to "get the right people in the room".  This one responsibility is cross-functional and includes both external business development functions as well as internal delegation and leadership development.

A UCLA alumni, he also serves in the community as a Board Member for the Los Angeles Area Chamber of Commerce, the Beverly Hills Chamber of Commerce, and Stand for Children Oregon - a public education political advocacy group. As an outspoken advocate for entry-level job creation in tech he helped found the non-profit, P4TH, an organization dedicated to increasing the number of entry-level jobs in the tech industry, and is in the process of organizing an Advisory Board for the Bixel Exchange, a Los Angeles non-profit that provides almost 200 tech internships every year.

 

Schedule a Free Consultation

Speak with our team to understand how Metal Toad can help you drive innovation, growth, and success.