|
Microsoft Exam 70-452 training course PRO- Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008 is intended for IT professionals design and plan business intelligence (BI) solutions by using Microsoft SQL Server 2008 BI tools. Students will learn how to design and manage reports, design data minining models, administer a BI solution, design the BI architecture, design and deploy SSIS packages and design an analysis services database.
When you pass this exam, you earn credit towards the following certifications: MCITP Business Intelligence Developer, SQL Server 2008.
This Microsoft Certified Course follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.
Instructor Introduction
Course Overview
Module 1: Designing a BI Solution
Module Overview
Data Management
Obtaining Data
BI Clients
Managing Development and Upgrades
Module Review
Module 2: Designing Integration Services
Module Overview
Control Flow
Data Flow
Transactions
Designing Custom Code
Package Design
Server Options
Module Review
Module 3: Designing Analysis Services
Module Overview
Cube Creation
Designing Dimensions and Measures
Enhancing Cubes
Performance
Cube Maintenance
Module Review
Module 4: Designing Data Mining Models
Module Overview
Model Design
Accessing Data and Setting Up a Mining Model
Module Review
Module 5: Designing report Services
Module Overview
Designing Reports
Designing a Report and Setting Up a Template
Designing Servers
Configuring Server Based Reports
Configuring Security
Implementing Report Builder
Module Review
Course Review
Exam Preparation
|
