After following this course, the students will be able to:

The audience for this course are database professionals who need to fulfil 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.

To participate in this course, the students need at least 2 years' experience of working with relational databases.

Classical and Tailor iT made training

During this course the following topics will be covered:

Module 1: Introduction to Data Warehousing

Module 2: Planning Data Warehouse Infrastructure

Module 3: Designing and Implementing a Data Warehouse

Module 4: Columnstore Indexes

Module 5: Implementing an Azure SQL Data Warehouse

Module 6: Creating an ETL Solution

Module 7: Implementing Control Flow in an SSIS Package

Module 8: Debugging and Troubleshooting SSIS Packages

Module 9: Implementing an Incremental ETL Process

Module 10: Enforcing Data Quality

Module 11: Using Master Data Services

Module 12: Extending SQL Server Integration Services (SSIS)

Module 13: Deploying and Configuring SSIS Packages

Module 14: Consuming Data in a Data Warehouse