Course Description

Do you get involved in the creation of data warehousing within your organisation? The solution provided by a Data Warehouse must be agile and supportable once in production to ensure it provides the business with the required information.

Whether you are new to data warehousing, and or SQL Server, or if you are an experienced SQL Server Business Intelligence developer, this workshop will provide you with the knowledge to build a Data Warehouse effectively within a business.

Join Chris for a demo-packed workshop to learn about the world of data quality using Master Data Services, Data Quality Service, Data Warehouse design patterns, and ETL capabilities of Integration Services. During the workshop you will build a Data Warehouse to reinforce your learning.

Course Outline

At the end of the two days you will have built a Data Warehouse, created a SSIS package to manage the load of data into a Data Warehouse. You will also address data quality issues using DQS and MDS. This workshop includes teaching on the following topics:

  • Master Data Services
  • Data Quality Services
  • Data Warehouse design patterns
  • Developing data warehouses
  • Using SQL Server Integration Services
  • Integrating SSIS, DQS and MDS

Course outline in pdf format

 
SQL Server logo

Details

Length:   2 days

Cost:   £594 per person (£495 + VAT)

Trainer:   Chris Testa-O'Neill

Contact:  info@itmasterclasses.com

_________________________________

Register your interest

If you are interested in this course please complete our short form and we will keep you informed when other dates and locations are available.

Further information:

Other courses in which you may be interested: Server 2012 R2 Masterclass    If there is a course you would like us to run then please suggest a course   Don't forget to visit our News and Events pages