Description

Implement an MS SQL Server Data Warehouse & Power BI Solution

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 MS SQL Server 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

Deploy SSIS projects

Implement a Master Data Services model

Describe how you can use custom components to extend SSIS

Describe BI and common BI scenarios

Create a data warehouse with Microsoft SQL Server

Implement ETL with SQL Server Integration Services

validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.