Summary
Keywords
Full Transcript
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://www.coursera.org/google-certificates/business-intelligence-certificate?utm_source=google&utm_medium=institutions&utm_campaign=youtube-organic__geo--Global&utm_content=vid--2-sWd8hUlQE__topic--BI&utm_term=youtube-description 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://goo.gle/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
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
