Data Analysis

Kinesis Data Stream

• Store data stream and will be consumed

Kinesis Data Firehose

• load the data stream and store it into s3 etc...

Athena

• Load data from s3

• Perform sql query on the file for business analysis

Redshift

• Based on the postgresSQL

• Easy to integrate visual tool, e.g: AWS QuickSight, Tableau

• Faster query thanks to index

• Is needed to design to pipeline for loading data, e.g: obtain the data from kinesis data firehose

EMR

• Created Hadoop clusters (big data) to analyze and process vast amount of data

• Made of hundred of EC2 instances

• Bundled with Apache Spark

QuickSight

• An interactive dashboard (visual tool) for data analysis

Glue

• Managed extract, transform, load (ETL) service

Lake Formation

• Central place to have all data for analytics purpose

• Fine-grained Access Control for applications (row & column level)