Preparation Guide for Exam 74-131

Designing a Microsoft Office Enterprise Project Management (EPM) Solution

Published: March 29, 2007

On This Page
Exam newsExam news
Audience profileAudience profile
Preparation tools and resourcesPreparation tools and resources
Skills being measuredSkills being measured

Exam news

Exam 74-131 is a Technology Specialist exam.

Exam 74-131 became available December 9, 2004.

Top of pageTop of page

Audience profile

Business Analysts are experienced in project management leadership. A candidate for this exam should have at least one year of experience designing project management solutions.

Top of pageTop of page

Preparation tools and resources

We make a wealth of preparation tools and resources available to you, including courses, books, practice tests, and Microsoft Web sites. When you are ready to prepare for this exam, here is where you should start.

Classroom training for this exam

Please see Microsoft Office Enterprise Project Management University for all courseware resources

Microsoft online resources

Partner site: Designed for our partners, this site includes training, sales and marketing advice, events, and competency resources.

TechNet: Designed for IT professionals, this site includes how-to instructions, best practices, downloads, technical chats, and much more.

MSDN: The Microsoft Developer Network (MSDN) is a reference for developers, featuring code samples, technical articles, newsgroups, chats, and more.

Training and certification newsgroups: A newsgroup exists for every Microsoft certification. By participating in the ongoing dialogue, you take advantage of a unique opportunity to exchange ideas with and ask questions of others, including more than 750 Microsoft Most Valuable Professionals (MVPs) worldwide.

Top of pageTop of page

Skills being measured

This exam measures your ability to design an EPM Solution. Before taking the exam, you should be proficient in the job skills listed in the following matrix. The matrix shows which courses may help you reach competency in the skills being tested in the exam.

KEY:The course provides a general introductory overview of this task. You will need to supplement the course with additional work. = The course provides a general introductory overview of this task. You will need to supplement the course with additional work.    The course includes some material to prepare you for this task. You will need to supplement the course with additional work. = The course includes some material to prepare you for this task. You will need to supplement the course with additional work.    The course includes material to prepare you for this task. = The course includes material to prepare you for this task.
Skills measured by exam 74-131EPM University: Selling the EPM SolutionEPM University: Building an EPM VisionEPM University: Planning for EPM
Gathering business requirements for the enterprise project management solution    

Identify the current and planned project management environment. Considerations include:

The business problems you are trying to solve

The maturity of the project management environment

PMO structure

Scheduling

Planning

Reporting

Tracking of costs and resources

The risk management strategy

Identify the security needs

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.


The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Identify the organizational structure and constraints. Considerations include:

User profiles

Stakeholder analysis

Training/user education

Regulatory requirements

Financial situation

Gather localization requirements for language and currency.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.


The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Identify the current and planned IT environments. Considerations include scalability, extensibility, reliability, and availability requirements.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Identify the integration requirements for current and planned line of business (LOB) applications. Possible applications include:

Resource and human resources HR

Timesheets

Financial

Messaging

Integration with Intranet/extranet

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.


The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Analyze the business requirements for an enterprise project management solution    

Perform a gap analysis. Considerations include the difference between where you are and where you want to go, and the migration requirements.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.


The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Identify and track risks.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Evaluate project management processes.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.


The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Analyze implementation constraints.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.


The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Analyze project metrics.
Analyze impact on Total Cost of Ownership (TCO) (help desk, etc.).
Analyze Return on Investment (ROI).

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.


The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Design the EPM Solution    

Identify appropriate product features based on requirements.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.


The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Create the appropriate network infrastructure for an EPM solution.



The course includes material to prepare you for this task.

Create model configurations for Microsoft Office Project Server and services, Microsoft SQL Server, Microsoft Internet Services, Microsoft Office SharePoint technologies, Internet Explorer, and clients.



The course includes material to prepare you for this task.

Create and document enterprise features and templates. Considerations include:

Reporting requirements

Enterprise outline codes

Resource breakdown structure

Generic resources/skills

Standard calendars

System defaults



The course includes material to prepare you for this task.

Create and document the security configuration.



The course includes material to prepare you for this task.

Create user profile work flow diagrams.



The course includes material to prepare you for this task.

Build a prototype and validate against business requirements.



The course includes material to prepare you for this task.

Planning an EPM solution deployment    

Assemble a deployment team.



The course includes material to prepare you for this task.

Manage and evaluate the project planning process. Considerations include:

Budget plan

Communications plan

Support plans

Training plans

Security plan

Capacity plan

Software development plan

Test plan



The course includes material to prepare you for this task.

Create a migration plan.



The course includes material to prepare you for this task.

Create a deployment plan.
Define rollout phases.
Identify deployment dependencies.
Create deployment schedule.
Create a pilot plan.



The course includes material to prepare you for this task.

Document the project schedule by using Microsoft Office Project Professional.



The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Define success metrics.



The course includes material to prepare you for this task.

Deploy an EPM solution    

Validate deployment met plan.


The course includes material to prepare you for this task.


Validate solution-met business requirements.


The course includes material to prepare you for this task.


Note: This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use the exam objectives listed in this preparation guide to prepare for the exam, regardless of its format.

Learn more and download samples on the Testing Innovations page


Top of pageTop of page