SQL Server Training

Designing a Business Intelligence Solution by Using Microsoft SQL Server 2008

Microsoft 50399

Microsoft Certification

Length:	5 Days
Published:	February 01, 2011
Language(s):	English
Audience(s):	IT Professionals,Developers
Level:	300
Technology:	Microsoft SQL Server 2008
Type:	Course
Delivery Method:	Instructor-led (classroom)

About this Course

This five-day instructor-led course provides in-depth knowledge on designing a Business Intelligence solution by using Microsoft SQL Server 2008.

Audience Profile

The primary audience for this course is developers who have knowledge of Business Intelligence (BI) concepts, with an experience of 4-5 years in BI. The audience has an understanding of how to use SQL Server 2005 BI tools to implement a BI infrastructure and solution. However, the audience needs to develop an understanding of design principles and best practices when designing a BI solution. The target audience also includes BI developers with experience in using SQL Server 2008 BI features and tools, and who want to obtain a professional certification in BI development and design.

The secondary audience for this course is information technology (IT) professionals, and Business Analysts who specialize in the area of BI.

At Course Completion

After completing this course, students will be able to:

Design a Business Intelligence (BI) architecture in SQL Server 2008.
Design a strategy for implementing the extract, transform, load (ETL) processby using SQL Server 2008 Integration Services (SSIS).
Design a strategy for managing packages by using SSIS.
Design an online analytical processing (OLAP) solution architecture by using SQL Server 2008 Analysis Services (SSAS).
Design a physical storage for an OLAP solution by using SSAS.
Design an administration and maintenance strategy for an SSAS solution.
Design effective queries for an OLAP solution by using SSAS.
Design and develop a SQL Server 2008 Reporting Services (SSRS) solution architecture.
Design a strategy for deploying and managing an SSRS solution architecture.
Design data mining solutions by using SQL Server 2008.