Data Warehouse ETL Testing & Data Quality Management A-Z

Offered byUDEMY

Data Warehouse ETL Testing & Data Quality Management A-Z
at
UDEMY
Overview

ETL Testing and Data Quality Management for beginners with practical exercises and certificate of completion

Duration	2 hours
Total fee	₹2,799
Mode of learning	Online
Credential	Certificate

Data Warehouse ETL Testing & Data Quality Management A-Z
at
UDEMY
Highlights

Earn a certificate after completion of the course
30-Day Money-Back Guarantee
Full Lifetime Access

Data Warehouse ETL Testing & Data Quality Management A-Z
at
UDEMY
Course details

Skills you will learn

Excel Regression Software Testing SAS Data analysis Quality Management Informatica Data Warehousing

Who should do this course?

Students that want to learn the basics of ETL/ELT testing and Data Quality Management
Business Analysts and Data Analysts that would like to learn more about ETL/ELT testing, frequently used queries and practical examples
Software Engineers that would like to build an automated solution for ETL/ELT testing using database views/dashboards

What are the course deliverables?

Understand the basics of ETL/ELT testing
The importance of Data Quality within the Data Lifecycle
Learn the different types of ETL/ELT testing and Data Quality dimensions
Design a set of frequently used ETL/ELT and Data Quality regression tests
A comparison of Data Quality tools (Informatica, Talend, Oracle, SAS)
Perform database tests using queries and build database views to automate ETL/ELT testing and Data Quality monitoring
Data Quality Management and monitoring
Setting up a database connection to your visualization tool
Build Data Quality dashboards and reports

More about this course

The 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

Data Warehouse ETL Testing & Data Quality Management A-Z
at
UDEMY
Curriculum

Introduction

Data Quality and ETL Testing - Building Database Views

Data Quality and ETL Testing - Dashboards and Monitoring

Conclusion - Final Note

Data Warehouse ETL Testing & Data Quality Management A-Z
at
UDEMY
Faculty details

Lorenz DS

Lorenz DS is a BI consultant with several years of experience working as a developer, system engineer and functional analyst, mainly in the Business Intelligence domain