MOC 50399 Designing a Business Intelligence Solution by Using Microsoft SQL Server 2008

    

Summary:
This course provides in-depth knowledge on designing a Business Intelligence solution by using Microsoft SQL Server 2008.

Duration:
5 Days/Lecture & Lab

Audience:
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.

Topics:

• Designing a Business Intelligence Architecture in Microsoft SQL Server 2008
• Designing a Strategy for Implementing ETL by Using Microsoft SQL Server 2008 Integration Services
• Designing a Strategy for Managing Packages by Using Microsoft SQL Server 2008 Integration Services
• Designing an OLAP Solution Architecture by Using Microsoft SQL Server 2008 Analysis Services
• Designing Physical Storage for an OLAP Solution by Using Microsoft SQL Server 2008 Analysis Services
• Designing an Administration and Maintenance Strategy for a Microsoft SQL Server 2008 Analysis Services Solution
• Designing Effective Queries for an OLAP Solution by Using Microsoft SQL Server 2008 Analysis Services
• Designing and Developing a Microsoft SQL Server 2008 Reporting Services Solution Architecture
• Designing a Strategy for Deploying and Managing a Microsoft SQL Server 2008 Reporting Services Solution Architecture
• Designing Data Mining Solutions by Using Microsoft SQL Server 2008

Prerequisites:
Before attending this course, students must have:-Knowledge of data warehousing, data marts, and industry-accepted Business Intelligence (BI) methodologies-Conceptual understanding of SQL Server 2005 and SQL Server 2008 components, such as online analytical processing (OLAP), extract, transform, load (ETL), and reporting tools and technologies-Experience in developing and implementing cubes at the physical level-Experience in working with data transformations -Experience in creating star and snowflake schemas at both conceptual and logical levels-Experience in writing MDX for customization and querying-Fundamental understanding of Microsoft Windows security, such as how groups, delegation of credentials, and impersonation function in a security context-Fundamental understanding of Web-based architecture -Experience in using the following tools:-Microsoft SQL Server BI Development Studio-Microsoft SQL Server Management Studio-Report Builder and Report Manager-Source Code Control (SCC) product-Possible experience in using the following tools:-Microsoft Office Visio-System Monitor

Last Update: May 22, 2012