• Course
  • Vendor

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 & load (ETL) with SQL Server Integration Service

  • Course Start Date: 2019-03-25
  • Time: 08:30:00 - 16:30:00
  • Duration: 5 days 08:30 AM - 04:30 PM
  • Location: Virtual
  • Delivery Methods(s): Virtual Instructor Led

Course Outline

Pre-Requisites

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

Lessons

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.

Our Microsoft Training Exclusives*
  • Six months of anytime access to your course labs and lab environment
  • Six months of 24/7 access to mentoring via chat, email, and phone
  • Six months of on-demand access to indexed, searchable recordings of your Virtual Classroom or Virtual Classroom Fit class
  • Six months of unlimited retakes of your class

* Terms and conditions may apply

Did You Know?

This class is available in our Virtual Classroom -- live online training that combines premium skills development technologies and expert instructors, content, and exercises to ensure superior training, regardless of your location.

What You'll Learn
  • 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
Who Needs to Attend
  • Database professionals who need to fulfill a BI developer role focused on hands-on work, creating BI solutions included data warehouse implementation, ETL, and data cleansing
  • Database professionals responsible for implementing a data warehouse, developing SSIS packages for data extraction, loading, transferring, transforming, and enforcing data integrity using MDS, and cleansing data using DQS
Follow-On Courses
  • Implementing Data Models and Reports with Microsoft SQL Server (M20466)
  • Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (M20467)
Certification Programs and Certificate Tracks

This course is part of the following programs or tracks:

  • MCSA: SQL Server 2012
Course 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

Cancellation Policy

We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted. Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.

Training Location

Online Classroom
your office

your city, your province
your country   

About Global Knowledge

x

Global Knowledge is the world's leading learning services and professional development solutions provider. We deliver learning solutions to support customers as they adapt to key business transformations and technological advancements that drive the way that organizations around the world differentiate themselves and thrive. Our learning programs, whether designed for a global organization or an individual professional, help businesses close skills gaps and foster an environment of continuous talent development.

Training Provider Rating

This vendor has an overall average rating of 4.38 out of 5 based on 421 reviews.

No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
Wasn’t as advanced as I thought it would be. There was an issue when the day my course was the first time they used a new platfo ... Read more
x

Wasn’t as advanced as I thought it would be. There was an issue when the day my course was the first time they used a new platform.. from adobe to something called zoom; I had to call support line cause it stated our instructor wasn’t present. Thankfully I called cause everyone online was in the adobe virtual classroom waiting for what looked like a teacher who didn’t show up for class (IT didn’t get anything resolved until 10mins after start time). I felt like he was really getting hung up on very basic knowledge for the first half of the course (talking about how to create tabs and drag formulas as an example). I completed files a few times before he was done explaining. There was a scheduled fire drill for them (roughly 30mins)that also cut into our time, which wasn’t deducted from the hour lunch break or the two, fifteen min breaks. I also really wish he touched base more on the automating workbook functions portion which we barely did. I'm happy there were/are those study guides (learning videos) and exams to take on my own time that I hope after I've had the class are still available for me to learn from.

No comment
No comment
No comment
No comment
It was difficult to practice on my PC while trying to watch the presentation online.
No comment
David was excellent!! I am very for having this course!!
No comment
Everything was great, but the instructor wasted a lot of time talking about unrelated subjects (like demo-ing different programs, ... Read more
x

Everything was great, but the instructor wasted a lot of time talking about unrelated subjects (like demo-ing different programs, talking about other classes, and talks about how Excel/technology has changed) took up way too much time. The course could have been condensed or better focus would have been great

Did not actually receive the course materials yet (and the course has concluded). Ratings assume that I will receive the course m ... Read more
x

Did not actually receive the course materials yet (and the course has concluded). Ratings assume that I will receive the course materials as soon as possible.

Course Reviews

No Reviews Yet