SQL Server 2012 Business Intelligence and Data Warehouses using SSIS
Duration: 5 Days
This course teaches the student how to implement BI solutions to support information worker analytics. Students will learn how to implement ETL with SQL Server Integration Services. Data Tools and Management Studio will be used to create, debug, and deploy projects using tables, flat files, and Excel Spreadsheets. Syntax solutions will include Expressions and VB.NET.
Topics Covered In This Course
Introduction to Data Warehousing
Design and Implement a Schema for a Data Warehouse
Implementing Control Flow in an SSIS Package
Implementing a Dataflow
Debugging and Troubleshooting SSIS Packages
Deploying and Configuring SSIS Packages
Accessing Data in a Data Warehouse Overview
Dimensional Modeling Overview
Other SQL Server Service options
What You Can Expect
At the end of this course, students will be able to:
Who Should Take This Course
Business Intelligence Developers, Knowledge Workers and Data Analysts, and Administrators
Some knowledge of SQL Server Integration Services.
Instructor led with 50% lecture and 50% lab.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]