SQL Server 2012 Business Intelligence and Data Warehouses
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, validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Special BI reporting considerations are included to use PerformancePoint 2010 and Report Builder. Data Warehouse Analysis, Design, and Implementation will be included as time allows.
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
Debugging and Troubleshooting SSIS Packages
Implementing an Event Handler
Enforcing Data Quality
Using Master Data Services
Deploying and Configuring SSIS Packages
Accessing Data in a Data Warehouse Overview
Data Warehouse Analysis, Design and Implementation Considerations
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.
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@example.com