Data Warehouse / ETL Testing

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

Created by: Lorenz D.
Udemy instructor

What Will I Learn?

• 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

Requirements

• Some basic knowledge of SQL
• Some basic knowledge of visualization tools is recommended, but not required
• Database setup (PostgreSQL, Oracle, SQL Server etc.) is recommended
• Visualization setup (Qlik, Spotfire, Microstrategy, Tableau, PowerBI etc.) is recommended

Target audience

• 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
• Data Stewards and Managers considering to apply data quality standards within their organization