Implementing a SQL Data Warehouse - Seminar / Kurs von PROTRANET GmbH

After completing this course, students will be able to: - Describe the key elements of a data warehousing solution - Describe the main hardware considerations for building a data warehouse - Implement a logical design for a data warehouse - Implement a physical design for a data warehouse - Create columnstore indexes - Implementing an Azure SQL Data Warehouse - Describe the key features of SSIS - Implement a data flow by using SSIS - Implement control flow by using tasks and precedence constraints - Create dynamic packages that include variables and parameters - Debug SSIS packages - Describe the considerations for implement an ETL solution - Implement Data Quality Services - Implement a Master Data Services model - Describe how you can use custom components to extend SSIS - Deploy SSIS projects - Describe BI and common BI scenarios

- Describe the key elements of a data warehousing solution - Describe the main hardware considerations for building a data warehouse - Implement a logical design for a data warehouse - Implement a physical design for a data warehouse - Create columnstore indexes - Implementing an Azure SQL Data Warehouse - Describe the key features of SSIS - Implement a data flow by using SSIS - Implement control flow by using tasks and precedence constraints - Create dynamic packages that include variables and parameters - Debug SSIS packages - Describe the considerations for implement an ETL solution - Implement Data Quality Services - Implement a Master Data Services model - Describe how you can use custom components to extend SSIS - Deploy SSIS projects - Describe BI and common BI scenarios

The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.