Lab 8. Use Athena and QuickSight to Analyze Data in S3

Objectives:

• Get familiar with S3 and Athena

• Use QuickSight to visualize data in S3 via Athena

Data:

• Elastic Load Balancing Log, more details: https://docs.aws.amazon.com/elasticloadbalancing/latest/application//load-balancer-access-logs.html#access-log-file-format

• NOAA Global Historical Climatology Network Daily (GHCN-D) data, more details: https://docs.opendata.aws/noaa-ghcn-pds/readme.html

• SQL code: https://github.com/xbwei/data-analysis-aws/blob/master/Athena-code.sql