Designing a Business Intelligence Solution by Using Microsoft SQL Server 2008

Admission

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.

Exam #

Duration

Language

Level

Type

Classroom

Code

Fees

English

Professional

Course

Classroom

Cs214

0 LE

Description :

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

Objectives :

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.

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

Recommended Knowledge :

• 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

Recommended Course(s) :

MCTS: SQL Server 2008, Business Intelligence Development and Maintenance

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

Category :
DataBase

The Instructor:

MISSION

learning process

Warm welcome

Quality assurance