This course is for professionals planning to enroll in the 70-463 Exam leading to the 70-463 Certification. The official exam voucher is not included in this course. However, the official exam voucher can be purchased separately on request

About this Course:

This course is only accessible for 90 days from the enrollment date and is a Microsoft On-Demand Course. Candidates having annual subscriptions or candidates who purchase this course individually will lose access to this course after 90 days.

This intermediate-level 2 days course is specifically designed to help professionals learn the art of implementing, designing, and loading relational data warehouses. This also covers Business Requirements Analysis, Design Dimensions, Index, Fact Tables, Data Partition, and ETL Solution Development. On average, a Microsoft Data Warehousing Professional earns $110,000 annually and this course helps professionals pursue a successful career in this field.

Course Objectives:

The core objective of this course is to help professional gain a better understanding and sound knowledge of the following key concepts:

• Data Warehouse Architecture Considerations & Concepts
• Hardware Platform Selection for Data Warehousing
• Data Warehouse Implementation and Design
• SSIS Package Control Flow & Data Flow Implementation
• Troubleshooting and Debugging SSIS Packages
• ETL Solution Implementation for Incremental Data Loading & Data Extraction
• Microsoft Data Quality Services Data Cleansing Implementation
• Enforcing Data Integrity by Master Data Services Implementation
• SSIS Extension with Custom Components and Scripts
• SSIS Packages Deployment and Configuration
• BI Solution Data Consumption from Data Warehouse

Audience:

• Business Intelligence Developers
• Database Professionals
• Professionals liable for Implementing Data Warehouse & Data Cleansing
• Developers Creating & Developing BI Solutions
• Professionals liable for Developing SSIS Packages & Enforcing Data Integrity 

Prerequisites:

Professionals planning to enroll in this course must comply with the following prerequisites:

• 2-Years’ Practical Experience of Relational Databases
• Familiarity with Transact SQL Querying, Tables Creation, & Normalized Databases
• Fundamental Knowledge of Branching, Looping, other Programming Concepts
• Understanding of Major Business Priorities is highly Recommended