20767: Implementing SQL Data Warehouse Training teaches professionals the leading methodologies to build a data warehouse with the help of MS SQL Server and Azure SQL Data Warehouse. This technical course demonstrates how to apply a data warehouse platform to support a BI solution. It provides comprehensive knowledge of the main hardware considerations for developing a data warehouse. Throughout this course, trainees will learn to implement a logical design and a physical design for a data warehouse. It also elaborates on the critical features of SSIS and teaches how to create dynamic packages, including parameters and variables. This training program is ideal for a data professional who works as a Business Intelligence Developer. This program covers all the essential topics from implementing control flow and debugging SSIS packages to applying to a master data services school.
This training is designed based on the objectives of the course variant 20767C.
The database professionals looking to upgrade to a BI developer role are the primary audience for the course. This course will teach them hands-on work to create Business Intelligence solutions that include implementing Data Warehouse, data cleansing and ETL.