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

JOIN AN UPCOMING CLASS FOR THIS COURSE