How to Populate Data in the Project Portfolio Dashboard

How to Populate Data in the Project Portfolio Dashboard

Most organizations have separate sites for each of their projects, but at the very least, they maintain separate summary lists, task lists, issues lists, etc. for each project whether it is on separate sites within a site collection, or just Web Part Pages within a site.

To have your Project Summary List feed Project Portfolio Dashboard automatically, just follow these steps:

Step Action
1. Just add the Bamboo Project Dashboard Data Mapping Web Part to the same page where your Project Portfolio Dashboard is or add it to another page within the same site or site collection.
2.

Review the data in your Project Summary List and determine whether you want to add more choices to the Choice columns in the Project Portfolio Dashboard List so that they are available to you when you are mapping the choice values from your Project Summary List to the choice values in the mapped Project Portfolio Dashboard column.

For instance, if you have a Project Status column in the your Project Summary List where one of the statuses is “Open”, then you can modify the Project Status column in the Project Portfolio Dashboard List to add the “Open” status so you can map it directly or you can choose to just map the “Open” status to an already existing status in the Project Portfolio Dashboard List.

3. Configure the Bamboo Project Dashboard Data Mapping Web Part.

See Configuring the Bamboo Project Dashboard Data Mapping Web Part. You can choose to configure mappings individually for each Project Summary, or configure a single mapping to auto discover similar lists (i.e. Lists with the same name or Lists of the same type, like Tasks, Project Tasks, etc.) within or at the same level as the configured site.