You are a portfolio manager for an organization that uses Project Server 2013.
You plan to create several portfolio reports for the executive team.
You need to ensure that your first report shows a list of all projects in your organization with
timephased information regarding how the Actual Work and the Actual Cost have varied on a
monthly basis.
What should you do?
A.
Create a Project Center view with the following project fields: Name, Start Date, Finish Date,
Actual Work, and Actual Cost. Export the view to Microsoft Excel, and group the projects by using
the Finish Date column. Save the file into the Reports library in Project Web App (PWA).
B.
Create a Pivot Table in Microsoft Excel that gets data from the OLAP Portfolio Analyzer data
connection. Include the dimensions of Project List and Time, and the measures of Actual Work and
Actual Cost. Save the file into the Reports library in Project Web App (PWA).
C.
Create a Project Center view with the following project fields: Name, Start Date, Finish Date,
Actual Work, and Actual Cost. Export the view to Microsoft Excel, and group the projects by using
the Start Date column. Save the file into the Reports library in Project Web App (PWA).
D.
Create a Pivot Table in Microsoft Excel that gets data from the Project Server – Simple Projects List
data connection. Include the dimensions of Project List and Time, and the measures of Actual Work
and Actual Cost. Save the file into the Reports library in Project Web App (PWA).