# Data Analysis

## Kinesis Data Stream

![](https://1374779285-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MFW3x2aqEO8GF2kr3VU%2Fuploads%2FTr7vAYQ3OES6dk1ZpBsO%2Fscreenshot-www.udemy.com-2023.08.15-01_43_09.png?alt=media\&token=1365d047-8b54-496c-a5c7-96a6e76821ed)

* Store data stream and will be consumed

## Kinesis Data Firehose

![](https://1374779285-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MFW3x2aqEO8GF2kr3VU%2Fuploads%2FWkAEcNd8P1vO7lv2hWZK%2Fscreenshot-www.udemy.com-2023.08.15-01_47_24.png?alt=media\&token=31753ce8-f319-4640-8e9a-067c9681096e)

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

## Athena

![](https://1374779285-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MFW3x2aqEO8GF2kr3VU%2Fuploads%2F1ycPh902FZlCdZXG0dmP%2Fscreenshot-www.udemy.com-2023.08.21-00_59_35.png?alt=media\&token=56611615-e3b1-4159-bbb6-b635fdd3e4eb)

* 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

![](https://1374779285-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MFW3x2aqEO8GF2kr3VU%2Fuploads%2Fc27g1p3s2hbUYPBEl8vo%2Fscreenshot-www.udemy.com-2023.08.21-01_11_15.png?alt=media\&token=66f5d7fb-2bbb-41dd-b36d-1cfd88cf1ae9)

* Managed extract, transform, load (ETL) service

## Lake Formation

![](https://1374779285-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MFW3x2aqEO8GF2kr3VU%2Fuploads%2FqLAVEotICiNXXwjucFgA%2Fscreenshot-www.udemy.com-2023.08.21-01_14_04.png?alt=media\&token=7ab0c635-5e79-42df-94ed-030af10b07a4)

* Central place to have all data for analytics purpose
* Fine-grained Access Control for applications (row & column level)

##

##

##
