| 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.