View all courses

Learn to implement a data warehouse platform with Microsoft SQL Server 2016. This 5-day instructor-led course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server and other Microsoft BI technologies.

Target Audience
The primary audience for this course are database professionals who need to fulfill a Business Intelligence Developer role.  They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL and data cleansing.

What You'll Learn

  • Describe the key elements of a data warehousing solution
  • Describe the main hardware considerations for building a data warehouse
  • Implement a logical design for a data warehouse
  • Implement a physical design for a data warehouse
  • Create columnstore indexes
  • Implementing an Azure SQL Data Warehouse
  • Describe the key features of SSIS
  • Implement a data flow by using SSIS
  • Implement control flow by using tasks and precedence constraints
  • Create dynamic packages that include variables and parameters
  • Debug SSIS packages
  • Describe the considerations for implement an ETL solution
  • Implement Data Quality Services
  • Implement a Master Data Services model
  • Describe how you can use custom components to extend SSIS
  • Deploy SSIS projects
  • Describe BI and common BI scenarios

*Request Detailed Syllabus
~Epic LIVE! delivery options also available!

Register for this course
View all courses
  • Course Number M20767
  • Course Length 5 days
  • Course Fee $2,775.00
  • Delivery Format VLT (Instructor Led; Virtual LIVE Online; Remote Training)
  • Course Topic Business Intelligence
  • Vendor Microsoft
  • Technology SQL Server
Need a different date? This course is also offered on these dates

Register for course: M20767

By registering for this course, I acknowledge that I understand the terms of the Enspire Training Agreement that I agree to the stated course fee; and that I agree to pay in full the stated cost. We look forward to having you attend this training class!