• Overview
• Outline
• Schedule

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.

Prerequites

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 StudioMicrosoft SQL Server Management StudioReport Builder and Report ManagerSource Code Control (SCC) product
• Possible experience in using the following tools:
• Microsoft Office VisioSystem Monitor

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.