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.