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

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

- In the QuickSight interface, select Manager QuickSight

- Configure Permission
- Select Security & permissions
- Select Manage

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

- Select and recheck Roles and services. Then select Save

- In the QuickSight interface
- Select Datasets
- Select New dataset

- In the Create dataset interface
- Select source from Athena

- 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

- Performing Table Selection
- Catalog, select AWSDataCatalog
- Database, enter
summitdb
- Table, select processed_data
- Select Select

- In Finish dataset creation step
- Select Directly query your data
- Select Visualize

- 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

- 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)

- 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

- In the upper left panel - Fields list

- Use the same with other Visual types
