➔ Analytics with QuickSight, Athena, Redshift SQL, and Notebooks on AWS
Book: AWS Certified Data Engineer Associate Study Guide Authors: Sakti Mishra, Dylan Qu, Anusha Challa Publisher: O’Reilly Media ISBN: 978-1-098-17007-3
Chapter 6 is titled “Data Operations and Support” and it’s a big one. This post covers the first part: analytics operations. QuickSight for BI dashboards, Athena for SQL on S3, Redshift for heavy SQL analytics, and notebooks for interactive data exploration. These are the tools you use after you’ve built your pipelines and stored your data. Now you actually look at it.
➔ Data Modeling for Redshift, DynamoDB, and Data Lakes on AWS
Previous: Data Stores and Lifecycle
Book: AWS Certified Data Engineer Associate Study Guide Authors: Sakti Mishra, Dylan Qu, Anusha Challa Publisher: O’Reilly Media ISBN: 978-1-098-17007-3
Data modeling is one of those topics that sounds academic until you get it wrong in production. Then it becomes very real, very fast. This section of Chapter 5 covers data modeling strategies for three different AWS services: Amazon Redshift, Amazon DynamoDB, and S3 data lakes. Each has its own rules, trade-offs, and gotchas.
➔ Data Transformation on AWS: Glue, EMR, Redshift, Flink, and Lambda Compared
Previous: Data Ingestion Patterns
Book: AWS Certified Data Engineer Associate Study Guide Authors: Sakti Mishra, Dylan Qu, Anusha Challa Publisher: O’Reilly Media ISBN: 978-1-098-17007-3
Second part of Chapter 4, covering data transformation. The first part was about ingestion. Now we look at what happens after the data lands. You need to clean it, reshape it, enrich it, and get it into a format that analysts and applications can actually use.
➔ AWS Analytics Services: Kinesis, Glue, Athena, Redshift, and More
Previous: Prerequisite Knowledge
Book: AWS Certified Data Engineer Associate Study Guide Authors: Sakti Mishra, Dylan Qu, Anusha Challa Publisher: O’Reilly Media ISBN: 978-1-098-17007-3
Chapter 3 is where the real AWS content starts. This is the overview of analytics services you need to know for the DEA-C01 exam. Even if you’re not taking the exam, it’s a solid map of what AWS offers for data work.
There are a lot of services here. Some overlap. Some feel redundant. That’s just how AWS works.