This is the second of three courses in the Google Business Intelligence Certificate. In this course, you'll explore data modeling and how databases are designed. Then you’ll learn about extract, transform, load (ETL) processes that extract data from source systems, transform it into formats that enable analysis, and drive business processes and goals.

Take the Certificate HERE: https://goo.gle/47Sw2oT

Get started with data modeling, schemas, and databases - 0:00
Choose the right database - 22:04
How data moves - 30:35
Data-processing with Dataflow and BigQuery - 42:21
It’s all about information - 48:51
Review: Data models and pipelines - 52:08
Database performance - 53:26
Review: Dynamic database design - 01:10:16
Optimizing pipelines and ETL processes - 01:11:35
Data schema validation - 01:18:32
Business rules and performance testing - 01:27:11
Review: Optimize ETL processes - 01:30:51
Congratulations on completing Course 2! - 01:32:41

Subscribe HERE: https://bit.ly/SubscribeGCC

#GoogleCareerCertificates #BusinessIntelligence #DataModels

The Google Business Intelligence Certificate teaches learners how to create processes and information channels that transform data into actionable insights to inform business decisions. Designed and taught by experts at Google, this advanced program builds on the foundations of the Google Data Analytics Certificate and helps enhance technical skills with industry-leading tools, including  BigQuery, Tableau, and SQL.

Google Career Certificates
https://www.youtube.com/@GoogleCareerCertificates

The Path to Insights: Data Models and Pipelines
https://youtu.be/2-sWd8hUlQE