Course Description
This five-day instructor-led course focuses on teaching individuals how to create a data warehouse with SQL Server 2014/2016/2019, 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 describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Course Summary
Next Public Course Dates | |
| Prerequisites |
|
| Duration |
|
| Available Formats |
|
| Audience |
|
Course Modules
- Introduction to Data Warehousing
- Data Warehouse Hardware
- Designing and Implementing a Data Warehouse
- Creating an ETL Solution with SSIS
- Implementing Control Flow in an SSIS Package
- Debugging and Troubleshooting SSIS Packages
- Implementing an Incremental ETL Process
- Incorporating Data from the Cloud into a Data Warehouse
- Enforcing Data Quality
- Using Master Data Services
- Extending SQL Server Integration Services
- Deploying and Configuring SSIS Packages
- Consuming Data in a Data Warehouse
Testimonials
“Your private Tableau Desktop Bootcamp I for Beginners training was excellent, our 15 staff members thoroughly enjoyed it!”
- David Sonntag, US Airforce
“The SAP BOE310 Business Intelligence Platform: Administration and Security training was well presented and the trainer was very patient with us, now signed up to the BOE320 Administering Servers training”
- Yocelyn Robles, Platform Engineer, Franchise Tax Board
“The SAP BOID10 Universe Designer class was a very enjoyable and informative course and we’re all looking forward to using the skills we learnt. We all agreed that the instructor was very good and was able to break down pretty complex issues to make them more understandable”
- Grahame Welch, Head of BI, UK Home Office
