Training
SQL Server Integration Services Case Study
SQL Server Integration Services is Microsoft's primary tool for ETL (Extract-Transform-Load) processing. This course is designed to show you how to apply your skills in SSIS to the challenge of loading a dimensional data model, with just the right amount of depth, within a single day.

The course is most suitable for developers that need to learn to work with the Microsoft BI platform or for existing SQL Server developers and DBAs that want to cross-train into BI work. The course can also help business analysts and project managers that need a solid understanding of the technologies involved. While not essential to complete the labs (as full detailed instructions are provided), some knowledge of T-SQL would be helpful.

The course starts by looking at what's involved in creating a data model that is suitable for analysis and reporting and provides a quick overview of dimensional modelling concepts. You'll learn about how to use the tools provided by SSIS to load a dimensional model, including loading facts and dimensions. You will learn how to implement slowly-changing dimensions and how to manage grain in fact tables. You'll also learn how to optimise the performance of your ETL processing.

While our courses are based on SQL Server 2016, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014. Where there are differences between versions, the differences are clearly highlighted.
City
Dates
Course Price
Early Bird Price
There isn't a public offering for this course scheduled at present but please contact us to register your interest or to request a quote for private training.
Day
Code
Module
1
IS301
SSIS Case Study: Dimensional Modelling Core Concepts
- Why Implement Dimensional Models?
- Fact Table Core Concepts
- Dimension Table Core Concepts
- Profiling Incoming Data
- LAB: Dimensional Modelling Core Concepts
1
IS302
Loading Dimension Tables
- Issues with Loading Dimension Tables
- Implementing Slowly-Changing Dimensions
- Implementing Inferred Members
- Useful Additional Transformations
- LAB: Loading Dimension Tables
1
IS303
Loading Fact Tables
- Issues with Loading Fact Tables
- Working with Granularity and Calculations
- Useful Additional Transformations
- LAB: Loading Fact Tables
1
IS304
Designing for Reliability and Performance
- Designing for Reliability
- Improving SSIS Package Performance
- Incremental Data Loads
- LAB: Designing for Reliability and Performance
Phone: 1300 SQL SQL (1300 775 775) l International +61 1300 775 775 l Fax: +61 3 8676-4913
Copyright 2017 by SQL Down Under | Terms Of Use | Privacy Statement