Introduction to Amazon QuickSight

Brief Introduction

@Vijay Dadi

11/1/20233 min read

The Amazon QuickSight introduction illustrates the process of building a dashboard and creating basic data visualizations with this cloud-based data visualization tool. Amazon QuickSight is provided as a service with pay-per-session pricing and connects to multiple data sources such as Amazon S3, Aurora, Redshift, Athena, RDS, and more.

The steps to create a dashboard in QuickSight are as follows:

1) Fetching Data from S3 Bucket: Data, like the Loan Status dataset, is stored in an S3 bucket. JSON manifest files are used to import CSV/TSV/JSON files from S3 into Amazon QuickSight. Different formats for JSON manifest files allow users to specify the location and format type of the files, which can be uploaded to a local directory or directly into the S3 bucket.

2) Creating a Dataset in QuickSight Spice Engine for Analytics: Users can create a dataset in the Spice Engine by managing data and uploading the manifest file.

This action automatically imports the dataset (CSV/TSV/XLS/JSON) stored in S3 into the Spice Engine.

After preparation, data can be visualized, enabling users to create charts and dashboards by analyzing the dataset's columns.

3) Dashboard Creation using KPI, Charts, Maps, Metric Boards, and Graphs: Dashboards are a collection of charts and graphs used for visualizing and communicating vital business data to stakeholders and employees. These dashboards track, analyze, and display key performance indicators (KPIs) and metrics to monitor the health of a business. Various methods are employed to create individual charts and graphs, such as adding visuals, calculated fields, filters, parameters, controls, and applying filters.

Visualization Examples: Three visualizations are detailed, showcasing different charts and graphs derived from the Loan Status dataset. They include pie charts, bar graphs, horizontal bar graphs, geo maps, and vertical bar graphs, which represent diverse insights related to loan statuses, loan amounts by purpose, state-wise loan applications, and ownership statuses.

Advanced Features: Amazon QuickSight offers advanced features to enhance charts and graphs, such as creating multiple screens, making charts immune from filters, drill-down capabilities, visual formatting, and color adjustments of charts.

4) Schedule Dashboard Refresh: Users can schedule data refresh for their dashboards to update according to new data on an hourly, daily, weekly, or monthly basis. The management of data sets in the Spice Engine allows for manual or automatic updates based on the selected schedule.

Sharing and Access Management: Dashboards can be shared with multiple users in an account, allowing for access management.

Conclusion: Amazon QuickSight enables the creation of visualizations, analysis, and insights across time-series data. Future blog posts will delve deeper into the tool's additional features for a comprehensive understanding of its capabilities.