What you’ll learn
-
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 a 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.