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

OBJETIVOS
The purpose of this course 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.

PARTICIPANTES
This course is intended for experienced BI and SQL Server DBA professionals. The target students for this course already have an understanding of how to use the SQL Server 2005 tools to design BI infrastructure and solutions, but need to develop their understanding of design principles and best practices when planning, implementing, and deploying a Business Intelligence architecture and solution.

EQUIPOS Y DURACIÓN
Se dispone de un ordenador por alumno. El curso tiene una duración de 10 horas (consultar los horarios disponibles en el calendario de New Horizons). El nº de plazas es limitado.

 

[Temario]

Introduction to Business Intelligence Architecture
Overview of Business Intelligence
Overview of Business Intelligence Architecture

Overview of the Business Intelligence Project Lifecycle
Planning a Business Intelligence Project
Determining Business Intelligence Requirements
Revising and Updating a Business Intelligence Project

Introduction to Business Intelligence Development
Overview of Business Intelligence Development
Managing Business Intelligence Development
Determining Data Management Process

Designing Business Intelligence Infrastructure
Determining Infrastructure Requirements
Designing the Infrastructure
Planning for Scalability and Availability

Managing Business Intelligence Operations
Overview of Business Intelligence Operations
Managing Maintenance and Operations Tasks
Managing Data Archiving
Managing Business Intelligence Operations for Business Continuity