Description

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

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

·     Overview of BI Concepts

·     Planning BI Solutions

·     Planning the Development of a BI Solution

·     Determining BI Requirements

·     Determining Architectural Requirements of a BI Solution

·     Planning the Microsoft BI Environment

·     Overview of BI Operations Management

Designing a Strategy for Implementing ETL by Using Microsoft SQL Server 2008 Integration Services

·     Planning Data Sources and Destinations

·     Determining Staging Requirements

·     Planning SSIS Packages

·     Planning the Development of SSIS Packages

·     Designing Data Flow

·     Planning Data Flow Operations

·     Extending SSIS Packages with Scripts

Designing a Strategy for Managing Packages by Using Microsoft SQL Server 2008 Integration Services

·     Designing a Strategy for Logging ETL Operations

·     Designing a Strategy for Managing Errors

·     Designing and Implementing Reliable ETL Processes

·     Designing a Strategy for Deploying and Maintaining SSIS Packages

·     Designing a Strategy for Optimizing an SSIS Solution

Designing an OLAP Solution Architecture by Using Microsoft SQL Server 2008 Analysis Services

·     Overview of an OLAP Solution

·     Gathering Requirements for an OLAP Solution

·     Designing a Logical OLAP Solution Architecture

·     Designing Dimensions

·     Designing Dimension Relationships

·     Considerations for Implementing Cubes, KPIs, and Actions

·     Global Considerations for an SSAS Solution

Designing Physical Storage for an OLAP Solution by Using Microsoft SQL Server 2008 Analysis Services

·     Designing and Implementing Physical Storage for Dimensions

·     Designing and Implementing a Partitioning Strategy for Relational Data

·     Designing a Partitioning Strategy for Multidimensional Data

·     Designing Aggregations

Designing an Administration and Maintenance Strategy for a Microsoft SQL Server 2008 Analysis Services Solution

·     Determining SSAS Resource Requirements

·     Considerations for Providing SSAS Scalability

·     Considerations for Providing SSAS Availability

·     Planning and Implementing a Deployment Strategy for an SSAS Solution

·     Designing a Strategy for Monitoring an SSAS Solution

·     Securing an SSAS Solution

·     Designing a Strategy for Optimizing the Performance of SSAS

Designing Effective Queries for an OLAP Solution by Using Microsoft SQL Server 2008 Analysis Services

·     Designing Business Driven Calculations by Using MDX

·     Working with MDX Queries

·     Exploring MDX Query Context and Execution

·     Optimizing MDX Queries

·     Extending Multidimensional Expressions

Designing and Developing a Microsoft SQL Server 2008 Reporting Services Solution Architecture

·     Analyzing the Business Requirements for a Reporting Solution

·     Planning the Architecture for an SSRS Solution

·     Designing a Data Acquisition Strategy

·     Planning a Reporting Solution

·     Designing Report Models

·     Extending Reporting with Custom Code

Designing a Strategy for Deploying and Managing a Microsoft SQL Server 2008 Reporting Services Solution Architecture

·     Planning the Integration of Reports with Applications

·     Planning Security for a Reporting Solution

·     Planning Reports Distribution

·     Designing a Strategy for Managing Report Execution

·     Designing a Strategy for Optimizing Report Performance

·     Planning the Administration of SSRS

Designing Data Mining Solutions by Using Microsoft SQL Server 2008

·     Fundamentals of Data Mining

·     Designing a Mining Model and Structure

·     Designing Strategies for Staging Data

·     Visualizing Data Mining Results

·     Testing Mining Models

Training Materials :

Autodesk Official Training Courseware (AOTC)

Labs :

This course includes several labs to ensure you will gain the targeted skills and experience.

Credential :

Exam 70-452: PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008 credit toward the following certification(s): Microsoft Certified IT Professional (MCITP) Business Intelligence Developer 2008