MCITP: SQL Server 2005 Business Intelligence Learning and Certification Boot Camp

Code: BC-BI2794-7
Course duration: 5 days
Price:

MCITP: SQL Server 2005 Business Intelligence Learning and Certification Boot Camp

Course Code: BC-BI2794-7

Exam: 70-446 PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005
5 Day Instructor-led Bootcamp

Introduction

Microsoft Certified IT Professional: Business Intelligence Developer (MCITP: Business Intelligence Developer) is the premier certification for business intelligence system designers and developers. This certification demonstrates that you can design analysis solutions, data transformations, and reports.
Business intelligence developers design and implement multi-dimensional database models (logical and physical), data marts, data warehousing, data transforms, data analytics, and reporting solutions. This includes programming and customizing servers that use Multidimensional Expressions (MDX), customer transforms, and custom reporting solutions. Business intelligence developers are typically employed by mid-sized to large-sized organizations.

This boot camp event includes a test voucher for Technology Specialist exam 70-446, customized Microsoft Official Courseware, test prep material for the exam, and catered lunch and dinner on each day. A test center will be open on testing days until 8 PM for your testing convenience.

Training begins at 8 AM on each day and ends at 8 PM.

Module I of IV

2794-Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005

The purpose of this Module of the SQL Server 2005 Business Intelligence Learning and Certification Boot Camp is to teach Business Intelligence (BI) professionals working in enterprise environments to design a BI solution architecture. Students will be taught the importance of keeping all components of the solution and stages of the lifecycle in mind. The first day focuses on foundational standards and practices for the enterprise. The second day focuses on a project-specific lifecycle for capturing requirements and deriving a solution architecture.

After completing this module, students will be able to:

Capture the business and technical requirements for a Business Intelligence solution architecture.
Describe the major stages and requirements of a Business Intelligence project lifecycle.
Determine Business Intelligence development requirements and implement a Business Intelligence development project.
Assess and design a Business Intelligence infrastructure.
Describe and plan Business Intelligence operations and their management.

Module II of IV

2795-Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services

This module teaches Business Intelligence (BI) professionals working in enterprise environments to design an extract, transform, and load (ETL) solution that supports their BI solution. Students will learn how to plan an ETL solution, and specifically how to design and implement a SQL Server Integration Services (SSIS) based ETL solution. They will also learn how to monitor, optimize, and deploy an SSIS solution.

After completing this module, students will be able to:

Plan data transfer and staging solutions for an ETL operation.
Plan an SSIS Solution.
Design and implement data flows.
Incorporate logging, error handling, and reliability into a package.
Optimize an SSIS solution.
Deploy and operate an SSIS solution.

 

Module III of IV

2796-Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services

Design Analysis Solution Architecture can be difficult. Business intelligence (BI) professionals working in enterprise environments will learn how to design a multidimensional solution architecture that supports their BI solution. Students will go through the entire process-from capturing business and technical requirements, to deploying a multidimensional solution, to production. Students will also be taught to develop custom functionality and optimize a multidimensional solution.

After completing this module, students will be able to:

Capture the business and technical requirements for an analysis solution.

Design and implement a logical Online Analytical Processing (OLAP) solution architecture.

Design physical storage for a multidimensional solution.

Create calculated members and named sets.

Implement Key Performance Indicators (KPIs), actions, and stored procedures.

Course Reviews

No reviews found for this course.

Be the first to write a review