Implementing A SQL Data Warehouse
This course is intended for extract, transform, and load (ETL) and data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing, in addition to ETL and data warehouse implementation.
Description
Exam 70-767 Implementing a SQL Data Warehouse
This course is intended for extract, transform, and load (ETL) and data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing, in addition to ETL and data warehouse implementation.
Content
Course Content
Design, implement, and maintain a data warehouse (35–40%)
- Design and implement dimension tables
- Design and implement fact tables
- Design and implement indexes for a data warehouse workload
- Design storage for a data warehouse
- Design and implement partitioned tables and views
Extract, transform, and load data (40–45%)
- Design and implement an extract, transform, and load (ETL) control flow by using a SQL Server Integration Services (SSIS) package
- Design and implement an ETL data flow by using an SSIS package
- Implement an ETL solution that supports incremental data extraction
- Implement an ETL solution that supports incremental data loading
- Debug SSIS packages
- Deploy and configure SSIS packages and projects
Build data quality solutions (15–20%)
- Create a knowledge base
- Maintain data quality by using DQS
- Implement a Master Data Services (MDS) model
- Manage data by using MDS
ENQUIRY