From the course: AWS Certified Data Engineer Associate (DEA-C01) Cert Prep
Unlock this course with a free trial
Join today to access over 25,300 courses taught by industry experts.
Introduction
From the course: AWS Certified Data Engineer Associate (DEA-C01) Cert Prep
Introduction
- Hey guys, and welcome to this section on data analytics. We've made it through to the final stage of the data pipeline where we can start extracting some actionable intelligence from the data that we have collected. Really every stage leading up to this was to get the data ready for business intelligence. In fact, designing a data pipeline should really start with defining the reports and analytics that the business needs, and then working backwards from there. The tools and solutions used for analytics and visualization are optimized for getting quick insights from the data. And in this section, you are going to learn about the various services you can use for analytics and visualization, and then what you need to know to operate and optimize them.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
(Locked)
Introduction45s
-
(Locked)
Analytics services2m 23s
-
(Locked)
Amazon Redshift5m 14s
-
(Locked)
Hands-on learning: Launch an Amazon Redshift cluster8m 22s
-
(Locked)
Amazon Redshift serverless2m 32s
-
(Locked)
Schema design for Amazon Redshift2m 36s
-
Loading data into Amazon Redshift6m 19s
-
(Locked)
Hands-on learning: Use the Amazon Redshift COPY command5m 19s
-
(Locked)
Unloading Amazon Redshift data1m 52s
-
(Locked)
Hands-on learning: Unload data to Amazon S33m 10s
-
(Locked)
Column compression2m 45s
-
(Locked)
Distribution styles5m 28s
-
(Locked)
Maintaining tables3m 41s
-
(Locked)
Amazon Redshift federated queries1m 55s
-
(Locked)
Amazon Redshift Spectrum2m 42s
-
Amazon Redshift materialized views3m 39s
-
(Locked)
Transform data with stored procedures4m 18s
-
(Locked)
Workload management1m 59s
-
(Locked)
Zero-ETL integrations3m 3s
-
(Locked)
Streaming ingestion2m 7s
-
(Locked)
Amazon Athena4m
-
(Locked)
Partitioning data3m 2s
-
(Locked)
Creating views2m 40s
-
(Locked)
Hands-on learning: Create and query tables using Athena4m 56s
-
(Locked)
AWS Lake Formation1m 58s
-
(Locked)
Hands-on learning: Create a data lake9m 9s
-
(Locked)
Amazon QuickSight4m 47s
-
(Locked)
Hands-on learning: Create a QuickSight dashboard5m 33s
-
Amazon OpenSearch7m 11s
-
(Locked)
-
-
-