AWS Data Analysis

What is Amazon Athena?

A serverless service for analyzing data using SQL

When would you use Amazon Athena?

When analyzing data directly from storage without managing servers

What is Amazon QuickSight?

A serverless business intelligence service for creating interactive visualizations

When would you use Amazon QuickSight?

When creating interactive dashboards and reports from data

What is Amazon Kinesis?

A service for collecting and analyzing real-time data streams

When would you use Amazon Kinesis?

When processing continuously arriving data with low latency

What is Amazon Redshift?

A data warehouse for analyzing large datasets

When would you use Amazon Redshift?

When performing large-scale analytics and data warehousing and parallel processing

What is Amazon Macie?

A security service that discovers sensitive data in S3

When would you use Amazon Macie?

When identifying and protecting sensitive data such as PII

What is AWS Glue?

A serverless data integration and ETL service

When would you use AWS Glue?

When preparing and transforming data for analytics or machine learning

What is the difference between Athena and Redshift?

Athena queries data in storage while Redshift provides a data warehouse

What is the difference between Kinesis and Glue?

Kinesis handles streaming data while Glue integrates and transforms data

What is the difference between Athena and QuickSight?

Athena analyzes data while QuickSight visualizes and reports it

What is the sample data analytics workflow?

1. Kinesis (get real-time data)

2. Macie (for security)

3. S3 (stores data)

4. Glue (transforms data)

5. Redshift and Athena (analysis)

   1. QuickSight visualizes from Athena

   2. Redshift’s data used for ML