This article describes how OnePager Pro, a reporting app for Microsoft Project, can pull in multiple subprojects and create a consolidated portfolio view. You can download a free trial of OnePager Pro to follow along.
Suppose there are three projects: Projects A, B, and C. They all share resources, and they compete for these resources. What we want to show here is how OnePager Pro can address resource conflicts by showing resource assignments across multiple projects. Here's how to get started:
- Filter your project plans using a flag column ("Flag 20" in Project C is shown below). This enables you to bring in only the important tasks and milestones into your portfolio report.
- Double-click the OnePager Pro button on your desktop. From the Start screen that appears, choose New.
- Select Project A.mpp as the first Microsoft Project source file. Then, click the Add/Remove button to launch the Data source selection dialog box, from which you can add Project B.mpp and Project C.mpp. Hit OK.
- Then, answer the simple questions in the wizard as shown below:
- Clicking the Create new chart button above generate the following portfolio timeline:
By default, OnePager Pro organizes the swimlanes (labels on the far left) by project name, and colors are assigned to each resource group (Team 1 through Team 4). However, this can be customized to meet your portfolio reporting requirements.
- What we want to see is how the tasks line up with respect to resources so we can look for potential resource conflicts across the portfolio. To do this, we click on the Chart Properties button on the OnePager Pro Home toolbar and select the Rows and Swimlanes tab. Then we tell OnePager Pro to organize the swimlanes by "Resource Names" as shown below:
- We can then go to the Task Bars tab and color-code each task based on the project name:
- Applying both of the above changes will refresh the portfolio report to look like this:
With this reorganization, not only do the team assignments to tasks stand out, but the color coding done by OnePager Pro assists in seeing how teams are assigned to tasks across different projects in the portfolio.
- You can now right-click on any task to add a comment box to highlight resource conflicts. You can also select two conflicting tasks and add a link between them to show the conflict as well:
The purpose of this article was to show you how OnePager Pro can represent multiple projects from a single Microsoft Project integrated master schedule, providing several ways to focus on resources across projects in a portfolio. OnePager Pro provides a versatile, clear, focused, and easy way to accomplish your portfolio reporting objectives.
OnePager Pro can help you create useful and effective PPM level presentations for executives, team members, and customers all using the same Microsoft Project plan.15-Day