Visualizing your Data

Using Amazon QuickSight for the first time

1. Go to QuickSight console, click Sign up for QuickSight.

   

2. On the Create your QuickSight account page, specify the following

   • QuickSight account name
   • Notification email address
   • Authentication method

   

3. Choose your exist IAM role

   

4. On the Create your QuickSight account page, click Finish

Connect to a data source

1. On the QuickSight page, click Datasets in the left navigation menu pane.

2. On the upper right section of the screen, click new dataset

3. Select Athena

4. In the New Athena data source window, specify the following:

   • Data source name
   • Athena workgroup – primary
   • Click Create Data Source

   

5. In the Choose your table window, specify the following:

   • Catalog – AwsDataCatalog
   • Database
   • Tables – v_yellow_tripdata

   

6. In the Finish dataset creation window, specify the following:

7. Import to SPICE for quicker analytics

   

Visualize your data

1. QuickSight will attempt to load your data to SPICE, please wait for a few minutes.

2. To visualize the flow of yellow taxi trips from pickup borough to drop-off borough, click + Add in the menu.

3. Select the Sankey visual type, specify the following on the Field wells.

   

   • Source – pu_borough
   • Destination – do_borough
   • You can click on the visual type title, change it to Taxi Trips Flow

   

Filtering Data

1. Create a filter focus on taxi trips originating from Manhattan.

2. Type pu_borough and then select it.

3. Click on the menu besides the pu_borough filter, select Edit.

   

4. Deselect Manhattan from the Filter list, click Apply.

   

5. Get insights by examining the taxi trip flow based on pickup borough and drop-off borough.

6. Observe the traffic flow patterns.