3_AmazonQuickSight

Visualize data using Amazon QuickSight

Time to complete: 15-30 minutes.

Step 1: Signup for Amazon QuickSight settings

1. Navigate to Amazon QuickSight in the console

2. Signup for QuickSight

1. Select “Enterprise” edition

1. Provide Amazon QuickSight account name and a notification email address

2. Choose S3 location, and pick the <mod-...-simplebucket-...> bucket

Note*: You can ignore the IAM warnings from QuickSight

Step 2: Amazon QuickSight dataset configuration

1. Navigate back to the QuickSight landing page in the console

2. Click on Manage data button on the top right corner

1. Click on New data set

1. Click Athena and in Data source name type “bbg”

1. Click on Validate connection to verify

2. Click on Create data source , choose marketdata database and bbg table

3. Select Custom SQL and use the following query

select * from "marketdata"."bbg" where ticker is not null

![QuickSight CustomSQL](assets/QSCustomSQL.png)

1. Click on Confirm Query

2. Select Directly query your data option and Click on Visualize

Step 3: Visualize raw data in Amazon QuickSight

1. Continue on the Visualization from previous step Note: If navigated out, go back to QuickSight dashboard and choose "New custom SQL analysis" that was created recently.

2. Select Line Chart from the Visual types in the bottom left corner

1. Choose settle_dt for X axis, px_volume for value, and choose security_typ for color

Note: Click on down arrow next to settle_dt in the chart and change format without the commas

1. Similarly try Bar Charts, Pivot Tables to visualize the data.

Next step:

We're ready to do complex analytics and periodic reporting using Amazon Redshift.