Data warehousing is a solution organizations use to centralize business data for reporting and analysis. This five-day instructor-led course focuses on teaching individuals how to create a data warehouse with SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. This course helps people prepare for exam 70-463.
Ace your preparation for Microsoft® Certification Exam 70-463 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with online practice tests—featuring multiple, customizable testing options. Maximize your performance on the exam by learning how to: •Design and implement a data warehouse •Develop and enhance SQL Server Integration Services packages •Manage and maintain SQL Server Integration Services packages •Build data quality solutions •Implement custom code in SQL Server Integration Services packages
The primary audience for this exam is Extract Transform Load (ETL) and Data Warehouse Developers. They are most likely to focus on hands-on work creating business intelligence (BI) solutions including data cleansing, ETL, and Data Warehouse implementation. Their primary responsibilities may include: •Mastering data using Master Data Services •Cleansing data using Data Quality Services •ETL Package development for data loading/transfer/transformation •Data Synchronization •One-time data or application migration •Ad hoc data manipulations and transformations •Scheduling ETL jobs •Managing, configuring, and deploying SQL Server Integration Services (SSIS) packages
Saving please wait...