Article

Amazon QuickSight Dashboard: How to Create it from Scratch

By: Manuel Angel Acosta Mireles, Cloud Engineer at IO Connect Services

January 10, 2022

What is Amazon Quicksight?

Amazon QuickSight is a scalable, serverless, embeddable, Machine Learning-powered BI service for the Cloud that makes it easy to build visualizations, perform ad-hoc analysis, and quickly get business insights from your data.

Amazon QuickSight connects to your data in the Cloud and combines data from many different sources.

We can perform advanced analytics and create visualizations that help us display business information from our data by using this cloud-based service.

 

Benefits of using Amazon QuickSight Dashboard

  • Easy to use: Log in, connect to a data source, and start creating smart visualizations in minutes.
  • Global access: Access your graphics from any web browser or IOS and Android device.
  • Support multiple data sources: Connect to numerous third-party data sources, and use other AWS services as a data source.

 

Amazon QuickSight Tutorial

1. Create a Dataset in the Amazon QuickSight Dashboard

We will start by creating a dataset in Amazon QuickSight. You will see a list of supported Amazon QuickSight data sources to connect to. For this use case, we use an excel file containing information about vaccination by COVID-19 in the United States as a data source.

 

Before creating our dataset, we must edit the necessary settings, prepare the data, and format it according to our needs. This is very useful if we want to exclude fields, edit descriptions, change data types, or add calculations.

Once the data is prepared, we can save the changes, and a new sheet will be created immediately within our analysis.

 

2. Customize the Analysis in the Amazon QuickSight Dashboard

Once our data source is created, we will proceed to work with our analysis. Our first visual indicator, a Key Performance Indicator (KPI), can be found in the "Visual types" section.

Add the values to compare and include them in the "Fields well" section. Compare the target value "people_vaccinated" and the value "people_fully_vaccinated" to obtain the total percentage of vaccinated people compared to fully vaccinated people.

 

  • Add a filter to the dataset by location

Now we are going to add the filter for the location field. For this, we must select the visualization on which the generated filters will be applied. We can customize it as needed. The customization options will vary depending on the type of data we add to the filter.  Also, in this section, we can change the visualizations this filter should apply to. We will add it to the sheet so we can see it in the dashboard.

  • Filter the dataset by date

To add this filter, we will repeat the same steps as before. We can add and customize as many filters as we consider necessary for our information and apply them to one or all the visualizations that we deem necessary.

With our filters already created, we can move the additional filters to any location on the sheet. Now we can filter the information based on the location and a range of dates.

  • Create a line chart

We will create a line chart for the following visualization to plot the number of people vaccinated vs. the number of people fully vaccinated by date. In the types of visualizations, we choose the one that corresponds to the line chart, and we add the "date" attribute on the x-axis and the values ​​that we want to compare.

  • Create a filled map

Next, we will create a complete map to plot the number of people fully vaccinated by location.

In the types of visualizations, we choose the one that corresponds to the filled map. We create "Conditional Formatting" to change the colors of the locations according to the custom conditions we require.

 

3. Changing the Look & Feel of the Amazon QuickSight Dashboard

We can modify the standard colors and the style of the analysis using the "Themes" menu. These themes are customizable, and you can save them for later use. Each of the widgets can also be customized, changing titles, fonts, and more.

 

4. Publishing your Amazon QuickSight Dashboard

To publish your dashboard, select the option "Share" and choose "Publish Dashboard".

After doing this, you'll be prompted to share your dashboard with other users, groups, or email addresses.

 

Amazon QuickSight Review

In this article, we demonstrate how to create an Amazon QuickSight Dashboard from scratch. The visualizations are quick and easy to set up and extremely useful for analyzing the data from any device since they can be embedded seamlessly in your applications, portals, and websites. Amazon QuickSight is the first BI service with pay-per-session pricing. Organizations only pay when their users access dashboards or reports. This makes it very cost-effective for large-scale deployments.

 

How can we help you?

IO Connect Services is here to help you by offering cost-effective, high quality technology solutions.