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

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.

Lessons

Lab 1: Identifying Business Intelligence Solution Requirements

After completing this module, students will be able to:

Module 2: Overview of the Business Intelligence Project Lifecycle

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

Lessons

Lab 2: Planning a Business Intelligence Project

After completing this module, students will be able to:

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.

Lessons

Lab 3: Developing a Business Intelligence Solution

After completing this module, students will be able to:

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.

Lessons

Lab 4: Supporting Business Intelligence Infrastructure Growth

After completing this module, students will be able to:

Module 5: Managing Business Intelligence Operations

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

Lessons

Lab 5: Using Microsoft Operations Framework (MOF) to Manage Business Intelligence Operations

After completing this module, students will be able to: