The Business Intelligence Series provides knowledge and skills for
professionals who implement and design Microsoft SQL Server™
2005 Business Intelligence solutions.
Course Lisiting
ITNX 9023 SQL Server 2005 Business Intelligence Series (144 hrs) consists of the MCTS Series and the MCITP Series
ITNX 9024 MCTS: SQL Server 2005 Business Intelligence Series (72 hrs) consists of the courses below.
ITMT
2071 Implement Analysis Services for Business Intelligence Solutions
(24 hrs)
This course teaches students how to implement an Analysis Services
solution in an organization. The course discusses how to use the Analysis
Services development tools to create an Analysis Services database
and an OLAP cube, and how to use the Analysis Services management
and administrative tools to manage an Analysis Services solution.
MOC 2791.
Prerequisites: Experience using a Microsoft
Windows Operating System and Microsoft SQL Server 2005.
ITMT
2072 Implement Integration Services for Business Intelligence Solutions
(24 hrs)
This course teaches students how to implement an Integration Services
solution in an organization. The course discusses how to develop,
deploy, and manage Integration Services packages. MOC 2792.
Prerequisites:
ITMT 2071 Implement & Maintain Analysis Services for Microsoft
SQL Server 2005 Business Intelligence Solutions.
ITMT
2073 Implement Reporting Services for Business Intelligence Solutions
(24 hrs)
This course teaches students how to implement a Reporting Services
solution in an organization. The course discusses how to use the
Reporting Services development tools to create reports, and how
to use the Reporting Services management and administrative tools
to manage a Reporting Services solution. MOC 2793.
Prerequisites:
ITMT 2072 Implement & Maintain Integration Services for Microsoft
SQL Server 2005 Business Intelligence Solutions, or equivalent.
ITNX 9025 MCITP: SQL Server 2005 Business Intelligence Series (72 hrs) consists of the courses below.
ITMT
2074 Design Business Intelligence Solutions (16 hrs)
The purpose
of 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 course focuses on foundational
standards and practices for the enterprise and a project-specific
lifecycle for capturing requirements and deriving a solution architecture.
MOC 2794.
Prerequisites: ITNX 9024 Microsoft Certified Technology
Specialists in Microsoft SQL Server 2005 Business Intelligence, or
equivalent.
ITMT
2075 Design Business ETL Solutions (16 hrs)
The purpose of this course is to teach 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. MOC 2795.
Prerequisites: ITMT 2074 Design Business Intelligence
Solutions for Microsoft SQL Server 2005.
ITMT
2076 Design Analysis Solutions (24 hrs)
The purpose of this course is to teach business intelligence (BI)
professionals working in enterprise environments 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. MOC 2796.
Prerequisites: ITMT 2075 Design Business ETL Solutions
for Microsoft SQL Server 2005.
ITMT
2077 Design Reporting Solutions (16 hrs)
The purpose of this course is to teach Business Intelligence (BI)
professionals working in enterprise environments to design a reporting
solution architecture that supports their BI solution. Students
will go through the entire process—from identifying report
data to promoting the reporting solution to production. Students
will scale a reporting solution. Students will also be taught best
practices for collaborating with application developers to integrate
applications and reporting services. MOC 2797.
Prerequisites: ITMT 2076 Design Analysis Solutions
for Microsoft SQL Server 2005.
Course Prerequisites
MCTS Prerequisites: Experience using a Microsoft Windows Operating System and Microsoft SQL Server 2005
MCITP Prerequisites: MCTS or equivalent knowledge.