Implementing A Data Warehouse with Microsoft SQL Server
This course is primarily intended for ETL and data warehouse developers who create Business Intelligence (BI) solutions, and whose responsibilities include data cleansing, and Extract Transform Load and data warehouse implementation.
Exam 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
This course is primarily intended for ETL and data warehouse developers who create Business Intelligence (BI) solutions, and whose responsibilities include data cleansing, and Extract Transform Load and data warehouse implementation.
Course Content
Design and implement a data warehouse (10–15%)
- Design and implement dimensions
- Design and implement fact tables
Extract and transform data (20–25%)
- Define connection managers
- Design data flow
- Implement data flow
- Manage SSIS package execution
- Implement script tasks in SSIS
Load data (25–30%)
- Design control flow
- Implement package logic by using SSIS variables and parameters
- Implement control flow
- Implement data load options
- Implement script components in SSIS
Configure and deploy SSIS solutions (20–25%)
- Troubleshoot data integration issues
- Install and maintain SSIS components
- Implement auditing, logging, and event handling
- Deploy SSIS solutions
- Configure SSIS security settings
Build data quality solutions (15–20%)
- Install and maintain data quality services
- Implement master data management solutions
Create a data quality project to clean data