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
- Course Number M20767
- Course Length 5 days
- Course Fee $2,875.00
- Delivery Format vILT (Instructor Led; Virtual LIVE Online; Remote Training)
- Course Topic Business Intelligence
- Vendor Microsoft
- Technology SQL Server
Register for course: M20767
"*" indicates required fields