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 2014, 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 is intended for database professionals who need to create and support a data warehousing solution.

This course requires that you meet the following prerequisites: ? At least 2 years? experience of working with relational databases, including: Designing a normalized database, Creating tables and relationships, Querying with Transact-SQL, Some exposure

Klassikaal en Maatwerk

In deze training worden de volgende onderwerpen behandeld:

Module 1: Introduction to Data Warehousing
Module 2: Planning Data Warehouse Infrastructure
Module 3: Designing and Implementing a Data Warehouse
Module 4: Creating an ETL Solution with SSIS
Module 5: Implementing Control Flow in an SSIS Package
Module 6: Debugging and Troubleshooting SSIS Packages
Module 7: Implementing a Data Extraction Solution
Module 8: Loading Data into a Data Warehouse
Module 9: Enforcing Data Quality
Module 10: Master Data Services
Module 11: Extending SQL Server Integration Services
Module 12: Deploying and Configuring SSIS Packages
Module 13: Consuming Data in a Data Warehouse

Geen