|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/the-path-to-insights-data-models-and-pipelines
课程评论：没有评论
课程名称：《洞察之路：数据模型与管道》 课程概述：这是谷歌商业智能证书的第三门课程。在本课程中，您将深入探索数据建模以及数据库的设计。您还将学习提取、转换、加载（ETL）流程，这些流程从源系统中提取数据，将其转换为可用于分析的格式，并推动业务流程和目标。 该课程由目前在商业智能领域工作的谷歌员工指导，提供动手活动，模拟工作任务，并分享经验。 课程大纲： 1. 数据模型与管道：您将通过探索数据建模、常用模式和数据库元素开始本课程。您将考虑如何根据业务需求决定商业智能专业人士实施的数据库系统类型。随后，您将探讨管道和ETL过程，这些工具用于移动数据，确保其可访问并且有用。 2. 动态数据库设计：您将深入学习数据库系统，包括数据集市、数据湖、数据仓库和ETL过程。您还将研究数据库性能的五个因素：工作负载、吞吐量、资源、优化和竞争。最后，您将考虑如何设计高效的查询，以充分利用系统。 3. 优化ETL流程：您将学习优化技术，包括ETL质量测试、数据模式验证、业务规则验证和一般性能测试。您还将探讨数据完整性，了解内置质量检查如何防止潜在问题。最后，您将专注于验证业务规则和性能测试，以确保管道满足预期的业务需求。 4. 课程结束项目：您将完成一个课程结束项目，通过创建一个将数据传递到目标表的管道流程，并根据项目需求开发报告。您还需要确保管道正常运行，并针对数据质量问题设置内置防御机制。
Name:Data models and pipelines
Description:You’ll start this course by exploring data modeling, common schemas, and database elements. You’ll consider how business needs determine the kinds of database systems that BI professionals implement. Then, you’ll discover pipelines and ETL processes, which are tools that move data and ensure that it’s accessible and useful.
Name:Dynamic database design
Description:You’ll learn more about database systems, including data marts, data lakes, data warehouses, and ETL processes. You’ll also investigate the five factors of database performance: workload, throughput, resources, optimization, and contention. Finally, you’ll consider how to design efficient queries that get the most from a system.
Name:Optimize ETL processes
Description:You’ll learn about optimization techniques including ETL quality testing, data schema validation, business rule verification, and general performance testing. You’ll also explore data integrity and learn how built-in quality checks defend against potential problems. Finally, you’ll focus on verifying business rules and general performance testing to make sure pipelines meet the intended business need.
Name:Course 2 end-of-course project
Description:You’ll complete an end-of-course project by creating a pipeline process to deliver data to a target table and developing reports based on project needs. You’ll also ensure that the pipeline is performing correctly and that there are built-in defenses against data quality issues.
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. Google employees who currently work in BI will guide you through this course by providing hands-on activities that simulate job tasks, sharing ex
