AWS-Logo_White-Color
1.
Introduction
1.1
Project Goals
1.2
Purpose and Applications
2.
Preparation Steps
2.1
Create IAM Role
2.2
Create S3 Bucket
2.3
Upload Sample Data
3.
Create Glue Crawler
3.1
Create Glue Database
3.2
Create Glue Crawler
3.3
Run Crawler
4.
Create Glue Job
4.1
Create New Glue Job
4.2
Write ETL Script
4.3
Run Job & Verify Output
5.
Create Glue Crawler for Processed Data
5.1
Create New Crawler
5.2
Run Crawler and Verify Table
6.
Query with Amazon Athena
6.1
Configure Athena
6.2
Query Processed Data
6.3
Advanced Queries
7.
Automate with AWS Lambda
7.1
Create Lambda Function
7.2
Write Python Code for Lambda
7.3
Attach S3 Trigger
7.4
Track User Behavior with AWS CloudTrail
8.
Visualize with Amazon QuickSight
8.1
Connect Athena to QuickSight
8.2
Create interactive dashboard
9.
Clean Up Resources
More
AWS Study Group - Blog
AWS Study Group - FB Group
English
Tiếng Việt
Clear History
Workshop
Cloud Journey
Last Updated
26-11-2023
Team
Gia Hưng
AWS Data Pipeline Workshop
>
Visualize with Amazon QuickSight
> Create interactive dashboard
8.2 Create Interactive Dashboard
Create interactive dashboard
8.2 Create Interactive Dashboard
Select
New analysis
→ use
sales_data_processed
dataset
Add visualizations:
Bar chart
: total revenue by
order_date
(
order_date
,
amount
)
Table
: top-selling products (
product
,
SUM(amount)
)
Customize titles, colors, and filters as needed
Create charts by reselecting the chart, dragging and dropping measures
Create dashboards to visualize data