Description

This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around implementing a Data Warehouse with Microsoft SQL Server 2012.This course is designed for ETL and Data Warehouse Developers who most likely focus on hands-on work creating business intelligence (BI) solutions, including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation. Primary responsibilities may include: Mastering data using Master Data ServicesCleansing data using Data Quality ServicesETL Package development for data loading/transfer/transformationData SynchronizationOne-time data or application migrationAd-hoc data manipulations, transformationsScheduling ETL jobsManaging, configuring and deploying SQL Server Integration Services (SSIS) packagesThis training course on implementing a Data Warehouse with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-463.This course will provide all the skills and knowledge for the following areas: Designing and implementing dimensionsDesigning and implementing fact tablesDefining connection managersDesigning and implementing data flowManaging SSIS package executionImplementing script tasks in SSISDesigning and implementing control flowImplementing package logic using SSIS variables and parametersImplementing data load optionsImplementing script components in SSISTroubleshooting data integration issuesInstalling and maintaining SSIS componentsImplementing auditing, logging, and event handlingDeploying SSIS solutionsConfiguring SSIS security settingsInstalling and maintaining Data Quality ServicesImplementing master data management solutionsCreating a data quality project to clean dataWe create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.