Implementing a Data Warehouse with Microsoft SQL Server (M20463)

This Maven training course follows Microsoft Learning curriculum. To understand thoroughly the concepts of this course delegates must already possess knowledge about Administering Microsoft SQL Server 2014. Our well qualified and Microsoft Certified Trainers help delegates to understand each concept thoroughly by providing key learning points and real world examples. Learn with Maven training and gain certification at the end after clearing the exam.

Introduction to Data Warehousing

In this get an introduction to principal components of Data Warehousing Solution and other important considerations that delegate must take into account while starting on a Data Warehousing Project.

• Overview of Data Warehousing
• Considerations for Data Warehouse solution

Data Warehouse Hardware Considerations

In this get review for selecting hardware and distributing SQL Server facilities across servers.

• Considerations for building Data Warehouse
• Data Warehouse Reference Appliances and Architectures

Design and implement a Data Warehouse

This module describes primary factors for the logical design of data warehouse and then best practices for implementing it physically.

• Logical design for Data Warehouse
• Physical design for Data Warehouse

Creating an ETL Solution with SSIS

In this learn about considerations for implementing ETL process and then focus integration services of Microsoft SQL Server that act as a platform for building ETL solutions.

• Introduction to ETL with SSIS
• Explore data sources
• Implement data flow

Implement control flow in SSIS package

It describes how to apply these ETL solutions that combine multiple workflow logic and tasks.

• Introduction to control flow
• Create Dynamic packages
• Using containers
• Consistency management

Debug and troubleshoot SSIS packages

In this module learn how to debug SSIS packages for finding the cause of errors that occur during execution. Understand about logging functionality to log events for troubleshooting and learn about various approaches to handling errors in control and data flow.

• Debug an SSIS package
• Logging events of SSIS package
• Handle errors in SSIS package

Implementing Incremental ETL process

It describes techniques to perform an additional Data Warehouse refresh process.

• Introduction to Incremental ETL
• Extracting modified data
• Loading modified data

Enforce Data Quality

• Introduction to Data Quality
• Using Data Quality Service to cleanse data
• Using Data Quality services to match data

Using Master Data Services

Master data services provide a way for organisations to improve quality, trust and consistency of data and standardise data that guides major business decisions. It also explains the benefits of using Master Data Services.

• Master Data Services Concepts
• Implement a Master Data Service Model
• Manage master data
• Create Master Data Hub

Extending SQL Server Integration services

This module describes techniques delegates can use to extend SSIS. It provides awareness of basic steps required to use custom components and scripts in ETL process which is based on SSIS.

• Use scripts in SSIS
• Using custom components in SSIS

Deploying and configuring SSIS packages

In this learn to use packages and their dependencies to the server and how to manage as well as monitor execution of used packages.

• SSIS deployment overview
• Deploy SSIS projects
• Plan SSIS package execution

Consuming Data in Data Warehouse

It introduces business intelligence (BI) and describes how to use Data Warehouse as the basis for self-service and enterprise Business Intelligence (BI).

• Introduction to business intelligence
• Introduction to reporting
• Introduction to Data Analysis