Data Lake on AWS > Analysis and visualization > Visualize with QuickSight

Visualize with QuickSight

Visualize with QuickSight

In this step we will visualize using QuickSight.

Sign in to Amazon Quick Sight Console & complete registration. You can see more registrations QuickSight

Go to AWS Management Console

Find QuickSight
Select QuickSight

Visualize with QuickSight

You note the Region used. Check and convert the appropriate Region to avoid errors Visualize with QuickSight

In the QuickSight interface, select Manager QuickSight

Visualize with QuickSight

Configure Permission

Select Security & permissions
Select Manage

Visualize with QuickSight

Select services and select Amazon S3

Select S3 Buckets Linked To QuickSight Account
Select asg-datalake-demo-bucket
Select Finish

Visualize with QuickSight

Select and recheck Roles and services. Then select Save

Visualize with QuickSight

In the QuickSight interface

Select Datasets
Select New dataset

Visualize with QuickSight

In the Create dataset interface

Select source from Athena

Visualize with QuickSight

Configure data source

Data source name, enter summitdemo
Select Validate Connection if the connection is successful, it will show SSL is enabled
Select Create data source

Visualize with QuickSight

Performing Table Selection

Catalog, select AWSDataCatalog
Database, enter summitdb
Table, select processed_data
Select Select

Visualize with QuickSight

In Finish dataset creation step

Select Directly query your data
Select Visualize

Visualize with QuickSight

Use Amazon Quick Sight to visualize transformed data (transform)

Create a Heat map of users and music tracks they listen to over and over again
In the lower left panel - Visual types
Hover your mouse over the icon to see the names of the visualizations
Click on - Heat Map

Visualize with QuickSight

In the upper left panel, in Fields list

Select device_id
Select track_name
Right above the visualization you will see Field wells : Rows - device_id and Columns - track_name (Make sure your Field wells display correctly)

Visualize with QuickSight

Artist’s Tree map is the most listened to

In this step we will create 1 more visualizations showing which artirst is the most popular.
At the bottom left - Visual types
Hover your mouse over the icon to see the names of the visualizations
Select Tree Map

Visualize with QuickSight

In the upper left panel - Fields list

Select artist_name

Visualize with QuickSight

Use the same with other Visual types

Visualize with QuickSight