Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 
Overview:  The purpose of this course is to teach Business Intelligence professionals working in enterprise environments to design a BI solution.
Course Duration:  2 Days. 
Course Format:  Instructor Led. 
Course Prerequisites: 

Participants should have conceptional understanding of Data marts, data wareshouses, BI and SQL Server 2005. 

Course Audience:  Experienced Business Intelligence and Microsoft SQL Server professionals 
Exam:  70-446 
Course Cost:  TBA 

Course Outline:

Module 1: Introduction to Business Intelligence Architecture

In this module, students will learn about key design principles that should be considered when scoping a BI solution, and about the components of the back end and front end of a BI solution, so that they can design and develop appropriate BI solutions for organizations.

After completing this module, students will be able to:

  • Describe the purpose and nature of a BI solution.
  • Identify the main components of a comprehensive BI architecture.

Module 2: Overview of the Business Intelligence Project Lifecycle

This module examines the core processes and requirements to achieve a successful Business Intelligence project.

After completing this module, students will be able to:

  • Describe the major components of a BI project lifecycle.
  • Determine requirements for a BI solution project.
  • Revise and update a BI project plan.

Module 3: Introduction to Business Intelligence Development

This module describes how to plan and manage the development process for a Business Intelligence project. It discusses considerations for assembling the development team, managing the development process, testing, and deploying the solution.

After completing this module, students will be able to:

  • Identify requirements and resources for implementing and managing a Business Intelligence development project.
  • Manage a Business Intelligence development project.
  • Determine effective data management processes.

Module 4: Designing Business Intelligence Infrastructure

This module describes how to identify infrastructure requirements for a Business Intelligence solution, and how to design an effective infrastructure to provide the required levels of scalability and availability.

After completing this module, students will be able to:

  • Determine infrastructure requirements for a BI solution.
  • Plan for scalability and availability.

Module 5: Managing Business Intelligence Operations

This module explains how to manage and operate a Business Intelligence solution.

After completing this module, students will be able to:

  • Manage BI operations.
  • Identify and plan maintenance and operations tasks for a BI solution.
  • Describe considerations for planning and implementing data archiving in a BI solution.
  • Describe business continuity and how it applies to BI operations.