|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-warehouse-etl-testing-data-quality-management-a-z/
课程评论：没有评论
**课程名称：** 数据仓库 ETL 测试与数据质量管理 A-Z **课程概述：** 本课程为期一步一步的教学，旨在帮助您掌握 ETL 数据仓库测试和数据质量管理的核心知识。您将学习 ETL 测试基础、常用的数据质量查询、报告和监控技术。课程将指导您如何构建用于数据质量监控的数据库视图，以及如何创建数据质量可视化和报告，甚至从零开始构建数据质量仪表板。您还可以学习到 ETL/ELT 测试中最常见的错误，并了解如何实现自动化的 ETL 和数据质量报告，告别手动 ad-hoc 测试。课程提供可下载的 Excel 训练材料，供您练习、应用知识并构建应用程序。每个模块后都有简短的测验，课程结尾设有期末测验。完成课程后，您将获得结业证书。 **先修要求：** * 具备基础 SQL 知识 * 熟悉可视化工具会很有帮助，但非必需 * 建议具备数据库（PostgreSQL, Oracle）和可视化工具（Qliksense）的基本设置经验 **课程内容：** * **引言：** 什么是 ETL/ELT 测试和数据质量管理？ * **构建数据质量监控的数据库视图** * **构建报告仪表板** * **练习** * **期末测验** **目标受众：** * 希望学习 ETL/ELT 测试和数据质量管理基础的学生。 * 希望深入了解 ETL/ELT 测试、常用查询和实践案例的业务分析师和数据分析师。 * 希望通过数据库视图/仪表板为 ETL/ELT 测试构建自动化解决方案的软件工程师。 * 考虑在其组织中应用数据质量标准的管理人员和数据管理员。
Learn the essentials of ETL Data Warehouse Testing and Data Quality Management through this step-by-step tutorial. This course takes you through the basics of ETL testing, frequently used Data Quality queries, reporting and monitoring. In this tutorial we will learn how to build database views for Data Quality monitoring and build Data Quality visualizations and reports!..Learn to build data quality dashboards from scratch!..Learn some of the most common mistakes made when performing ETL/ELT tests....Forget about manual ad-hoc ETL testing, learn more about automated ETL and data quality reportsThe course contains training materials, where you can practice, apply your knowledge and build an app from scratch. The training materials are provided in an Excel file that you can download to your computer. Each module also ends with a short quiz and there is a final quiz at the end of the course.After completion of this course, you will receive a certificate of completion.Good luck and hope you enjoy the course.Pre-requisites:Basic knowledge of SQL Some experience with Visualization tools would be helpful, but not required Basic setup of database (PostgreSQL, Oracle) and visualization tool (Qliksense) is recommendedCourse content:The course consists of the following modules:IntroductionWhat is ETL/ELT Testing and Data Quality Management?Build database views for Data Quality MonitoringBuild dashboards for ReportingExercisesFinal QuizWho should follow this course?Students that want to learn the basics of ETL/ELT testing and Data Quality ManagementBusiness Analysts and Data Analysts that would like to learn more about ETL/ELT testing, frequently used queries and practical examplesSoftware Engineers that would like to build an automated solution for ETL/ELT testing using database views/dashboardsData Stewards and Managers considering to apply data quality standards within their organization
