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
“The Databricks Training was excellent”
- Spencer Martin, VP, Information Systems, RoyOMartin
“The trainer was INCREDIBLE. He was extremely passionate, made sure to consistently ask if anybody needed help, logged on early to answer any questions, and was an overall great human being.”
- Salvatore, Hilton Grand Vacations
“The BOW310/320 Web Intelligence Bootcamp was very good. The experienced and friendly trainer was very patient with all our questions and made sure we completed each exercise correctly. The post class support was also excellent!”
- Kelly Delaberta, BI Data Analyst, US Air Force
