2-Day (COURSE-BI-SSIS)
DescriptionFor most Business Intelligence projects, it is estimated that over 80% of the total work in a project is related to the extraction, transformation, and loading (ETL) of data. This course focusses on the core concepts of how to use SQL Server Integration Services (SSIS) to achieve this outcome. The course is divided into two parts. Day 1 covers the core concepts involved with using SSIS. While SSIS can be used to automate a wide variety of tasks, loading dimensional data models from source systems is the most common use case for SSIS. In Day 2 we present the loading of a dimensional data model as a specific case study for using SSIS. Duriing Day 2, additional SSIS techniques (including some more advanced techniques) are presented.
For details on booking courses, please send an e-mail.
AudienceThis course is intended for IT Professionals that are responsible for designing, developing, deploying, and operating business intelligence solutions.
While this course is based on SQL Server 2008R2, detailed coverage is provided on earlier versions ie: SQL Server 2005, SQL Server 2008. Differences between versions are highlighted.
PrerequisitesThe target audience for this session is database warehouse, decision support, and business intelligence solution architects, IT professionals, and business intelligence developers who want to learn the details of how to use the capabilities provided by SSIS to build ETL or other data integration solutions. While this course is targeted at database professionals with some experience with data warehouse solutions, this workshop can be completed by attendees without prior experience of SQL Server 2000 DTS or SQL Server 2005/2008 SSIS.
Course Objectives
This course objectives are:
Learning SSIS Features and Functionality: The initial day dives into all the core feature set of SSIS to lay the foundation for leveraging the tool for data processing requirements. The day finishes with a module that describes deployment and ongoing administration needs for SSIS.
Understanding and Applying SSIS Funcationality: Building on the SSIS knowledge that was obtained in the first day, the focus of day two is to apply the knowledge of how to use SSIS. While SSIS can be used for a wide variety of tasks, Day 2 presents a specific case study on using SSIS to load a dimensional data model and uses some more advanced SSIS techniques as they are needed.
Deploying and Administering SSIS in Production: The course covers getting ETL solutions over the goal line via deployment and ongoing administration.