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

  1. 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

  1. In the QuickSight interface, select Manager QuickSight

Visualize with QuickSight

  1. Configure Permission
  • Select Security & permissions
  • Select Manage

Visualize with QuickSight

  1. Select services and select Amazon S3
  • Select S3 Buckets Linked To QuickSight Account
  • Select asg-datalake-demo-bucket
  • Select Finish

Visualize with QuickSight

  1. Select and recheck Roles and services. Then select Save

Visualize with QuickSight

  1. In the QuickSight interface
  • Select Datasets
  • Select New dataset

Visualize with QuickSight

  1. In the Create dataset interface
  • Select source from Athena

Visualize with QuickSight

  1. 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

  1. Performing Table Selection
  • Catalog, select AWSDataCatalog
  • Database, enter summitdb
  • Table, select processed_data
  • Select Select

Visualize with QuickSight

  1. In Finish dataset creation step
  • Select Directly query your data
  • Select Visualize

Visualize with QuickSight

  1. 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

  1. 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

  1. 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

  1. In the upper left panel - Fields list
  • Select artist_name

Visualize with QuickSight

  1. Use the same with other Visual types

Visualize with QuickSight