20463-Implementing a Data Warehouse with Microsoft SQL Server 2014
Course Details

I Want Answers

By submitting this form, you are giving your express written consent for PPG to contact you regarding our services using email, telephone or text - including our use of automated technology for calls and periodic texts to any wireless number you provide.

20463-Implementing a Data Warehouse with Microsoft SQL Server 2014

Category ID Duration Price
Microsoft SQL Server M20463 5 Day(s) $2,875.00
  View Schedule

Description

In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. You will discover how to create a data warehouse, implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and validate and cleanse data with SQL Server Data Quality Services (DQS) and SQL Server Master Data Services.

This course incorporates material from the Official Microsoft Learning Product 20463: Implementing a Data Warehouse with Microsoft SQL Server. It covers the skills and knowledge measured by Exam 70-463 and along with on-the-job experience, helps you prepare for the exam.

Objectives

· Data warehouse concepts and architecture considerations
· Select an appropriate hardware platform for a data warehouse
· Design and implement a data warehouse
· Implement data flow and control flow in a SSIS package
· Debug and troubleshoot SSIS packages
· Implement a SSIS solution that supports incremental data warehouse loads and extracting data
· Implement data cleansing using Microsoft DQS
· Implement Master Data Services (MDS) to enforce data integrity
· Extend SSIS with custom scripts and components
· Deploy and configure SSIS packages
· How Business Intelligence solutions consume data in a data warehouse

Prerequisites

· Minimum two years experience working with relational databases, including designing a normalized database, creating tables and relationships
· Basic programming constructs, including looping and branching
· Focus on key business priorities, such as revenue, profitability, and financial account
· Querying Microsoft SQL Server (M20461)

Outline

1. Data Warehousing
Concepts and Architecture Considerations
Considerations for a Data Warehouse Solution

2. Data Warehouse Infrastructure
Hardware Selections
Considerations for Business Intelligence Infrastructure

3. Design and Implement a Data Warehouse
Logical Design, Including Dimension Tables and Fact Tables
Physical Implementation, Including a Star Schema, Snowflake Schema, and Time Dimension

4. Create an ETL Solution with SSIS
ETL with SSIS
Explore Source Data
Implement Data Flow

5. Implement Control Flow in an SSIS Package
Control Flow
Create Dynamic Packages
Using Containers
Manage Consistency with Transactions and Checkpoints

6. Debug and Troubleshoot SSIS Packages
Debug an SSIS Package
Log SSIS Package Events
Implement an Event Handler
Handle Errors in an SSIS Package

7. Implement an Incremental ETL Process
Incremental ETL
Data and Modified Data Extraction

8. Load Data into a Data Warehouse
Data and Modified Data Load planning
Incremental loads Using SSIS
Transact-SQL Loading Techniques

9. Enforce Data Quality
Microsoft SQL Server DQS
Use DQS to Cleanse Data
Use DQS to Match Data

10. Master Data Services
Master Data Services Concepts
Implement a Master Data Services Model
Master Data Services Tools to Manage and Create Master Data

11. Extend SSIS
Custom Components in SSIS
Scripting in SSIS

12. Deploy and Configure SSIS Packages
Deployment Considerations
Deploy SSIS Projects
Plan SSIS Package Execution

13. Consume Data in a Data Warehouse
Business Intelligence Solutions
Enterprise BI Solution
Self-Service BI and Big Data Solutions

Labs
Lab 1: Explore a Data Warehouse Solution
Lab 2: Data Warehouse Infrastructure Planning
Lab 3: Data Warehouse Implementation
Lab 4: Implement Data Flow in a SSIS Package
Lab 5A: Implement Control Flow in a SSIS Package
Lab 5B: Transactions and Checkpoints Usage
Lab 6: Debug and Troubleshoot a SSIS Package
Lab 7: Extract Modified Data
Lab 8: Data Warehouse Loading
Lab 9: Cleanse Data
Lab 10: Implement Master Data Services
Lab 11: Custom Scripts
Lab 12: Deploy and Configure SSIS Packages
Lab 13: Data Warehouse Usage in Enterprise and Self-Service BI Scenarios

Productivity Point Learning Solutions evolved out of a desire to increase our outreach both nationally and internationally.

PPLS Headquarters
1580 Sawgrass Corporate Parkway
Suite 205
Sunrise, Florida 33323
United States

Contact
T 1-844-238-8607
P 1-954-425-6141
F 1-954-928-9057
E info@productivitypointls.com

© Copyright 2019 Productivity Point Learning Solutions. All Rights Reserved.